error 604 detected in background process

[dbstudent]

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

 

[LKBrwnDBA]

If you issued normal shutdown it will wait until all transactions complete.

Issue IMMEDIATE and/or ABORT shutdownn if you do not want to wait.





----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[mancub]

I issued shutdown immediate and waited for 10 minutes and nothing happened.