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.