Our production database was slowing down and hanging during normal operation so we decided to reboot it. It hanged up and when i checked the alert log file i got the following error mesaage.
Active call for process 20507 user 'dbopr' program 'oracle@londata1 (TNS V1-V3)'
Active call for process 12338 user 'dbopr' program 'oracle@londata1 (TNS V1-V3)'
Active call for process 13011 user 'dbopr' program 'oracle@londata1 (TNS V1-V3)'
SHUTDOWN: waiting for active calls to complete.
Fri Jul 7 20:47:32 2006
Starting ORACLE instance (normal)
Starting ORACLE instance (normal)
oracle@londata1:/u01/app/oracle/admin/onedbsp1/bdump >
and this below from the .trc file
error 604 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00604: error occurred at recursive SQL level 2
ORA-01089: immediate shutdown in progress - no operations are permitted
oracle@londata1:/u01/app/oracle/admin/onedbsp1/bdump >
Version: Oracle 9i Enterprise Edition 9.2.0.4
Anybody have any ideas? Thanks in advance.
Dbstudent