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)
Saturday, November 5, 2016
Applying July 2016 PSU Patches (GI Patch - 23273629 & RDBMS Patch - 23054246) for Oracle 12c (12.1.0.2.0) - 3 Node RAC
Tuesday, November 1, 2016
Oracle GoldenGate - LOG dump utility
Login to Source Database (ORCL) as a user ‘scott’ SQL> connect scott/oracle@orcl Connected SQL> insert into dept values (75,'SQL SERVER','NY'); 1 row created. SQL> insert into dept values (76,'IBM DB2','NJ'); 1 row created. SQL> insert into dept values (77,'SYBASE','VA'); 1 row created. SQL> commit; Commit complete. SQL> select * from dept; DEPTNO DNAME LOC ---------- -------------- ---------- 75 SQL SERVER NY 76 IBM DB2 NJ 77 SYBASE VA 3 rows selected. Login to GGSCI from Source database: [oracle@linux66-ggs-11g-12c ~]$ source 11g.env [oracle@linux66-ggs-11g-12c ~]$ cd $GG [oracle@linux66-ggs-11g-12c 11g]$ ./logdump Oracle GoldenGate Log File Dump Utility for Oracle Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1 Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved. Logdump 89 >open dirdat/lt000007 Current LogTrail is /u01/app/ogg/11g/dirdat/lt000007 Logdump 90 >pos 0 Reading forward from RBA 0 Logdump 91 >detail data Logdump 92 >ghdr on Logdump 93 >filter include filename SCOTT.DEPT;filter string "VA";filter match all Logdump 94 >nSearch-1: Finding one more transaction using the string “NJ” Logdump 95 >filter include filename SCOTT.DEPT;filter string "NJ";filter match all Logdump 96 >n Note: Make it Position “0” and search again Logdump 97 >pos 0 Reading forward from RBA 0 Logdump 98 >filter include filename SCOTT.DEPT;filter string "NJ";filter match all Logdump 99 >nSearch-2: Find the transaction using the HEX decimal using “DEPT ID” coulmn (Dept ID : 77 and convert into HEX using calc utility) Logdump 105 >pos 0 Reading forward from RBA 0 Logdump 106 >filter clear Logdump 107 >filter filename SCOTT.DEPT; filter HEX "4D"; filter match all Logdump 108 >nLogdump 109>nLogdump 110>filter clear Note: Find the transaction using all the trail files Logdump 115 >ghdr on Logdump 116 >detail on Logdump 117 >filter filename SCOTT.DEPT; filter HEX "4D"; filter string "SYBASE"; filter match all Logdump 118 >count log /u01/app/ogg/11g/dirdat/lt* Current LogTrail is /u01/app/ogg/11g/dirdat/lt000003 LogTrail /u01/app/ogg/11g/dirdat/lt000003 has 0 records LogTrail /u01/app/ogg/11g/dirdat/lt000003 closed Current LogTrail is /u01/app/ogg/11g/dirdat/lt000001 LogTrail /u01/app/ogg/11g/dirdat/lt000001 has 0 records LogTrail /u01/app/ogg/11g/dirdat/lt000001 closed Current LogTrail is /u01/app/ogg/11g/dirdat/lt000005 LogTrail /u01/app/ogg/11g/dirdat/lt000005 has 0 records LogTrail /u01/app/ogg/11g/dirdat/lt000005 closed Current LogTrail is /u01/app/ogg/11g/dirdat/lt000007 LogTrail /u01/app/ogg/11g/dirdat/lt000007 has 1 records LogTrail /u01/app/ogg/11g/dirdat/lt000007 closed Current LogTrail is /u01/app/ogg/11g/dirdat/lt000006 LogTrail /u01/app/ogg/11g/dirdat/lt000006 has 0 records LogTrail /u01/app/ogg/11g/dirdat/lt000006 closed Current LogTrail is /u01/app/ogg/11g/dirdat/lt000002 LogTrail /u01/app/ogg/11g/dirdat/lt000002 has 0 records LogTrail /u01/app/ogg/11g/dirdat/lt000002 closed Current LogTrail is /u01/app/ogg/11g/dirdat/lt000000 LogTrail /u01/app/ogg/11g/dirdat/lt000000 has 0 records LogTrail /u01/app/ogg/11g/dirdat/lt000000 closed Current LogTrail is /u01/app/ogg/11g/dirdat/lt000004 LogTrail /u01/app/ogg/11g/dirdat/lt000004 has 0 records LogTrail /u01/app/ogg/11g/dirdat/lt000004 closed LogTrail /u01/app/ogg/11g/dirdat/lt* has 1 records Total Data Bytes 38 Avg Bytes/Record 38 Insert 1 After Images 1 Filtering matched 1 records suppressed 25 records Average of 1 Transactions Bytes/Trans ..... 86 Records/Trans ... 1 Files/Trans ..... 1 SCOTT.DEPT Partition 4 Total Data Bytes 38 Avg Bytes/Record 38 Insert 1 After Images 1 Login to Target Database (ORCLDB) as a user ‘scott’ SQL> connect scott/oracle@orcl Connected SQL> select * from dept; DEPTNO DNAME LOC ---------- -------------- ---------- 75 SQL SERVER NY 76 IBM DB2 NJ 77 SYBASE VA 3 rows selected. Login to GGSCI from Target database: [oracle@linux66-ggs-11g-12c ~]$ source 11g.env [oracle@linux66-ggs-11g-12c ~]$ cd $GG [oracle@linux66-ggs-11g-12c 11g]$ ./logdump Oracle GoldenGate Log File Dump Utility for Oracle Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1 Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved. Logdump 89 >open dirdat/lt000007 Current LogTrail is /u01/app/ogg/11g/dirdat/lt000007 Logdump 90 >pos 0 Reading forward from RBA 0 Logdump 91 >detail data Logdump 92 >ghdr on Logdump 93 >filter include filename SCOTT.DEPT;filter string "VA";filter match all Logdump 94 >n Finding one more transaction Logdump 95 >filter include filename SCOTT.DEPT;filter string "NJ";filter match all Logdump 96 >n Logdump 97 >pos 0 Reading forward from RBA 0 Logdump 98 >filter include filename SCOTT.DEPT;filter string "NJ";filter match all Logdump 99 >n
Subscribe to:
Posts (Atom)