When i run the command:
select comp_name,version,status from dba_registry;
some of the items show the status as INVALID.(Oracle database packages and types,oracle rules manager,oracle workspace manager,oracle expression filter,oracle multimedia)
What is the reason for this and how can i set them to VALID.
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:
https://oracle-base.com/articles/mis ... bjects.php
Check for invalid objects.
https://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
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 3 guests