CATPROC,XML,CATALOG INVALID
Can someone assist me with the below query
Catproc and Catalog are invalid:
SQL> select comp_id,comp_name,status from dba_registry;
COMP_ID
--------------------------------------------------------------------------------
COMP_NAME
--------------------------------------------------------------------------------
STATUS
---------------------------------
OWM
Oracle Workspace Manager
INVALID
CATALOG
Oracle Database Catalog Views
INVALID
CATPROC
Oracle Database Packages and Types
INVALID
startup upgrade error:
SQL> spool fix_cat_logfile.txt
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1670221824 bytes
Fixed Size 2228944 bytes
Variable Size 1157631280 bytes
Database Buffers 486539264 bytes
Redo Buffers 23822336 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE