Oracle Bundle Patch (linux)

Oracle Bundle Patch (linux)

 

 

 

Go to Sap Market Place:

Software Downloads –> Software downloads.

 

Database.

 

Oracle.

 

 

Here you choose the version you want.

 

Choose your version and save it by pressing on trolley or by click on it and save on your computer.

Read me – is very important because there are the steps. You can open it in some browser.

 

*Check the MOPATCH version

* We set the env at a time:
$IHRDBMS/bin/unzip -qd $IHRDBMS/sapbundle SAP12102P_1702-20012300.ZIP ‘SBP_12102170117_201702/OPatch/*’
mv $IHRDBMS/OPatch $IHRDBMS/OPatch-pre-SBP_12102170117_201702
mv $IHRDBMS/sapbundle/SBP_12102170117_201702/OPatch $IHRDBMS/OPatch
$IHRDBMS/bin/unzip -qd $IHRDBMS/sapbundle SAP12102P_1702-20012300.ZIP ‘SBP_12102170117_201702/MOPatch/*’
test -d $IHRDBMS/MOPatch && mv $IHRDBMS/MOPatch $IHRDBMS/MOPatch-pre-SBP_12102170117_201702
mv $IHRDBMS/sapbundle/SBP_12102170117_201702/MOPatch $IHRDBMS/MOPatch
*Install the SAP Bundle Patch(will take a while):

 

env ORACLE_HOME=$IHRDBMS $IHRDBMS/MOPatch/mopatch.sh -v -s SAP12102P_1702-20012300.ZIP

 

*next check the CFGTOOLLOGS:

 

cd /oracle/SID/121/cfgtoollogs

Start up the database instances, the listeners, and
other processes running from the Oracle Home.

listener start

su – oarcle

 

startup

*run the post-installation script catsbp(will take a while):
env ORACLE_HOME=$OHRDBMS $OHRDBMS/sapbundle/catsbp

 

*with oracle check again the version:

 

select * from dba_registry_history;

 

*with sqlplus set the parameters:

 

ALTER SYSTEM SET “_FIX_CONTROL”=
‘5099019:ON’,’5705630:ON’,’6055658:OFF’,’6120483:OFF’,’6399597:ON’,’6430500:ON’,
‘6440977:ON’,’6626018:ON’,’6972291:ON’,’7168184:OFF’,’7658097:ON’,’8937971:ON’,
‘9196440:ON’,’9495669:ON’,’13077335:ON’,’13627489:ON’,’14255600:ON’,’14595273:ON’,
‘18405517:2′,’20355502:8′,’14846352:OFF’,’22540411:ON’,’20107874:OFF’,’10038517:OFF’
COMMENT=’SAP_12102161018_201611 RECOMMENDED SETTINGS’
SCOPE=SPFILE;

 

ALTER SYSTEM SET EVENT=
‘10027’,
‘10028’,
‘10142’,
‘10183’,
‘10191’,
‘10995 level 2’,
‘38068 level 100’,
‘38085’,
‘38087’,
‘44951 level 1024′
COMMENT=’SAP_121022_201503 RECOMMENDED SETTINGS’
SCOPE=SPFILE

 

*commit;

 

*shutdown immediate;

*startup

*create pfile from spfile:

create pfile from spfile;

 

view initSID.ora

 

*cat $ORACLE_HOME/sapbundle/version.txt

*start the sap:

su – sidadm

startsap

 

$ORACLE_HOME/MOPatch/mopatch.sh -h

 

*to see the old version:

su – oracle

sqlplus / as sysdba

 

select * from dba_registry_history;

 

With WinSCP you can copy from your computer in linux in the location you have the software’s.(Here create a folder with the name of the sapbundle (F7).

#cd /Install/software/oracle/121/and the folder for sapbundle

(ex.  Bundle_version_SAPversion….. and inside of this folder you copy the bundle patch)

Now you can check on the os level if the copy was made successfully in /Install/software/oracle/and your folder.

 

*check the space with df -h

 

*From the initial location /Install/software/oracle, copy it in the oralce/SID/ and your location for bundle patch

 

First change the bundle extension from .zip into .ZIP

 

After that copy it.

 

So if you are in the location /Install/software/oracle/and your folder, we put the command:

 

cp -pr SAP_…..ZIP  /oracle/SID/121/and your location for sapbundle

 

 

*now we go in the location where we have copy it (oralce/SID/….)

 

Change the owner and the mod.

 

chown  (not with root) and put the name of the package.

 

chmod 755 and put the name of the package.

 

Next search the version for SBP.

 

*su – oracle

 

cat $ORACLE_HOME/sapbundle/version.txt

 

 

su – oracle

sqlplus / as sysdba

select * from dba_registry_history;

 

exit from sql

 

$ORACLE_HOME/OPatch/opatch version

$ORACLE_HOME/MOPatch/mopatch.sh -h

 

Very important when we set the environments, we do not close any more thee session until is finished and also the oracle user.

 

*with  oracle user:

 

cd /oracle/SID/121/your location for sapbundle

 

setenv IHRDBMS /oracle/SID/121

 

setenv OHRDBMS /oracle/SID/121

 

which fuser

 

setenv SBPFUSER
/bin/fuser

 

setenv SBPFUSER
/bin/fuser

 

*Now verify them:

 

env | grep -i HRDBMS

 

env | grep -i SBPFUSER

 

env | grep -i oracle_sid

 

pwd

 

cd /oracle/EED/121/sapbundle

 

$ORACLE_HOME/OPatch/opatch version

 

$ORACLE_HOME/MOPatch/mopatch.sh -h

 

$ORACLE_HOME/sapbundle/version*Next we extract the OPatch and MOPatch and install them in the Oracle Home (Readme 2.1-by turn not all at the same time):

$IHRDBMS/bin/unzip -qd $IHRDBMS/sapbundle SAP12102P_1702-20012300.ZIP ‘SBP_12102170117_201702/OPatch/*’

mv $IHRDBMS/OPatch $IHRDBMS/OPatch-pre-SBP_12102170117_201702

mv $IHRDBMS/sapbundle/SBP_12102170117_201702/OPatch $IHRDBMS/OPatch

$IHRDBMS/bin/unzip -qd $IHRDBMS/sapbundle SAP12102P_1702-20012300.ZIP ‘SBP_12102170117_201702/MOPatch/*’

test -d $IHRDBMS/MOPatch && mv $IHRDBMS/MOPatch $IHRDBMS/MOPatch-pre-SBP_12102170117_201702

mv $IHRDBMS/sapbundle/SBP_12102170117_201702/MOPatch $IHRDBMS/MOPatch

 

*Next we check in AL08 if there are users in the system.

 

*duplicate the session and: right click on the bar:

 

su -sidadm

 

stopsap

cleanipc “instance number” remove (ex: cleanipc 10 remove)
-also you can see the instance numbers in the /sapmnt/ SID/profile

*stop BRARCHIVE:

 

su – oracle

ps -ef | grep -i oracle

 

brarchive -u / -c force -f 3 stop

*stop the listener:

lsnrctl stop

*and stop any program that motorize your system.

*Check the SQL*Plus sessions (Readme 2.2.3)

$SBPFUSER $IHRDBMS/bin/oracle

 

*Install the SAP Bundle Patch as follows(Readme 2.2.4):

env ORACLE_HOME=$IHRDBMS $IHRDBMS/MOPatch/mopatch.sh -v -s SAP12102P_1702-20012300.ZIP

 

*Next start up the database instance, the listener, and other processes running from the Oracle Home:

su – oracle

 

listener start

 

su – oarcle

 

sqlplus / as sysdba

 

startup

sqlplus / as sysdba

 

select * from dba_registry_history;

sqlplus / as sydba
create pfile from spfile;

 

*cd /oracle/SID/121/dbs/

 

view initSID.ora

 

*cat $ORACLE_HOME/sapbundle/version.txt

 

*start the sap:

 

su – sidadm

 

startsap
The check all the processes go to :
su – sidadm
cd /sapmnt/SID/profile
for java: jsmon pf= (here put the location of the instance)
for abap dpmon: pf=…

 

In the error column must be nothing.

press q to exit

 

*Also in the DB02 transaction re-execute the CheckDB
Jobs –> DBA Planning Calendar
double click on CHECKDB and re-execute.

 

 

Leave a comment