11.2.0.4.0 DB Binaries Installation on Linux RAC-Enviroment:
Copy the below required files to one of the RAC node
p13390677_112040_Linux_x86_64_1of7.zip
p13390677_112040_Linux_x86_64_2of7.zip
Copy PSU and OPatch to all nodes of the RAC
p26030799_112040_Linux_x86_64.zip--PSU Patch
p6880880_112000_Linux_x86_64.zip---OPatch
Clean the Software Directory
Remove all previous installation software from oracle/software and change the directory group, So our personal ID's can copy software directly(dba group)
As a root on each node
cd /oracle/software
rm -fr database grid psu gpsu
chgrp dba /oracle/software
chmod 775 /oracle/software
Unzip the Database files
As oracle
unzip p13390677_112040_Linux_x86_64_1of7.zip
unzip p13390677_112040_Linux_x86_64_2of7.zip
Create RDBMS response file
As oracle
cd /oracle/software
grep -i ^[A-Z] database /response/db_install.rsp | sort > dbInstall.rsp
Modify the following variables as per RAC environment you are patching
DECLINE_SECURITY_UPDATES=true
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
oracle.install.db.CLUSTER_NODES=Testdb1,Testdb2
oracle.install.db.DBA_GROUP=oinstall
oracle.install.db.EEOptionsSelection=true
oracle.install.db.InstallEdition=EE
oracle.install.db.OPER_GROUP=dba
oracle.install.option=INSTALL_DB_SWONLY
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolal:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0
Deploy Software
As oracle
cd /oracle/software/database
./runInstaller -silent -response /oracle/software/dbInstall.rsp
Copy init.ora and tnsnames.ora files to new RDBMS Home
For each node:
. oraenv
cp -p $ORACLE_HOME/network/admin/tnsnames.ora /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin
For each database:
. oraenv
cp - p $ORACLE_HOME/dbs/init${ORACLE_SID}.ora ${ORACLE_HOME}/dbs/prapw${ORACLE_SID} \ /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs
Upgrade opatch on each node:
Run the following on each node
As oracle
cd ./u01/app/oracle/product/11.2.0.4/dbhome_1
unzip -o /oracle/software/p6880880_112000_Linux_x86_64.zip
Create OCM responce file
As oracle
The following command has 2 prompts:
1. Email address/User Name: Leave Blank
2. Do you wish to remain uninformed of security issues(Yes,No)N:Answer "Y"
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
${ORACLE_HOME}/OPatch/ocm/bin/emocmrsp -no banner -output /var /tmp/ocm.rsp
Example Output:
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
${ORACLE_HOME}/OPatch/ocm/bin/emocmrsp -no banner -output /var /tmp/ocm.rsp
Email address/User Name: Leave Blank
Do you wish to remain uninformed of security issues(Yes,No)N:Y
The OCM configuration response file (/var/tmp/ocm.rsp) was successfully created
Apply the latest PSU on each node
As oracle
RDBMS patch will be used:
cd /oracle/software
mkdir psu
cd psu
unzip ../p26030799_112040_Linux_x86_64.zip
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
${ORACLE_HOME}/OPatch/opatch apply /oracle/software/psu/p26030799 -oh ${ORACLE_HOME} -ocmrf /var/tmp/ocm.rsp
Verify the output mentions copying the PSU to all RAC nodes.
Example:
All nodes have been patched. you may start oracle instances on the local system and nodes...
Composite patch 26030799 successfully applied
OPatch session completed successfully with warnings.
Log file location:
/u01/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/opatch2018-05-28_18-56-09PM_1.log
Verify Installation:
As oracle
Verify software installed on all nodes
for node in ${nodes} ; do
ssh -q ${node} tail /u01/app/oraInventory/ContentsXML/inventory.xml
done
Verify PSU applied on all nodes.
for node in ${nodes} ; do
ssh -q ${node} ls /u01/app/oracle/product/11.2.0.4/dbhome_1/psu
done
=============================================================================================================
11.2.0.4.0 DB Binaries Installation on Linux Non-RAC-Enviroment:
Copy the below required files
p13390677_112040_Linux_x86_64_1of7.zip
p13390677_112040_Linux_x86_64_2of7.zip
Copy PSU and OPatch
p26030799_112040_Linux_x86_64.zip--PSU Patch
p6880880_112000_Linux_x86_64.zip---OPatch
Clean the Software Directory
Remove all previous installation software from oracle/software and change the directory group, So our personal ID's can copy software directly(dba group)
As a root
cd /oracle/software
rm -fr database grid psu gpsu
chgrp dba /oracle/software
chmod 775 /oracle/software
Unzip the Database files
As oracle
unzip p13390677_112040_Linux_x86_64_1of7.zip
unzip p13390677_112040_Linux_x86_64_2of7.zip
Create RDBMS response file
As oracle
cd /oracle/software
grep -i ^[A-Z] database /response/db_install.rsp | sort > dbInstall.rsp
Modify the following variables as per environment you are patching
DECLINE_SECURITY_UPDATES=true
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
oracle.install.db.DBA_GROUP=oinstall
oracle.install.db.EEOptionsSelection=true
oracle.install.db.InstallEdition=EE
oracle.install.db.OPER_GROUP=dba
oracle.install.option=INSTALL_DB_SWONLY
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolal:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0
Deploy Software
As oracle
cd /oracle/software/database
./runInstaller -silent -response /oracle/software/dbInstall.rsp
Copy init.ora and tnsnames.ora files to new RDBMS Home
For each node:
. oraenv
cp -p $ORACLE_HOME/network/admin/tnsnames.ora /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin
For each database:
. oraenv
cp - p $ORACLE_HOME/dbs/init${ORACLE_SID}.ora ${ORACLE_HOME}/dbs/prapw${ORACLE_SID} \ /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs
Upgrade opatch :
Run the following on each node
As oracle
cd ./u01/app/oracle/product/11.2.0.4/dbhome_1
unzip -o /oracle/software/p6880880_112000_Linux_x86_64.zip
Create OCM responce file
As oracle
The following command has 2 prompts:
1. Email address/User Name: Leave Blank
2. Do you wish to remain uninformed of security issues(Yes,No)N:Answer "Y"
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
${ORACLE_HOME}/OPatch/ocm/bin/emocmrsp -no banner -output /var /tmp/ocm.rsp
Example Output:
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
${ORACLE_HOME}/OPatch/ocm/bin/emocmrsp -no banner -output /var /tmp/ocm.rsp
Email address/User Name: Leave Blank
Do you wish to remain uninformed of security issues(Yes,No)N:Y
The OCM configuration response file (/var/tmp/ocm.rsp) was successfully created
Apply the latest PSU
As oracle
RDBMS patch will be used:
cd /oracle/software
mkdir psu
cd psu
unzip ../p26030799_112040_Linux_x86_64.zip
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
${ORACLE_HOME}/OPatch/opatch apply /oracle/software/psu/p26030799 -oh ${ORACLE_HOME} -ocmrf /var/tmp/ocm.rsp
Verify the output mentions copying the PSU to all RAC nodes.
Example:
All nodes have been patched. you may start oracle instances on the local system and nodes...
Composite patch 26030799 successfully applied
OPatch session completed successfully with warnings.
Log file location:
/u01/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/opatch2018-05-28_18-56-09PM_1.log
Verify Installation:
As oracle
Verify software installed on all nodes
for node in ${nodes} ; do
ssh -q ${node} tail /u01/app/oraInventory/ContentsXML/inventory.xml
done
Verify PSU applied .
for node in ${nodes} ; do
ssh -q ${node} ls /u01/app/oracle/product/11.2.0.4/dbhome_1/psu
done
************************************************** All The Best *********************************************
