Description:-
In this article we are going to see about Invalid Component of Oracle Database Packages and Types-catproc
Demo:-
Problem:-
- Invalid component of Oracle Database Packages and Types (catproc) after RU pathing on database.
- catproc.sql script needs to execute on startup upgrade mode and rebuild the component
Step:-1 Check the component state and startup upgrade mode
[oracle@oracledbwr ~]$ sqlplus / as sysdba
SQL*Plus: Release 21.0.0.0.0 – Production on Mon Apr 3 18:49:07 2023
Version 21.7.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1241512280 bytes
Fixed Size 9685336 bytes
Variable Size 704643072 bytes
Database Buffers 520093696 bytes
Redo Buffers 7090176 bytes
Database mounted.
Database opened.
SQL> SELECT comp_name, status, version FROM dba_registry where STATUS not like ‘VALID’;
COMP_NAME VERSION STATUS
—————————————- ———- ———-
Oracle Database Packages and Types 21.0.0.0.0 INVALID
Oracle Real Application Clusters 21.0.0.0.0 OPTION OFF
Step:-2 Execute the catproc database
SQL> @?/rdbms/admin/catproc.sql
SQL > @?/rdbms/admin/utlrp.sql
select owner, object_type, object_name from dba_objects where status =’INVALID’;
Step:-3 Restart the database after executing the scripts.
[oracle@oracledbwr ~]$ sqlplus / as sysdba
SQL*Plus: Release 21.0.0.0.0 – Production on Mon Apr 3 18:58:15 2023
Version 21.7.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 – Production
Version 21.7.0.0.0
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1241512280 bytes
Fixed Size 9685336 bytes
Variable Size 704643072 bytes
Database Buffers 520093696 bytes
Redo Buffers 7090176 bytes
Database mounted.
Database opened.
SQL> SELECT comp_name, status, version FROM dba_registry;
COMP_NAME VERSION STATUS
—————————————- ———- ———-
Oracle Database Packages and Types 21.0.0.0.0 VALID
Oracle Real Application Clusters 21.0.0.0.0 OPTION OFF
Connect with me on:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/hariprasathdba
