We also get the ORA-03113: end-of-file on communication channel error
but that is easily solved.
I've all over for answers but have come up with nothing. I don't
believe that it is an issue with the SHMMAX values or anything like
that because the database instance was previously running ok and
nothing has changed.
Any ideas or suggestions on the above problem would be greatly
appreciated. Has anyone else mistakenly linked and ran the db under
root? Solutions?
Are you getting any weird ipcs errors or shared areas left around when
you have the db shutdown (as shown by ipcs|grep ora)? What protection
did you set the oracle executable to? Is PMON not starting or
starting quickly then dying (maybe write a tight loop to grep ps)?
Turn on trace debugging in the init.ora.
jg
--
@home is bogus.
How 'bout that Peregrine, eh?
http://www.signonsandiego.com/news/uniontrib/wed/business/news_1b6peregrine.html
I don't get too much for error output. I do have shared areas left
around when the db tries to start. This causes the ora-03113 error
(which I end up clearing up using ipcrm).
As for permissions, the oracle executable has -rwsr-s--x owned by
oracle.
As for setting trace on, I've done that. I'm getting lots of dumps in
the $ORACLE_HOME/rdbms/log directory. They all pretty much have the
same output in each dump.