Catbundle apply steps after RDBMS 11g Patching
1: Catbundle apply and post installation script implementation –
Run the below steps to apply post install scripts and catbundle for all the databases running on 11G RDBMS home.
Post installation scripts implementation:
===========================================
Set environment
. oraenv 11g_DBname
Startup instance
Sqlplus /as sysdba
startup
Connect to DB and execeute below query:
sqlplus / as sysdba
spool invalid_obj_<db_name>_before.log
COLUMN object_name FORMAT A30
SELECT owner,object_type,object_name,status
FROM dba_objects WHERE status = ‘INVALID’ and OWNER=’SYS’;
spool off
—Make a note of the Invalid objects—
SQL> alter system set cluster_database=false scope=spfile;
SQL> SHUT IMMEDIATE
SQL> STARTUP UPGRADE
cd $ORACLE_HOME/sqlpatch/24917954
sqlplus / as sysdba
SQL> @postinstall.sql
SQL> alter system set cluster_database=true scope=spfile;
SQL> SHUT IMMEDIATE
SQL> STARTUP
Catbundle:
==========
Connect to the DB as SYS and
sql > @?/rdbms/admin/catbundle.sql exa apply
Step 2: Once catbundle apply is completed, run utlrp as below for all the databases
sql > @?/rdbms/admin/utlrp.sql
Step 3: Take the screenshot as below
set lines 200 pages 1000
col COMMENTS for a30
col ACTION_TIME for a40
col ACTION for a15
col NAMESPACE for a10
col BUNDLE_SERIES for a10
select * from sys.registry$history order by ACTION_TIME;
show parameter db_n
!hostname
Above query o/p will show the entry in registry$history
Execute the below query to get Invalid objects under SYS
COLUMN object_name FORMAT A30
SELECT owner,object_type,object_name,status
FROM dba_objects WHERE status = ‘INVALID’ and OWNER=’SYS’;
Compare this invalid objects with the list which we have taken before catbundle apply and We should not have any extra invalid objects on SYS
Repeat these steps for all 11G databases.