oracle 11g (11.2.0.4) CATPROC – oracle database packages and types invalid

when checking your database components after an upgrade or a patching, using the below query:

SQL> select * from dba_registry;

IF you found out that CATRPOC (oracle database packages and types) invalid

To fix this:

$sqlplus “/as sysdba”

SQL> startup upgrade

SQL > @?/rdbms/admin/catalog.sql

SQL > @?/rdbms/admin/catproc.sql

SQL > @?/rdbms/admin/utlrp.sql

 

Then you need to shutdown/startup the database in normal mode

SQL> shutdown immediate;

SQL> startup;

Then check the CATPROC component in your database.

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