Oracle SAP bundel SPB Patch Installation Step: ~ Blog for oracle RAC Goldengate Dataguard ASM database

Hello Friends's,

In this post we will discuss how to apply Sap bundel patch on oracle database

So Lets Get Started.

1.Place the patch on server.

2.Go through the readme doc.

3.Take Preinfo:


3.1 : create pfile from spfile;

3.2 :set lines 200 pages 900
     select name, open_mode from v$database;

3.3 :archive log list

3.4 :set lines 120
     select TABLESPACE_NAME,EXTENT_MANAGEMENT,contents from dba_tablespaces;

3.5 :select tablespace_name,sum(bytes/1024/1024) from dba_temp_files group by tablespace_name;

3.6 :select file_name,bytes/1024/1024 from dba_temp_files;

3.7 :col comp_name for a40
     set lines 120	
     select comp_name,status,version from dba_registry;

3.8 :show parameter NLS_LENGTH_SEMANTICS

3.9 :show parameter CLUSTER_DATABASE

3.10 :show parameter parallel_max_server

3.11 :show parameter undo_management

3.12 :show parameter job_queue_process

3.13 :show parameter remote_login_password

3.14 :show parameter spfile

3.15 :show parameter pga

3.16 :show parameter disk_as

3.17 :select object_type,count(*) from dba_objects group by object_type order by 1;

3.18 :select owner,count(*) from dba_objects group by owner order by 1;

3.19 :select owner,count(status) from dba_objects where status='INVALID' group by owner,status;

3.20 :col owner for a15
     col object_name for a35
     select OWNER,OBJECT_NAME,OBJECT_TYPE,status from DBA_OBJECTS where status = 'INVALID';

3.21 :select count(status),status,owner from dba_objects where status='INVALID' group by status,owner;

3.22 :col password for a20
     col username for a15
     col account_statu for a15
     set lines 120
     select USERNAME,PASSWORD,ACCOUNT_STATUS,PROFILE,EXPIRY_DATE from dba_users order by ACCOUNT_STATUS;

3.23 :select name,password from user$;

3.24 :select * from v$log;

3.25 :select PROPERTY_NAME,PROPERTY_VALUE from database_properties;

3.26 :col ACTION_TIME for a30
     col COMMENTS for a48
     col ACTION for a15
     col NAMESPACE for a15
     col BUNDLE_SERIES for a8
     col version for a15
     select * from registry$history;
	
3.27 :SELECT DISTINCT owner  FROM DBA_DEPENDENCIES   WHERE referenced_name 
 	IN ('UTL_TCP','UTL_SMTP','UTL_MAIL','UTL_HTTP','UTL_INADDR')
     	AND owner NOT IN ('SYS','ORDPLUGINS');

4.Use the following commands to determine the versions of the OPatch and MOPatch utilities installed in an Oracle Home:

$ORACLE_HOME/OPatch/opatch version $ORACLE_HOME/MOPatch/mopatch.sh -h

5.Once application team stop the app, run the archive db backup and stop the database/listener after backup completion.Comment the cron backup script.

6.Ask backup team to take backup of Oracle binary.

5.set IHRDBMS = $ORACLE_HOME and OHRDBMS =$ORACLE_HOME and verify

6.Take backup of OPatch and MOPatch utility and replace it with the required version(as per readme):


mv $IHRDBMS/OPatch $IHRDBMS/OPatch-pre-SBP_12201201020_202011
unzip -qd $IHRDBMS OPATCH12201P_2008-70001553.ZIP -x SIGNATURE.SMF
unzip -qd $IHRDBMS/sapbundle SAP12201P_2011-70001553.ZIP 'SBP_12201201020_202011/MOPatch/*'
test -d $IHRDBMS/MOPatch && mv $IHRDBMS/MOPatch $IHRDBMS/MOPatch-pre-SBP_12201201020_202011
mv $IHRDBMS/sapbundle/SBP_12201201020_202011/MOPatch $IHRDBMS/MOPatch

7.Verify the OPatch and MOpatch Version according to patch read me.

8.If any database using binary then stop all database and listener.

9.go into patch location which is in zip format and run below command.

For 19c Database extra step:

chmod 777 /oracle/DB1/19.0.0/bin/oradism

env ORACLE_HOME=$IHRDBMS $IHRDBMS/MOPatch/mopatch.sh -v -s SAP12201P_2011-70001553.ZIP

10.After patch apply on binary level then start DB/listener and run below command from OS level:

For 19c Database extra step:

alter system set "_kolfuseslf"=True scope=spfile; alter system set "_disable_directory_link_check"=True scope=spfile; Restart the database after patch apply

env ORACLE_HOME=$OHRDBMS $OHRDBMS/sapbundle/catsbp

11.Uncomment the cron backup script.And ask application team to start the application.

Oracle SAP bundel SPB Patch Installation Step:

Related Post