Home » RDBMS Server » Server Administration » error occurred at recursive SQL level 1 (ORACLE 10g,Linux)
error occurred at recursive SQL level 1 [message #359200] Fri, 14 November 2008 01:54 Go to next message
sounderraj.l
Messages: 10
Registered: November 2008
Location: Bangalore
Junior Member
Hi everybody...

During shutdown of database i am getting the following error.

Errors in file /u01/app/admin/nndb/udump/nndb_ora_15230.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 6
Sat Nov 8 07:29:51 2008

This error is generated during startup and shutdown of the database which is of oracle 10g 10.1.0.5.0

pls can anybody suggest me in solving this issue.

Thanks in advance
Re: error occurred at recursive SQL level 1 [message #359206 is a reply to message #359200] Fri, 14 November 2008 02:50 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Are you using OLAP in the database? If not, try to disable the OLAPISTARTUPTRIGGER and OLAPISHUTDOWNTRIGGER triggers.

SQL> ALTER TRIGGER olapistartuptrigger DISABLE;

Trigger altered.

SQL> ALTER TRIGGER olapishutdowntrigger DISABLE;

Trigger altered.


Best regards.

Frank
Re: error occurred at recursive SQL level 1 [message #359237 is a reply to message #359206] Fri, 14 November 2008 05:21 Go to previous message
sounderraj.l
Messages: 10
Registered: November 2008
Location: Bangalore
Junior Member
Thank u Frank

regards

Sounderraj.l
Previous Topic: low open file descriptor message
Next Topic: Pmon process in shared server configuration?
Goto Forum:
  


Current Time: Sun Dec 11 00:10:13 CST 2016

Total time taken to generate the page: 0.04782 seconds