Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

shutdown immediate hangs ORA-12012, ORA-12008, ORA-06512

584305Jun 21 2007 — edited Jun 26 2007
We have a problem while immediate shutting down the database:

alert.log:

Errors in file /data_archiv/oracle/admin/EGB/bdump/egb_j001_7708.trc:
ORA-12012: error on auto execute of job 3
ORA-12008: error in materialized view refresh path
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 1883
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2089
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Mon Jun 11 16:20:29 2007
Job queue slave processes stopped
Mon Jun 11 16:26:36 2007
Active call for process 7695 user 'oracle' program 'oracle@lxegbp2qs (J000)'
SHUTDOWN: waiting for active calls to complete.

Trace:
/data_archiv/oracle/admin/EGB/bdump/egb_j001_7708.trc
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /data_archiv/oracle/product/10g
System name: Linux
Node name: lxegbp2qs
Release: 2.6.5-7.244-smp
Version: #1 SMP Mon Dec 12 18:32:25 UTC 2005
Machine: i686
Instance name: EGB
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 7708, image: oracle@lxegbp2qs (J001)

*** SERVICE NAME:(SYS$USERS) 2007-06-11 16:20:28.759
*** SESSION ID:(273.1) 2007-06-11 16:20:28.759
*** 2007-06-11 16:20:28.759
ORA-12012: error on auto execute of job 3
ORA-12008: error in materialized view refresh path
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 1883
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2089
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1

The job with id 3 should not run during shut down (needs only seconds):
select substr(what, 1, 70), TO_CHAR(last_date, 'DD.MM.YYYY HH24:MI:SS') as last_date, TO_CHAR(next_date, 'DD.MM.YYYY SQL> HH24:MI:SS') as next_date from dba_jobs where job=3;

SUBSTR(WHAT,1,70)
----------------------------------------------------------------------
LAST_DATE NEXT_DATE
------------------- -------------------
dbms_refresh.refresh('"TEST"."MV_TEST"');
11.06.2007 06:00:06 12.06.2007 06:00:00

Any ideas where to look for?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 24 2007
Added on Jun 21 2007
#general-database-discussions
3 comments
1,357 views