This can happen during upgrades and patches. Especially if you have not followed the full path.
1) Make sure everything in your installation is valid. You can do this using the "$ORACLE_HOME/rdbms/admin/utlrp.sql" script. It is discussed here:http://www.oracle-base.com/articles/mis ... bjects.php
Check for invalid objects.http://www.oracle-base.com/dba/script.p ... bjects.sql
If anything is invalid, investigate and fix it. For example, if it is a procedure, do:
- Code: Select all
ALTER PROCEDURE my_proc COMPILE;
This will tell you why it fails to compile, so you can investigate and fix the issues.
2) Once everything is compiled, and working as normal, you can force the registry to say a different value, as discussed here:https://forums.oracle.com/forums/thread ... dID=896665