ORACLE pmon crashed - is recovery possible?
Date: 17 Nov 92 18:05:04 GMT
Message-ID: <30442_at_nntp_server.ems.cdc.com>
One of our Oracle-sid died mysteriously yesterday. I cannot bring it back up again.
The SID-id is "develop". It seems to be choking in reading it's control file, and thinks some other process is using the same id. I tried to reboot the machine, but result was the same error.
Oracle hotline was called; they don't know how to resolve this either.
SQLDBA> startup
ORACLE instance started.
ORA-00205: error in identifying control file 'cntrldevelop.dbf'
ORA-09782: sfifi: another instance has the same database mounted.
Attempting to shutdown instance........ORACLE instance shut down.
SQLDBA>
-This is in my alert log:
Error signalled in file: $ORACLE_HOME/rdbms/log/4_200.trc
ORA-00604: error occurred at recursive SQL level 1
ORA-00472: PMON process terminated with error
Mon Nov 16 15:11:19 1992
-This is in my trace file:
SMON: system monitor started
Mon Nov 16 14:52:09 1992
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-00472: PMON process terminated with error
Mon Nov 16 14:52:09 1992
SMON: error 472 detected in other detached process
Mon Nov 16 14:52:09 1992
SMON: system monitor exiting.
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00472: PMON process terminated with error
OPIRIP: Detached process complete.
Oracle support said to reinstall. Any other ideas would be greatly appreciated. Please e-mail to me and I will summarize.
Thanks!
--
Leila Schneberger leilas_at_ems.cdc.comReceived on Tue Nov 17 1992 - 19:05:04 CET