Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

CATPROC,XML,CATALOG INVALID

edited Jun 26, 2013 9:31AM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered
Hi ,

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:

find below 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center