STATUS of DBA_REGISTRY
582525Sep 19 2007 — edited Sep 19 2007Gurus, i need your help gurus
tonight, i will patch my database to 9.2.0.8 on solaris 10
i am confused about the status of my database registry
here are the registry status of my db
1rst Database
--------------------
SQL> select comp_name, version, status from dba_registry;
COMP_NAME VERSION STATUS
Oracle9i Catalog Views 9.2.0.1.0 INVALID
Oracle9i Packages and Types 9.2.0.4.0 VALID
Oracle Workspace Manager 9.2.0.1.0 VALID
JServer JAVA Virtual Machine 9.2.0.1.0 VALID
Oracle XDK for Java 9.2.0.2.0 VALID
Oracle9i Java Packages 9.2.0.1.0 VALID
Oracle interMedia 9.2.0.1.0 LOADED
Spatial 9.2.0.1.0 LOADED
Oracle Text 9.2.0.1.0 VALID
Oracle XML Database 9.2.0.1.0 INVALID
Oracle Ultra Search 9.2.0.1.0 VALID
Oracle Data Mining 9.2.0.1.0 LOADED
2nd database
--------------------
COMP_NAME VERSION STATUS
--------------------------------------------------------------
Oracle9i Catalog Views 9.2.0.4.0 VALID
Oracle9i Packages and Types 9.2.0.4.0 VALID
Oracle Workspace Manager 9.2.0.1.0 VALID
JServer JAVA Virtual Machine 9.2.0.4.0 VALID
Oracle XDK for Java 9.2.0.6.0 VALID
Oracle9i Java Packages 9.2.0.4.0 VALID
Oracle interMedia 9.2.0.4.0 VALID
Spatial 9.2.0.4.0 VALID
Oracle Text 9.2.0.4.0 VALID
Oracle XML Database 9.2.0.4.0 VALID
Oracle Ultra Search 9.2.0.4.0 INVALID
Oracle Data Mining 9.2.0.4.0 VALID
my question are:
- what is meant by LOADED status ?
- should i validate the INVALID or LOADED status first before I patch it to 9.2.0.8 ?
regards,
abip