Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

error 604 detected in background process

Status
Not open for further replies.

dbstudent

Programmer
Feb 14, 2006
26
US

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
 

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.

[3eyes]



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
I issued shutdown immediate and waited for 10 minutes and nothing happened.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top