1. Take backup of GRID and Oracle Database Home
===============================================
1.
[root@rac1-12c u01]# cd /u01/app/12.1.0.2/grid/
[root@rac1-12c grid]# pwd
/u01/app/12.1.0.2/grid
[root@rac1-12c u01]# tar -zcvf /u01/12c_GRID_Backup .
[root@rac1-12c u01]# ls -lrth
total 5.0G
drwxr-xr-x. 5 root oinstall 4.0K Oct 19 21:20 app
-rw-r--r-- 1 root root 5.0G Nov 5 16:53 12c_GRID_Backup
2.
[root@rac1-12c u01]# cd /u01/app/oracle/product/12.1.0.2/db_1/
[root@rac1-12c db_1]# tar -zcvf /u01/12c_ORACLE_DB_HOME_Backup .
[root@rac1-12c u01]# ls -lrth
total 8.1G
drwxr-xr-x. 5 root oinstall 4.0K Oct 19 21:20 app
-rw-r--r-- 1 root root 5.0G Nov 5 16:53 12c_GRID_Backup
-rw-r--r-- 1 root root 3.1G Nov 5 17:01 12c_ORACLE_DB_HOME_Backup
2. Upgrade OPatch version for Oracle GI Home and Oracle RDBMS Home for all 3 Nodes
===================================================================================
Using username "oracle".
oracle@192.168.2.101's password:
Last login: Fri Oct 21 07:56:09 2016 from 192.168.2.1
[oracle@rac1-12c sf_grid]$ unzip p6880880_121010_Linux-x86-64.zip -d /u01/app/12.1.0.2/grid/
Archive: p6880880_121010_Linux-x86-64.zip
replace /u01/app/12.1.0.2/grid/OPatch/datapatch? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
inflating: /u01/app/12.1.0.2/grid/OPatch/datapatch
inflating: /u01/app/12.1.0.2/grid/OPatch/operr
creating: /u01/app/12.1.0.2/grid/OPatch/modules/
---->Output Truncated----------------------->
[oracle@rac1-12c sf_grid]$ unzip p6880880_121010_Linux-x86-64.zip -d /u01/app/oracle/product/12.1.0.2/db_1/
Archive: p6880880_121010_Linux-x86-64.zip
replace /u01/app/oracle/product/12.1.0.2/db_1/OPatch/datapatch? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
inflating: /u01/app/oracle/product/12.1.0.2/db_1/OPatch/datapatch
inflating: /u01/app/oracle/product/12.1.0.2/db_1/OPatch/operr
creating: /u01/app/oracle/product/12.1.0.2/db_1/OPatch/modules/
---->Output Truncated----------------------->
[oracle@rac1-12c sf_grid]$ scp p6880880_121010_Linux-x86-64.zip oracle@rac2-12c:/tmp
p6880880_121010_Linux-x86-64.zip 100% 76MB 76.1MB/s 00:01
[oracle@rac1-12c sf_grid]$ scp p6880880_121010_Linux-x86-64.zip oracle@rac3-12c:/tmp
p6880880_121010_Linux-x86-64.zip 100% 76MB 76.1MB/s 00:01
[oracle@rac1-12c sf_grid]$ ssh rac2-12c
Last login: Fri Nov 4 13:51:34 2016 from rac1-12c.localdomain
[oracle@rac2-12c ~]$ cd /tmp/
[oracle@rac2-12c tmp]$ unzip p6880880_121010_Linux-x86-64.zip -d /u01/app/12.1.0.2/grid/
Archive: p6880880_121010_Linux-x86-64.zip
replace /u01/app/12.1.0.2/grid/OPatch/datapatch? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
inflating: /u01/app/12.1.0.2/grid/OPatch/datapatch
inflating: /u01/app/12.1.0.2/grid/OPatch/operr
creating: /u01/app/12.1.0.2/grid/OPatch/modules/
---->Output Truncated----------------------->
[oracle@rac2-12c tmp]$ unzip p6880880_121010_Linux-x86-64.zip -d /u01/app/oracle/product/12.1.0.2/db_1/
Archive: p6880880_121010_Linux-x86-64.zip
replace /u01/app/oracle/product/12.1.0.2/db_1/OPatch/datapatch? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
inflating: /u01/app/oracle/product/12.1.0.2/db_1/OPatch/datapatch
inflating: /u01/app/oracle/product/12.1.0.2/db_1/OPatch/operr
creating: /u01/app/oracle/product/12.1.0.2/db_1/OPatch/modules/
---->Output Truncated----------------------->
[oracle@rac2-12c tmp]$ ssh rac3-12c
Last login: Fri Nov 4 14:04:39 2016 from rac2-12c.localdomain
[oracle@rac3-12c ~]$ cd /tmp/
[oracle@rac3-12c tmp]$
[oracle@rac3-12c tmp]$ unzip p6880880_121010_Linux-x86-64.zip -d /u01/app/12.1.0.2/grid/
Archive: p6880880_121010_Linux-x86-64.zip
replace /u01/app/12.1.0.2/grid/OPatch/datapatch? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
inflating: /u01/app/12.1.0.2/grid/OPatch/datapatch
inflating: /u01/app/12.1.0.2/grid/OPatch/operr
creating: /u01/app/12.1.0.2/grid/OPatch/modules/
---->Output Truncated----------------------->
[oracle@rac3-12c tmp]$ unzip p6880880_121010_Linux-x86-64.zip -d /u01/app/oracle/product/12.1.0.2/db_1/
Archive: p6880880_121010_Linux-x86-64.zip
replace /u01/app/oracle/product/12.1.0.2/db_1/OPatch/datapatch? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
inflating: /u01/app/oracle/product/12.1.0.2/db_1/OPatch/datapatch
inflating: /u01/app/oracle/product/12.1.0.2/db_1/OPatch/operr
creating: /u01/app/oracle/product/12.1.0.2/db_1/OPatch/modules/
inflating: /u01/app/oracle/product/12.1.0.2/db_1/OPatch/modules/com.oracle.glcm.patch.opatchauto-wallet_13.9.1.1.jar
---->Output Truncated----------------------->
3. Apply July 2016 PSU Patch for both Oracle GI and Oracle RDBMS Home
======================================================================
[oracle@rac1-12c sf_grid]$ su - root
Password:
[root@rac1-12c ~]# cd /media/sf_grid/
[root@rac1-12c sf_grid]# ls -lrth
total 1.6G
drwxrwx--- 1 root vboxsf 4.0K Jul 5 10:07 23054246
drwxrwx--- 1 root vboxsf 4.0K Aug 1 02:08 23273629
-rwxrwx--- 1 root vboxsf 148K Aug 1 04:09 PatchSearch.xml
-rwxrwx--- 1 root vboxsf 209M Oct 29 19:44 p23054246_121020_Linux-x86-64.zip
-rwxrwx--- 1 root vboxsf 1.4G Oct 29 19:48 p23273629_121020_Linux-x86-64.zip
-rwxrwx--- 1 root vboxsf 77M Nov 1 15:45 p6880880_121010_Linux-x86-64.zip
[root@rac1-12c sf_grid]# sh /u01/app/12.1.0.2/grid/OPatch/opatchauto apply /media/sf_grid/23273629/
OPatchauto session is initiated at Fri Nov 4 14:20:13 2016
System initialization log file is /u01/app/12.1.0.2/grid/cfgtoollogs/opatchautodb/systemconfig2016-11-04_02-20-24PM.log.
Session log file is /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/opatchauto2016-11-04_02-20-42PM.log
The id for this session is I5AG
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0.2/db_1
Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0.2/grid
Patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Patch applicablity verified successfully on home /u01/app/12.1.0.2/grid
Verifying patch inventory on home /u01/app/oracle/product/12.1.0.2/db_1
Verifying patch inventory on home /u01/app/12.1.0.2/grid
Patch inventory verified successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Patch inventory verified successfully on home /u01/app/12.1.0.2/grid
Verifying SQL patch applicablity on home /u01/app/oracle/product/12.1.0.2/db_1
SQL patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Preparing to bring down database service on home /u01/app/oracle/product/12.1.0.2/db_1
Successfully prepared home /u01/app/oracle/product/12.1.0.2/db_1 to bring down database service
Bringing down CRS service on home /u01/app/12.1.0.2/grid
Prepatch operation log file location: /u01/app/12.1.0.2/grid/cfgtoollogs/crsconfig/
crspatch_rac1-12c_2016-11-04_02-23-27PM.log
CRS service brought down successfully on home /u01/app/12.1.0.2/grid
Performing prepatch operation on home /u01/app/oracle/product/12.1.0.2/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Start applying binary patch on home /u01/app/oracle/product/12.1.0.2/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Performing postpatch operation on home /u01/app/oracle/product/12.1.0.2/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Start applying binary patch on home /u01/app/12.1.0.2/grid
Binary patch applied successfully on home /u01/app/12.1.0.2/grid
Starting CRS service on home /u01/app/12.1.0.2/grid
Postpatch operation log file location: /u01/app/12.1.0.2/grid/cfgtoollogs/crsconfig/
crspatch_rac1-12c_2016-11-04_02-35-17PM.log
CRS service started successfully on home /u01/app/12.1.0.2/grid
Preparing home /u01/app/oracle/product/12.1.0.2/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.1.0.2/db_1 successfully after database service restarted
Trying to apply SQL patch on home /u01/app/oracle/product/12.1.0.2/db_1
SQL patch applied successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Verifying patches applied on home /u01/app/12.1.0.2/grid
Patch verification completed with warning on home /u01/app/12.1.0.2/grid
Verifying patches applied on home /u01/app/oracle/product/12.1.0.2/db_1
Patch verification completed with warning on home /u01/app/oracle/product/12.1.0.2/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac1-12c
RAC Home:/u01/app/oracle/product/12.1.0.2/db_1
Summary:
==Following patches were SKIPPED:
Patch: /media/sf_grid/23273629/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /media/sf_grid/23273629/23054341
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /media/sf_grid/23273629/23054246
Log: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_14-24-32PM_1.log
Patch: /media/sf_grid/23273629/23054327
Log: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_14-24-32PM_1.log
Host:rac1-12c
CRS Home:/u01/app/12.1.0.2/grid
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /media/sf_grid/23273629/21436941
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_14-27-20PM_1.log
Patch: /media/sf_grid/23273629/23054246
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_14-27-20PM_1.log
Patch: /media/sf_grid/23273629/23054327
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_14-27-20PM_1.log
Patch: /media/sf_grid/23273629/23054341
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_14-27-20PM_1.log
OPatchauto session completed at Fri Nov 4 14:43:05 2016
Time taken to complete the session 22 minutes, 52 seconds
4. Copy July 2016 PSU Patches to other cluster nodes (rac2-12c & rac3-12c)
===========================================================================
[root@rac1-12c sf_grid]# scp p23273629_121020_Linux-x86-64.zip oracle@rac2-12c:/u01/
oracle@rac2-12c's password:
p23273629_121020_Linux-x86-64.zip 100% 1353MB 58.8MB/s 00:23
[root@rac1-12c sf_grid]# scp p23054246_121020_Linux-x86-64.zip oracle@rac2-12c:/u01/
oracle@rac2-12c's password:
p23054246_121020_Linux-x86-64.zip 100% 209MB 69.6MB/s 00:03
You have mail in /var/spool/mail/root
[root@rac1-12c sf_grid]# scp p23273629_121020_Linux-x86-64.zip oracle@rac3-12c:/u01/
The authenticity of host 'rac3-12c (192.168.2.103)' can't be established.
RSA key fingerprint is dd:63:56:3a:97:6b:03:0c:b0:15:ea:2b:cd:a6:59:4b.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'rac3-12c,192.168.2.103' (RSA) to the list of known hosts.
oracle@rac3-12c's password:
p23273629_121020_Linux-x86-64.zip 100% 1353MB 75.1MB/s 00:18
[root@rac1-12c sf_grid]# scp p23054246_121020_Linux-x86-64.zip oracle@rac3-12c:/u01/
oracle@rac3-12c's password:
p23054246_121020_Linux-x86-64.zip 100% 209MB 69.6MB/s 00:03
5.unzip the folders Oracle GI and Oracle RDBMS July 2016 PSU Patches for Node-2 (rac2-12c)
==================================================================== =====================
[root@rac1-12c sf_grid]# ssh rac2-12c
root@rac2-12c's password:
Last login: Thu Oct 20 11:18:15 2016 from rac1-12c.localdomain
[root@rac2-12c ~]# su - oracle
[oracle@rac2-12c ~]$ cd /u01/
[oracle@rac2-12c u01]$ ls -lrth
total 1.6G
drwxrwxr-x. 5 oracle oinstall 4.0K Oct 19 21:52 app
-rwxr-x--- 1 oracle oinstall 1.4G Nov 4 14:52 p23273629_121020_Linux-x86-64.zip
-rwxr-x--- 1 oracle oinstall 209M Nov 4 14:52 p23054246_121020_Linux-x86-64.zip
[oracle@rac2-12c u01]$ unzip p23273629_121020_Linux-x86-64.zip
Archive: p23273629_121020_Linux-x86-64.zip
creating: 23273629/
creating: 23273629/23054327/
creating: 23273629/23054327/files/
creating: 23273629/23054327/files/inventory/
---->Output Truncated----------------------->
[oracle@rac2-12c u01]$ unzip p23054246_121020_Linux-x86-64.zip
Archive: p23054246_121020_Linux-x86-64.zip
creating: 23054246/
creating: 23054246/20299023/
creating: 23054246/20299023/etc/
creating: 23054246/20299023/etc/config/
inflating: 23054246/20299023/etc/config/inventory.xml
extracting: 23054246/README.txt
replace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: n
[oracle@rac2-12c u01]$
---->Output Truncated----------------------->
[root@rac2-12c ~]# cd /u01/
[root@rac2-12c u01]# ls -lrth
total 1.6G
drwxrwxr-x 9 oracle oinstall 4.0K Jul 5 10:07 23054246
drwxr-xr-x 7 oracle oinstall 4.0K Aug 1 02:08 23273629
-rw-rw-r-- 1 oracle oinstall 148K Aug 1 04:09 PatchSearch.xml
drwxrwxr-x. 5 oracle oinstall 4.0K Oct 19 21:52 app
-rwxr-x--- 1 oracle oinstall 1.4G Nov 4 14:52 p23273629_121020_Linux-x86-64.zip
-rwxr-x--- 1 oracle oinstall 209M Nov 4 14:52 p23054246_121020_Linux-x86-64.zip
[root@rac2-12c u01]# sh /u01/app/12.1.0.2/grid/OPatch/opatchauto apply /u01/23273629/
OPatchauto session is initiated at Fri Nov 4 15:04:59 2016
System initialization log file is /u01/app/12.1.0.2/grid/cfgtoollogs/opatchautodb/systemconfig2016-11-04_03-05-01PM.log.
Session log file is /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/opatchauto2016-11-04_03-05-32PM.log
The id for this session is 368E
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0.2/db_1
Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0.2/grid
Patch applicablity verified successfully on home /u01/app/12.1.0.2/grid
Patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Verifying patch inventory on home /u01/app/oracle/product/12.1.0.2/db_1
Verifying patch inventory on home /u01/app/12.1.0.2/grid
Patch inventory verified successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Patch inventory verified successfully on home /u01/app/12.1.0.2/grid
Verifying SQL patch applicablity on home /u01/app/oracle/product/12.1.0.2/db_1
SQL patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Preparing to bring down database service on home /u01/app/oracle/product/12.1.0.2/db_1
Successfully prepared home /u01/app/oracle/product/12.1.0.2/db_1 to bring down database service
Bringing down CRS service on home /u01/app/12.1.0.2/grid
Prepatch operation log file location: /u01/app/12.1.0.2/grid/cfgtoollogs/crsconfig/
crspatch_rac2-12c_2016-11-04_03-10-33PM.log
CRS service brought down successfully on home /u01/app/12.1.0.2/grid
Performing prepatch operation on home /u01/app/oracle/product/12.1.0.2/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Start applying binary patch on home /u01/app/oracle/product/12.1.0.2/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Performing postpatch operation on home /u01/app/oracle/product/12.1.0.2/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Start applying binary patch on home /u01/app/12.1.0.2/grid
Binary patch applied successfully on home /u01/app/12.1.0.2/grid
Starting CRS service on home /u01/app/12.1.0.2/grid
Postpatch operation log file location: /u01/app/12.1.0.2/grid/cfgtoollogs/crsconfig/
crspatch_rac2-12c_2016-11-04_03-19-23PM.log
CRS service started successfully on home /u01/app/12.1.0.2/grid
Preparing home /u01/app/oracle/product/12.1.0.2/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.1.0.2/db_1 successfully after database service restarted
Trying to apply SQL patch on home /u01/app/oracle/product/12.1.0.2/db_1
SQL patch applied successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Verifying patches applied on home /u01/app/12.1.0.2/grid
Patch verification completed with warning on home /u01/app/12.1.0.2/grid
Verifying patches applied on home /u01/app/oracle/product/12.1.0.2/db_1
Patch verification completed with warning on home /u01/app/oracle/product/12.1.0.2/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac2-12c
RAC Home:/u01/app/oracle/product/12.1.0.2/db_1
Summary:
==Following patches were SKIPPED:
Patch: /u01/23273629/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/23273629/23054341
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /u01/23273629/23054246
Log: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_15-11-28PM_1.log
Patch: /u01/23273629/23054327
Log: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_15-11-28PM_1.log
Host:rac2-12c
CRS Home:/u01/app/12.1.0.2/grid
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u01/23273629/21436941
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_15-13-47PM_1.log
Patch: /u01/23273629/23054246
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_15-13-47PM_1.log
Patch: /u01/23273629/23054327
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_15-13-47PM_1.log
Patch: /u01/23273629/23054341
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_15-13-47PM_1.log
OPatchauto session completed at Fri Nov 4 15:24:22 2016
Time taken to complete the session 19 minutes, 23 seconds
[root@rac2-12c u01]# ps -ef | grep pmon
oracle 14443 1 0 15:21 ? 00:00:00 asm_pmon_+ASM2
oracle 14832 1 0 15:21 ? 00:00:00 ora_pmon_orcl2
root 21076 17699 0 15:25 pts/0 00:00:00 grep pmon
[root@rac1-12c sf_grid]# ps -ef | grep pmon
oracle 23966 1 0 14:37 ? 00:00:00 asm_pmon_+ASM1
oracle 24334 1 0 14:37 ? 00:00:00 ora_pmon_orcl1
root 25031 342 0 15:25 pts/0 00:00:00 grep pmon
oracle 25319 1 0 14:38 ? 00:00:00 mdb_pmon_-MGMTDB
6. Login cluster node (rac3-12c) and unzip Oracle GI and Oracle RDBMS July 2016 Patches for Node-3 (rac3-12c)
=============================================================================================================
[root@rac1-12c sf_grid]# ssh rac3-12c
root@rac3-12c's password:
Last login: Thu Oct 20 11:18:30 2016 from rac2-12c.localdomain
[root@rac3-12c ~]# su - oracle
[oracle@rac3-12c ~]$ cd /u01/
[oracle@rac3-12c u01]$ ls -lrth
total 1.6G
drwxrwxr-x. 5 oracle oinstall 4.0K Oct 19 21:52 app
-rwxr-x--- 1 oracle oinstall 1.4G Nov 4 14:57 p23273629_121020_Linux-x86-64.zip
-rwxr-x--- 1 oracle oinstall 209M Nov 4 14:59 p23054246_121020_Linux-x86-64.zip
[oracle@rac3-12c u01]$ unzip p23273629_121020_Linux-x86-64.zip
Archive: p23273629_121020_Linux-x86-64.zip
creating: 23273629/
creating: 23273629/23054327/
creating: 23273629/23054327/files/
creating: 23273629/23054327/files/inventory/
creating: 23273629/23054327/files/inventory/Scripts/
creating: 23273629/23054327/files/inventory/Scripts/ext/
inflating: 23273629/23054246/23054246/etc/config/actions.xml
inflating: PatchSearch.xml
---->Output Truncated----------------------->
[oracle@rac3-12c u01]$ unzip p23054246_121020_Linux-x86-64.zip
Archive: p23054246_121020_Linux-x86-64.zip
creating: 23054246/
creating: 23054246/20299023/
creating: 23054246/20299023/etc/
creating: 23054246/20299023/etc/config/
inflating: 23054246/20299023/etc/config/inventory.xml
inflating: 23054246/20299023/etc/config/actions.xml
creating: 23054246/20299023/files/
creating: 23054246/20299023/files/rdbms/
---->Output Truncated----------------------->
[root@rac3-12c u01]# ls -lrth
total 1.6G
drwxrwxr-x 9 oracle oinstall 4.0K Jul 5 10:07 23054246
drwxr-xr-x 7 oracle oinstall 4.0K Aug 1 02:08 23273629
-rw-rw-r-- 1 oracle oinstall 148K Aug 1 04:09 PatchSearch.xml
drwxrwxr-x. 5 oracle oinstall 4.0K Oct 19 21:52 app
-rwxr-x--- 1 oracle oinstall 1.4G Nov 4 14:57 p23273629_121020_Linux-x86-64.zip
-rwxr-x--- 1 oracle oinstall 209M Nov 4 14:59 p23054246_121020_Linux-x86-64.zip
[root@rac3-12c u01]# sh /u01/app/12.1.0.2/grid/OPatch/opatchauto apply /u01/23273629/
OPatchauto session is initiated at Fri Nov 4 15:28:18 2016
System initialization log file is /u01/app/12.1.0.2/grid/cfgtoollogs/opatchautodb/systemconfig2016-11-04_03-28-20PM.log.
Session log file is /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/opatchauto2016-11-04_03-28-38PM.log
The id for this session is CJDU
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0.2/db_1
Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0.2/grid
Patch applicablity verified successfully on home /u01/app/12.1.0.2/grid
Patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Verifying patch inventory on home /u01/app/oracle/product/12.1.0.2/db_1
Verifying patch inventory on home /u01/app/12.1.0.2/grid
Patch inventory verified successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Patch inventory verified successfully on home /u01/app/12.1.0.2/grid
Verifying SQL patch applicablity on home /u01/app/oracle/product/12.1.0.2/db_1
SQL patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Preparing to bring down database service on home /u01/app/oracle/product/12.1.0.2/db_1
Successfully prepared home /u01/app/oracle/product/12.1.0.2/db_1 to bring down database service
Bringing down CRS service on home /u01/app/12.1.0.2/grid
Prepatch operation log file location: /u01/app/12.1.0.2/grid/cfgtoollogs/crsconfig/
crspatch_rac3-12c_2016-11-04_03-33-05PM.log
CRS service brought down successfully on home /u01/app/12.1.0.2/grid
Performing prepatch operation on home /u01/app/oracle/product/12.1.0.2/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Start applying binary patch on home /u01/app/oracle/product/12.1.0.2/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Performing postpatch operation on home /u01/app/oracle/product/12.1.0.2/db_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Start applying binary patch on home /u01/app/12.1.0.2/grid
Binary patch applied successfully on home /u01/app/12.1.0.2/grid
Starting CRS service on home /u01/app/12.1.0.2/grid
Postpatch operation log file location: /u01/app/12.1.0.2/grid/cfgtoollogs/crsconfig/
crspatch_rac3-12c_2016-11-04_03-42-01PM.log
CRS service started successfully on home /u01/app/12.1.0.2/grid
Preparing home /u01/app/oracle/product/12.1.0.2/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.1.0.2/db_1 successfully after database service restarted
Trying to apply SQL patch on home /u01/app/oracle/product/12.1.0.2/db_1
SQL patch applied successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Verifying patches applied on home /u01/app/12.1.0.2/grid
Patch verification completed with warning on home /u01/app/12.1.0.2/grid
Verifying patches applied on home /u01/app/oracle/product/12.1.0.2/db_1
Patch verification completed with warning on home /u01/app/oracle/product/12.1.0.2/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac3-12c
RAC Home:/u01/app/oracle/product/12.1.0.2/db_1
Summary:
==Following patches were SKIPPED:
Patch: /u01/23273629/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/23273629/23054341
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /u01/23273629/23054246
Log: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_15-34-01PM_1.log
Patch: /u01/23273629/23054327
Log: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_15-34-01PM_1.log
Host:rac3-12c
CRS Home:/u01/app/12.1.0.2/grid
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u01/23273629/21436941
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_15-36-23PM_1.log
Patch: /u01/23273629/23054246
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_15-36-23PM_1.log
Patch: /u01/23273629/23054327
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_15-36-23PM_1.log
Patch: /u01/23273629/23054341
Log: /u01/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-11-04_15-36-23PM_1.log
OPatchauto session completed at Fri Nov 4 15:47:52 2016
Time taken to complete the session 19 minutes, 35 seconds
[root@rac3-12c u01]#
7. Login to ORCL database and check the database instance (orcl)
==================================================================
[oracle@rac1-12c ~]$ . oraenv
ORACLE_SID = [orcl] ? orcl
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac1-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Nov 4 16:01:16 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect sys/oracle@orcl as sysdba
Connected.
SQL> col action_time format a30
SQL> col description format a60
SQL> set lines 300
SQL> select action_time, patch_id, patch_uid, version, status, bundle_series, description from dba_registry_sqlpatch;
ACTION_TIME PATCH_ID PATCH_UID VERSION STATUS BUNDLE_SERIES
------------------------------ ---------- ---------- -------------------- --------------- ------------------------------
04-NOV-16 03.47.30.689909 PM 23054246 20213895 12.1.0.2 SUCCESS PSU
DESCRIPTION
------------------------------------------------------
Database Patch Set Update : 12.1.0.2.160719 (23054246)
