PSU patch in upgrade
mode
1
Login to DB:---
[HPSM2]-->srvctl
status database -d HPSM -v
Instance
HPSM1 is running on node amxd1dbadm01 with online services
HPSM_APPS,HPSM_TO_OUS,HPSM_TO_US. Instance status: Open.
Instance HPSM2 is not
running on node amxd
[oracle@amxd:/HPSM1/ora01/product/12.1.0.2/network/admin]
[HPSM2]-->
2. Stop
the service :--
[HPSM2]-->srvctl stop
service -s HPSM_APPS,HPSM_TO_OUS,HPSM_TO_US -d HPSM -i HPSM1
3. STOP
the DB:--
[HPSM2]-->srvctl stop
instance -i HPSM1 -d HPSM -o immediate
[oracle@amxd:/HPSM2/ora01/product/12.1.0.2/network/admin]
[HPSM2]-->
4. Check
the conflict on Node 1 :--
[HPSM2]-->$ORACLE_HOME/OPatch/opatch
prereq CheckConflictAgainstOHWithDetail -phBaseDir
/u01/patches/BP/24968615/24732088
Oracle Interim Patch
Installer version 12.2.0.1.8
Copyright (c) 2017,
Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home
: /HPSM/ora01/product/12.1.0.2
Central Inventory :
/u01/app/oraInventory
from :
/HPSM/ora01/product/12.1.0.2/oraInst.loc
OPatch
version : 12.2.0.1.8
OUI
version : 12.1.0.2.0
Log file location :
/HPSM/ora01/product/12.1.0.2/cfgtoollogs/opatch/opatch2017-04-02_05-05-39AM_1.log
Invoking prereq
"checkconflictagainstohwithdetail"
Prereq
"checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@amxd:/HPSM1/ora01/product/12.1.0.2/network/admin]
[HPSM2]-->
5. Check
the conflict on Node 2 :--
[HPSM2]-->$ORACLE_HOME/OPatch/opatch
prereq CheckConflictAgainstOHWithDetail -phBaseDir
/u01/patches/BP/24968615/24732088
Oracle Interim Patch
Installer version 12.2.0.1.8
Copyright (c) 2017,
Oracle Corporation. All rights reserved.
PREREQ session
Oracle
Home : /HPSM/ora01/product/12.1.0.2
Central Inventory :
/u01/app/oraInventory
from :
/HPSM/ora01/product/12.1.0.2/oraInst.loc
OPatch
version : 12.2.0.1.8
OUI
version : 12.1.0.2.0
Log file location :
/HPSM/ora01/product/12.1.0.2/cfgtoollogs/opatch/opatch2017-04-02_05-06-08AM_1.log
Invoking prereq
"checkconflictagainstohwithdetail"
Prereq
"checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@amxd:/home/oracle]
[HPSM2]-->
6. Stop
the listener : [HPSM2]-->srvctl stop LISTENER -l HPSM
7. Sudo
su – root
8. Cd
/u01/patches
9. ./dbhomeupdate.sh
-h1 /HPSM/ora01/product/12.1.0.2 -h1b 24968615 -rolling ---- On
both the nodes as root user
------------------------------------
Example :
CRS sercviecs wil be shown post successfully deployment
-----------------------------------
10. Need
to start the DB in upgrade mode :--
sqlplus / as sysdba
startup nomount
show parameter cluster
if true -> set false
alter system set
cluster_database=false scope=spfile ;
shutdown immediate
startup upgrade
exit
cd $ORACLE_HOME/OPatch
./datapatch -apply
24732088
---------------------------------------------------
Example :--
[HPSM11]-->./datapatch
-apply 24732088
SQL
Patching tool version 12.1.0.2.0 Production on Sun Apr 2 05:40:08 2017
Copyright
(c) 2012, 2017, Oracle. All rights reserved.
Connecting
to database...OK
Bootstrapping
registry and package to current versions...done
Determining
current state...done
Adding
patches to installation queue and performing prereq checks...done
Installation
queue:
Nothing to roll back
The following patches will be applied:
24732088 (DATABASE BUNDLE PATCH 12.1.0.2.170117)
Installing
patches...
Patch
installation complete. Total patches installed: 1
Validating
logfiles...done
SQL
Patching tool complete on Sun Apr 2 05:42:07 2017
[oracle@amxd1dbadm01:/F12TRN1/ora01/product/12.1.0.2/OPatch]
---------------------------------------------
alter system set
cluster_database=true scope=spfile ;
shutdown immediate
srvctl start
instance -i HPSM1 -d HPSM
select PATCH_ID,
PATCH_UID, VERSION, STATUS, DESCRIPTION from DBA_REGISTRY_SQLPATCH order by
BUNDLE_SERIES;
No comments:
Post a Comment