After an upgrade “DBA_REGISTRY” status “INVALID”


Afte upgrade database 1 step checking below query:

SQL> SELECT COMP_NAME FROM DBA_REGISTRY WHERE STATUS='INVALID';
 COMP_NAME
 --------------------------------------------------------------------------------
 Oracle Text
 Spatial
 Oracle interMedia
 Oracle Data Mining
 Oracle Workspace Manager

it is problem. 😦   Let us try to solve this problem…

Step 1: Login as SYSDBA using the below command
 $ sqlplus “/as sysdba”
Step 2: Shutdown the database if it is running using the below command
 SQL> shutdown immediate
Step 3: SQL> startup ugrade;
Step 4: I ran the following sql files,
SQL>@$ORACLE_HOME/ctx/admin/ctxpatch.sql --Oracle Text
 SQL>@$ORACLE_HOME/md/admin/sdopatch.sql --Spatial
 SQL>@$ORACLE_HOME/ord/im/admin/impatch.sql -- Oracle Intermedia
 SQL>@$ORACLE_HOME/rdbms/admin/odmpatch.sql --Oracle Data Mining
 SQL>@$ORACLE_HOME/rdbms/admin/owmpatch.sql --Oracle Workspace Manager
 SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql - To recompile all the Invalid Objects
Step 5: SQL>Shutdown immediate;
Step 6: SQL>startup;
STEP 7: Re run the below query
 SELECT COMP_NAME FROM DBA_REGISTRY WHERE STATUS='INVALID';
 no rows selected

Problem solved 🙂

2 comments

  1. Well done. I expected that status changes from invalid to valid but it says upgraded now. Nevertheless, it worked so far.

    Hence: Typo at Step 3:
    SQL> startup ugrade;
    SQL> startup upgrade;

  2. Thank you for well feadback

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: