| error occurred at recursive SQL level 1 [message #359200] |
Fri, 14 November 2008 01:54  |
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  |
Frank Naude
Messages: 4581
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
