Oracle/PLSQL: ORA-06508 ora Error

Admin — Thu, 19 Feb 2009 16:47:11 GMT

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,

FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / ORA-00000 Through ORA-09989 / Oracle/PLSQL: ORA-06508 ora Error / Latest Posts

Oracle/PLSQL: ORA-06508 ora Error