ORA-01089: immediate shutdown in progress with dblink
chijarMay 25 2009 — edited May 26 2009dear all.
Facts:
Oracle Std edition 10g r2 10.2.0.1
RHEL AS linux version 4.
I connect through dblink from db1 to db2 in order to insert select millions of rows. Suddenly, the session shows me the next errors:
ERROR at line 1:
ORA-02068: following severe error from DB_PLELDS (this is my dblink)
ORA-01089: immediate shutdown in progress - no operations are permitted
My alert log shows :
Mon May 25 02:00:36 2009
Thread 1 advanced to log sequence 11180
Current log# 1 seq# 11180 mem# 0: /u01/app/oracle/oradata/plelds/redo01.log
Mon May 25 15:12:02 2009
Starting background process EMN0
EMN0 started with pid=21, OS id=3337
Mon May 25 15:12:02 2009
Shutting down instance: further logons disabled
Mon May 25 15:12:03 2009
Stopping background process CJQ0
Mon May 25 15:12:03 2009
Stopping background process QMNC
Mon May 25 15:12:05 2009
Stopping background process MMNL
Mon May 25 15:12:05 2009
Stopping background process MMON
Mon May 25 15:12:06 2009
Shutting down instance (immediate)
License high water mark = 3
Mon May 25 15:12:06 2009
Stopping Job queue slave processes
Mon May 25 15:12:06 2009
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Mon May 25 15:12:13 2009
ALTER DATABASE CLOSE NORMAL
Mon May 25 15:12:13 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon May 25 15:12:13 2009
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 11180
Successful close of redo thread 1
Mon May 25 15:12:13 2009
Completed: ALTER DATABASE CLOSE NORMAL
Mon May 25 15:12:13 2009
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon May 25 15:15:01 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
i think that this error is about queue, but in note 1014091.102 (metalink) doesn´t explain well. I have to add more job_queue_processes?
thanks a lot for your help.