 Posted 2/19/2009 4:47:11 PM
|
|
|
|
Recently we did an upgrade from 9.2 to 10g. After the upgrade we started seeing intermittent ORA-06508 along with ORA-06512 ora error codes.
We know everywhere we saw it shows the following:
We even opened up the TAR to find out what was going on back then and they weren't able to help at the time.
Error:
ORA-06508: PL/SQL: could not find program unit being called
Cause:
You tried to call a stored procedure, but the stored procedure could not be found.
Action:
The options to resolve this Oracle error are:
1. The stored procedure may have been dropped. Try re-creating the stored procedure.
2. The stored procedure may have compiled with errors. Try fixing the errors and re-compiling.
After doing some research and even search metalink we came across a solution from the oracle do***entation.
To resolve it you have to follow these steps:
Shutdown your oracle database.
Startup in migrate mode (9i) or upgrade mode(10g).
Then Run the following script:
SQL> @?/rdbms/admin/utlirp
The utlirp script is in the $ORACLE_HOME/rdbms/admin directory.
Restart the database in normal and continue the activity. If any invalid objects still exist in the database, please also run:
SQL> @?/rdbms/admin/utlrp
This operation should be done because utlirp recompiles the plsql objects and set their status to the status of the current release.
Hope this helps. Now this is all do***ented in metalink : 370137.1 for those of you that have metalink accounts and for those that don't. Stick around
so we can help you in many other ways without having to pay.
Thanks,
|
|
|
|