| Error in SYS.OLAPIHISTORYRETENTION procedure [message #117594] |
Thu, 28 April 2005 08:09  |
dzeljko
Messages: 19
Registered: April 2005
|
Junior Member |
|
|
Hello!
When I try to startup database I get next in the alert_.log file:
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 7
I can open database and work with it, but from time to time database has been totaly broken. I can see oracle's processes but I cant work with database.
Can anybody help me
|
|
|
|
| Re: Error in SYS.OLAPIHISTORYRETENTION procedure [message #118102 is a reply to message #117594] |
Tue, 03 May 2005 01:29  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Start SQL Trace at system level & observe the .trc file thus generated at startup of database in directory "USER_DUMP_DEST".
Don't forget to turn the trace off afterwards as turning on sql trace at system level for a long time may generate high amount of trace.
One more way is to run the catalog & catproc scripts again from ORACLE_HOME/rdbms/admin.... I hope this works.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
