Step-by-step guide on installing Oracle RAC 12.1.0.2 on RHEL7.3 (part IV)

6. Upgrade GI and Database software

It is recommended to install the latest bundle patch for GI and database. According to

Quick Reference to Patch Numbers for Database/GI PSU, SPU(CPU), Bundle Patches and Patchsets (Doc ID 1454618.1)

I chose 12.1.0.2.170117, patch No. 24968615.

6.1 Upgrade opatch (as grid and oracle on each node)

unzip p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME
opatch version
OPatch Version: 12.2.0.1.8

OPatch succeeded.

Since opatch 12.2.0.1.5, OCM file is not required during upgrade.

6.2 Upgrade GI

# as user grid and oracle, store current patch list

$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
mkdir /software/Bundle_Patch # make an empty directory
mv p24968615_121020_Linux-x86-64.zip Bundle_Patch/
cd Bundle_Patch
ls -l
unzip p24968615_121020_Linux-x86-64.zip

# as user grid, check whether there are patch conflicts

[grid@soradbs05 Bundle_Patch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /software/Bundle_Patch/24968615/24732088
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /oraapp/grid/gridhome
Central Inventory : /oraapp/grid/oraInventory
   from           : /oraapp/grid/gridhome/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /oraapp/grid/gridhome/cfgtoollogs/opatch/opatch2017-01-24_10-59-56AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@soradbs05 Bundle_Patch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /software/Bundle_Patch/24968615/25101514
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /oraapp/grid/gridhome
Central Inventory : /oraapp/grid/oraInventory
   from           : /oraapp/grid/gridhome/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /oraapp/grid/gridhome/cfgtoollogs/opatch/opatch2017-01-24_11-00-13AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@soradbs05 Bundle_Patch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /software/Bundle_Patch/24968615/24828643
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /oraapp/grid/gridhome
Central Inventory : /oraapp/grid/oraInventory
   from           : /oraapp/grid/gridhome/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /oraapp/grid/gridhome/cfgtoollogs/opatch/opatch2017-01-24_11-00-19AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@soradbs05 Bundle_Patch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /software/Bundle_Patch/24968615/21436941 
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /oraapp/grid/gridhome
Central Inventory : /oraapp/grid/oraInventory
   from           : /oraapp/grid/gridhome/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /oraapp/grid/gridhome/cfgtoollogs/opatch/opatch2017-01-24_11-00-24AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

# as user oracle, check whether there are patch conflicts

[oracle@soradbs05 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /software/Bundle_Patch/24968615/24732088
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /oraapp/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /oraapp/grid/oraInventory
   from           : /oraapp/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /oraapp/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2017-01-24_11-02-17AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@soradbs05 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /software/Bundle_Patch/24968615/25101514
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /oraapp/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /oraapp/grid/oraInventory
   from           : /oraapp/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /oraapp/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2017-01-24_11-02-25AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

# Check file system free space
# as user grid, vi /tmp/patch_list_gihome.txt, add the following lines:

/software/Bundle_Patch/24968615/24732088
/software/Bundle_Patch/24968615/25101514
/software/Bundle_Patch/24968615/24828643
/software/Bundle_Patch/24968615/21436941

[grid@soradbs05 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /oraapp/grid/gridhome
Central Inventory : /oraapp/grid/oraInventory
from : /oraapp/grid/gridhome/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /oraapp/grid/gridhome/cfgtoollogs/opatch/opatch2017-01-24_11-05-31AM_1.log

Invoking prereq “checksystemspace”

Prereq “checkSystemSpace” passed.

OPatch succeeded.

# as user oracle, vi /tmp/patch_list_dbhome.txt, add the following lines:

/software/Bundle_Patch/24968615/24732088
/software/Bundle_Patch/24968615/25101514
[oracle@soradbs05 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /oraapp/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /oraapp/grid/oraInventory
   from           : /oraapp/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /oraapp/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2017-01-24_11-07-23AM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

# upgrade GI as user root

umask 022
/oraapp/grid/gridhome/OPatch/opatchauto apply /software/Bundle_Patch/24968615
# This command will only upgrade GI
OPatchauto session is initiated at Tue Jan 24 14:05:18 2017

System initialization log file is /oraapp/grid/gridhome/cfgtoollogs/opatchautodb/systemconfig2017-01-24_02-05-19PM.log.

Session log file is /oraapp/grid/gridhome/cfgtoollogs/opatchauto/opatchauto2017-01-24_02-05-30PM.log
The id for this session is FFXP

Executing OPatch prereq operations to verify patch applicability on home /oraapp/grid/gridhome
Patch applicablity verified successfully on home /oraapp/grid/gridhome


Verifying patch inventory on home /oraapp/grid/gridhome
Patch inventory verified successfully on home /oraapp/grid/gridhome


Bringing down CRS service on home /oraapp/grid/gridhome
Prepatch operation log file location: /oraapp/grid/gridhome/cfgtoollogs/crsconfig/crspatch_soradbs06_2017-01-24_02-06-51PM.log
CRS service brought down successfully on home /oraapp/grid/gridhome


Start applying binary patch on home /oraapp/grid/gridhome
Binary patch applied successfully on home /oraapp/grid/gridhome


Starting CRS service on home /oraapp/grid/gridhome
Postpatch operation log file location: /oraapp/grid/gridhome/cfgtoollogs/crsconfig/crspatch_soradbs06_2017-01-24_02-14-19PM.log
CRS service started successfully on home /oraapp/grid/gridhome


Verifying patches applied on home /oraapp/grid/gridhome
Patch verification completed with warning on home /oraapp/grid/gridhome

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:soradbs06
CRS Home:/oraapp/grid/gridhome
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /software/Bundle_Patch/24968615/21436941
Log: /oraapp/grid/gridhome/cfgtoollogs/opatchauto/core/opatch/opatch2017-01-24_14-09-43PM_1.log

Patch: /software/Bundle_Patch/24968615/24732088
Log: /oraapp/grid/gridhome/cfgtoollogs/opatchauto/core/opatch/opatch2017-01-24_14-09-43PM_1.log

Patch: /software/Bundle_Patch/24968615/24828643
Log: /oraapp/grid/gridhome/cfgtoollogs/opatchauto/core/opatch/opatch2017-01-24_14-09-43PM_1.log

Patch: /software/Bundle_Patch/24968615/25101514
Log: /oraapp/grid/gridhome/cfgtoollogs/opatchauto/core/opatch/opatch2017-01-24_14-09-43PM_1.log



OPatchauto session completed at Tue Jan 24 14:16:50 2017
Time taken to complete the session 11 minutes, 32 seconds

su - grid
opatch lsinventory #check patch detail

6.3 Update Database

/oraapp/oracle/product/12.1.0.2/dbhome_1/OPatch/opatchauto apply /software/Bundle_Patch/24968615 -oh /oraapp/oracle/product/12.1.0.2/dbhome_1

OPatchauto session is initiated at Tue Jan 24 14:18:48 2017

System initialization log file is /oraapp/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2017-01-24_02-18-50PM.log.

Session log file is /oraapp/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatchauto/opatchauto2017-01-24_02-18-57PM.log
The id for this session is CI45

Executing OPatch prereq operations to verify patch applicability on home /oraapp/oracle/product/12.1.0.2/dbhome_1
Patch applicablity verified successfully on home /oraapp/oracle/product/12.1.0.2/dbhome_1


Verifying patch inventory on home /oraapp/oracle/product/12.1.0.2/dbhome_1
Patch inventory verified successfully on home /oraapp/oracle/product/12.1.0.2/dbhome_1


Verifying SQL patch applicablity on home /oraapp/oracle/product/12.1.0.2/dbhome_1
No step execution required.........
SQL patch applicablity verified successfully on home /oraapp/oracle/product/12.1.0.2/dbhome_1


Preparing to bring down database service on home /oraapp/oracle/product/12.1.0.2/dbhome_1
No step execution required.........
Successfully prepared home /oraapp/oracle/product/12.1.0.2/dbhome_1 to bring down database service


Bringing down database service on home /oraapp/oracle/product/12.1.0.2/dbhome_1
Database service successfully brought down on home /oraapp/oracle/product/12.1.0.2/dbhome_1


Performing prepatch operation on home /oraapp/oracle/product/12.1.0.2/dbhome_1
Perpatch operation completed successfully on home /oraapp/oracle/product/12.1.0.2/dbhome_1


Start applying binary patch on home /oraapp/oracle/product/12.1.0.2/dbhome_1
Binary patch applied successfully on home /oraapp/oracle/product/12.1.0.2/dbhome_1


Performing postpatch operation on home /oraapp/oracle/product/12.1.0.2/dbhome_1
Postpatch operation completed successfully on home /oraapp/oracle/product/12.1.0.2/dbhome_1


Starting database service on home /oraapp/oracle/product/12.1.0.2/dbhome_1
Database service successfully started on home /oraapp/oracle/product/12.1.0.2/dbhome_1


Preparing home /oraapp/oracle/product/12.1.0.2/dbhome_1 after database service restarted
No step execution required.........
Prepared home /oraapp/oracle/product/12.1.0.2/dbhome_1 successfully after database service restarted


Trying to apply SQL patch on home /oraapp/oracle/product/12.1.0.2/dbhome_1
No step execution required.........
SQL patch applied successfully on home /oraapp/oracle/product/12.1.0.2/dbhome_1


Verifying patches applied on home /oraapp/oracle/product/12.1.0.2/dbhome_1
Patch verification completed with warning on home /oraapp/oracle/product/12.1.0.2/dbhome_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:soradbs06
RAC Home:/oraapp/oracle/product/12.1.0.2/dbhome_1
Summary:

==Following patches were SKIPPED:

Patch: /software/Bundle_Patch/24968615/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /software/Bundle_Patch/24968615/24828643
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /software/Bundle_Patch/24968615/24732088
Log: /oraapp/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-01-24_14-19-44PM_1.log

Patch: /software/Bundle_Patch/24968615/25101514
Log: /oraapp/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-01-24_14-19-44PM_1.log



OPatchauto session completed at Tue Jan 24 14:22:34 2017
Time taken to complete the session 3 minutes, 46 seconds

su - oracle
opatch lsinventory

to be continued…

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s