Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

ORA-06512: at “SYS.OLAPIHISTORYRETENTION”, line 1

Posted by Hendry chinnapparaj on January 24, 2011

problem

—————–

SQL> startup pfile=initTEST.ora
ORACLE instance started.

Total System Global Area  314572800 bytes
Fixed Size                  2083760 bytes
Variable Size             100664400 bytes
Database Buffers          205520896 bytes
Redo Buffers                6303744 bytes
Database mounted.
ORA-03113: end-of-file on communication channel

The alert log has

replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1220658
Mon Jan 24 16:56:35 2011
Errors in file /u01/oracle/admin/TEST/udump/test_ora_2367508.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-12663: Services required by client not available on the server
ORA-36961: Oracle OLAP is not available.
ORA-06512: at “SYS.OLAPIHISTORYRETENTION”, line 1
ORA-06512: at line 15
Mon Jan 24 16:56:35 2011

and the trace file has

Instance name: TEST
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 2367508, image: oracle@uatu009 (TNS V1-V3)

*** ACTION NAME:() 2011-01-24 16:56:34.754
*** MODULE NAME:(sqlplus@uatu009 (TNS V1-V3)) 2011-01-24 16:56:34.754
*** SERVICE NAME:(SYS$USERS) 2011-01-24 16:56:34.754
*** SESSION ID:(160.3) 2011-01-24 16:56:34.754
kwqmnich: current time::  8: 56: 34
kwqmnich: instance no 0 check_only flag 1
kwqmnich: initialized job cache structure
Error in executing triggers on database startup
*** 2011-01-24 16:56:35.565
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-12663: Services required by client not available on the server
ORA-36961: Oracle OLAP is not available.
ORA-06512: at “SYS.OLAPIHISTORYRETENTION”, line 1
ORA-06512: at line 15

 

Solution

—————-

query for the triggers that fires when the database startsup and disable them

SQL> SELECT TRIGGER_NAME FROM DBA_TRIGGERS WHERE TRIGGERING_EVENT LIKE ‘%STARTUP%’
2  ;

TRIGGER_NAME
——————————
AURORA$SERVER$STARTUP
OLAPISTARTUPTRIGGER

SQL> alter trigger AURORA$SERVER$STARTUP disable;

Trigger altered.

SQL> alter trigger OLAPISTARTUPTRIGGER disable;

Trigger altered.

OLAP Trigger may not be needed in this case for us

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  314572800 bytes
Fixed Size                  2083760 bytes
Variable Size             100664400 bytes
Database Buffers          205520896 bytes
Redo Buffers                6303744 bytes
Database mounted.
Database opened.

 

No errors

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: