메뉴 건너뛰기

Korea Oracle User Group

Install/Configuration

19c RAC 2Node 설치-8 [ Patch ]

우뽕 2020.04.22 09:53 조회 수 : 1397

 초기에  db 를 완성 하기전 패치를 적용을 해도 됩니다.

 

1. 엔진 백업 

tar cvf /LOGS/grid_app.tar ./app
tar cvf oracle_app.tar ./app 

- 전체 노드 엔진 백업 해 주세요.
- 반드시 백업은 필수 입니다.

 

2.패치적용 ( auto 적용)

[root@db19c1(+ASM1):/dg] crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@db19c1(+ASM1):/dg] 
[root@db19c1(+ASM1):/dg] crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       db19c1                   STABLE
               ONLINE  OFFLINE      db19c2                   STABLE
ora.LISTENER_DB19C.lsnr
               ONLINE  ONLINE       db19c1                   STABLE
               ONLINE  OFFLINE      db19c2                   STABLE
ora.MGMT_DG.GHCHKPT.advm
               OFFLINE OFFLINE      db19c1                   STABLE
               OFFLINE OFFLINE      db19c2                   STABLE
ora.chad
               ONLINE  ONLINE       db19c1                   STABLE
               ONLINE  ONLINE       db19c2                   STABLE
ora.helper
               OFFLINE OFFLINE      db19c1                   IDLE,STABLE
               OFFLINE OFFLINE      db19c2                   IDLE,STABLE
ora.mgmt_dg.ghchkpt.acfs
               OFFLINE OFFLINE      db19c1                   STABLE
               OFFLINE OFFLINE      db19c2                   STABLE
ora.net1.network
               ONLINE  ONLINE       db19c1                   STABLE
               ONLINE  ONLINE       db19c2                   STABLE
ora.ons
               ONLINE  ONLINE       db19c1                   STABLE
               ONLINE  OFFLINE      db19c2                   STARTING
ora.proxy_advm
               OFFLINE OFFLINE      db19c1                   STABLE
               OFFLINE OFFLINE      db19c2                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       db19c1                   STABLE
      2        ONLINE  OFFLINE                               STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.DATA_DG.dg(ora.asmgroup)
      1        ONLINE  ONLINE       db19c1                   STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.FRA_DG.dg(ora.asmgroup)
      1        ONLINE  ONLINE       db19c1                   STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       db19c1                   STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       db19c1                   169.254.3.182 10.10.
                                                             20.55,STABLE
ora.MGMT_DG.dg(ora.asmgroup)
      1        ONLINE  ONLINE       db19c1                   STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.OCRVOT_DG.dg(ora.asmgroup)
      1        ONLINE  ONLINE       db19c1                   STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       db19c1                   Started,STABLE
      2        ONLINE  OFFLINE                               Instance Shutdown,ST
                                                             ABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       db19c1                   STABLE
      2        ONLINE  OFFLINE                               STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       db19c1                   STABLE
ora.db19c1.vip
      1        ONLINE  ONLINE       db19c1                   STABLE
ora.db19c2.vip
      1        ONLINE  OFFLINE      db19c2                   STARTING
ora.mgmtdb
      1        ONLINE  ONLINE       db19c1                   Open,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       db19c1                   STABLE
ora.rhpserver
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       db19c1                   STABLE
--------------------------------------------------------------------------------
[root@db19c1(+ASM1):/dg] 
[root@db19c1(+ASM1):/dg] 
[root@db19c1(+ASM1):/dg] 



The version output of the previous command should be 12.2.0.1.17 or later.
-- Opatch version 이상 설치 필요 



-- grid 1, 2번노드 동일 하게 
[root@db19c1(+ASM1):/db] mv /dg/app/product/gihome/OPatch /dg/app/product/gihome/OPatch_BK
[root@db19c1(+ASM1):/db] cp -R OPatch /dg/app/product/gihome/
[root@db19c1(+ASM1):/db] 
[root@db19c1(+ASM1):/db] chown -R grid:oinstall /dg/app/product/gihome/OPatch
[root@db19c1(+ASM1):/db]

[root@db19c1(+ASM1):/db] su - grid
Last login: Wed Apr 15 19:03:38 KST 2020 on pts/1
[grid@db19c1(+ASM1):/dg] 
[grid@db19c1(+ASM1):/dg] 
[grid@db19c1(+ASM1):/dg] opatch version
OPatch Version: 12.2.0.1.19

OPatch succeeded.
[grid@db19c1(+ASM1):/dg] 

-- db 2, 1번노드 동일 하게 
[root@db19c2 db]# mv /db/app/product/dbhome/OPatch /db/app/product/dbhome/OPatch_BK
[root@db19c2 db]# cp -R OPatch /db/app/product/dbhome/
[root@db19c2 db]# chown -R oracle:dba /db/app/product/dbhome/OPatch
[root@db19c2 db]# su - oracle
[oracle@db19c2(DBRAC2):/db]
[oracle@db19c2(DBRAC2):/db]
[oracle@db19c2(DBRAC2):/db]opatch version
OPatch Version: 12.2.0.1.19

OPatch succeeded.
[oracle@db19c2(DBRAC2):/db]



[oracle@db19c1(DBRAC1):/db]su - grid
Password: 
Last login: Thu Apr 16 22:49:20 KST 2020 on pts/3
[grid@db19c1(+ASM1):/dg] opatch lsinventory | grep Patch
Oracle Interim Patch Installer version 12.2.0.1.19
OPatch version    : 12.2.0.1.19
Patch  29585399     : applied on Thu Apr 18 16:36:24 KST 2019
Unique Patch ID:  22840393
Patch description:  "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
Patch  29517247     : applied on Thu Apr 18 16:36:02 KST 2019
Unique Patch ID:  22840392
Patch description:  "ACFS RELEASE UPDATE 19.3.0.0.0 (29517247)"
Patch  29517242     : applied on Thu Apr 18 16:35:39 KST 2019
Unique Patch ID:  22862832
Patch description:  "Database Release Update : 19.3.0.0.190416 (29517242)"
Patch  29401763     : applied on Thu Apr 18 16:35:16 KST 2019
Unique Patch ID:  22759421
Patch description:  "TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)"
OPatch succeeded.
[grid@db19c1(+ASM1):/dg] 

[oracle@db19c1(DBRAC1):/db] opatch lsinventory | grep Patch
Oracle Interim Patch Installer version 12.2.0.1.19
OPatch version    : 12.2.0.1.19
Patch  29585399     : applied on Thu Apr 18 16:21:33 KST 2019
Unique Patch ID:  22840393
Patch description:  "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
Patch  29517242     : applied on Thu Apr 18 16:21:17 KST 2019
Unique Patch ID:  22862832
Patch description:  "Database Release Update : 19.3.0.0.190416 (29517242)"
OPatch succeeded.
[oracle@db19c1(DBRAC1):/db]


[grid@db19c2(+ASM2):/dg] opatch lsinventory | grep Patch
Oracle Interim Patch Installer version 12.2.0.1.19
OPatch version    : 12.2.0.1.19
Patch  29585399     : applied on Thu Apr 18 16:36:24 KST 2019
Unique Patch ID:  22840393
Patch description:  "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
Patch  29517247     : applied on Thu Apr 18 16:36:02 KST 2019
Unique Patch ID:  22840392
Patch description:  "ACFS RELEASE UPDATE 19.3.0.0.0 (29517247)"
Patch  29517242     : applied on Thu Apr 18 16:35:39 KST 2019
Unique Patch ID:  22862832
Patch description:  "Database Release Update : 19.3.0.0.190416 (29517242)"
Patch  29401763     : applied on Thu Apr 18 16:35:16 KST 2019
Unique Patch ID:  22759421
Patch description:  "TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)"
OPatch succeeded.
[grid@db19c2(+ASM2):/dg] 

[oracle@db19c1(DBRAC1):/db] opatch lsinventory | grep Patch
Oracle Interim Patch Installer version 12.2.0.1.19
OPatch version    : 12.2.0.1.19
Patch  29585399     : applied on Thu Apr 18 16:21:33 KST 2019
Unique Patch ID:  22840393
Patch description:  "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
Patch  29517242     : applied on Thu Apr 18 16:21:17 KST 2019
Unique Patch ID:  22862832
Patch description:  "Database Release Update : 19.3.0.0.190416 (29517242)"
OPatch succeeded.
[oracle@db19c1(DBRAC1):/db]

===============================================================================================================
Patch Number Description Applicable Homes
=============== ========================================== =================================
30557433 Database Release Update 19.6.0.0.200114 Only DB Home for non-Oracle RAC setup.Both DB Homes and Grid Home for Oracle RAC setup.
30489227 OCW Release Update 19.6.0.0.200114 Both DB Homes and Grid Home
30489632 ACFS Release Update 19.6.0.0.200114 Footnote2 Only Grid Home
30655595 Tomcat Release Update 19.0.0.0.0Footnote 2 Only Grid Home


======================================================================================================================

For Grid Infrastructure Home, as home user:

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./30501910/30557433
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./30501910/30489227
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./30501910/30489632
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./30501910/30655595

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./30501910/

=============



[grid@db19c2(+ASM2):/dg] cd /PATCH
[grid@db19c2(+ASM2):/PATCH] $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./30501910/30557433
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /dg/app/product/gihome
Central Inventory : /dg/app/oraInventory
   from           : /dg/app/product/gihome/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /dg/app/product/gihome/cfgtoollogs/opatch/opatch2020-04-16_22-42-28PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@db19c2(+ASM2):/PATCH] $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./30501910/30489227
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /dg/app/product/gihome
Central Inventory : /dg/app/oraInventory
   from           : /dg/app/product/gihome/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /dg/app/product/gihome/cfgtoollogs/opatch/opatch2020-04-16_22-42-57PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@db19c2(+ASM2):/PATCH] $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./30501910/30489632
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /dg/app/product/gihome
Central Inventory : /dg/app/oraInventory
   from           : /dg/app/product/gihome/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /dg/app/product/gihome/cfgtoollogs/opatch/opatch2020-04-16_22-43-15PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@db19c2(+ASM2):/PATCH] $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./30501910/30655595
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /dg/app/product/gihome
Central Inventory : /dg/app/oraInventory
   from           : /dg/app/product/gihome/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /dg/app/product/gihome/cfgtoollogs/opatch/opatch2020-04-16_22-43-23PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[grid@db19c2(+ASM2):/PATCH] $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./30501910/
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /dg/app/product/gihome
Central Inventory : /dg/app/oraInventory
   from           : /dg/app/product/gihome/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.7.0
Log file location : /dg/app/product/gihome/cfgtoollogs/opatch/opatch2020-04-16_22-43-32PM_1.log

This command doesn't support System Patch.

OPatch failed with error code 21
[grid@db19c2(+ASM2):/PATCH] 
[grid@db19c2(+ASM2):/PATCH] su - root
Password: 
Last login: Thu Apr 16 22:16:14 KST 2020 from 192.168.0.5 on pts/2
[root@db19c2 ~]# 
[root@db19c2 ~]# 
[root@db19c2 ~]# 
[root@db19c2 ~]# cd /dg
[root@db19c2 dg]# 
[root@db19c2 dg]# . ./.bash_profile 
[root@db19c2(+ASM2):/dg] $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./30501910/
The user is root. OPatch cannot continue if the user is root.

OPatch failed with error code 255
[root@db19c2(+ASM2):/dg]
--> 무시 후 진행


[root@db19c1(+ASM1):/PATCH] id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@db19c1(+ASM1):/PATCH] echo $GRID_HOME
/dg/app/product/gihome
[root@db19c1(+ASM1):/PATCH] ps -ef | grep d.bin
root      4541  3351  0 22:57 pts/3    00:00:00 grep --color=auto d.bin
root     13923     1  2 22:34 ?        00:00:37 /dg/app/product/gihome/bin/ohasd.bin reboot
grid     14503     1  0 22:35 ?        00:00:01 /dg/app/product/gihome/bin/mdnsd.bin
grid     14504     1  0 22:35 ?        00:00:07 /dg/app/product/gihome/bin/evmd.bin
grid     14555     1  0 22:35 ?        00:00:02 /dg/app/product/gihome/bin/gpnpd.bin
grid     14733     1  0 22:35 ?        00:00:06 /dg/app/product/gihome/bin/gipcd.bin
root     14894     1  2 22:35 ?        00:00:34 /dg/app/product/gihome/bin/osysmond.bin
grid     14931     1  1 22:35 ?        00:00:15 /dg/app/product/gihome/bin/ocssd.bin
root     15478     1  0 22:36 ?        00:00:05 /dg/app/product/gihome/bin/octssd.bin reboot
root     15937     1  2 22:36 ?        00:00:24 /dg/app/product/gihome/bin/crsd.bin reboot
[root@db19c1(+ASM1):/PATCH] 


[grid@db19c2(+ASM2):/dg] ps -ef | grep d.bin
root      3289     1  1 22:39 ?        00:00:19 /dg/app/product/gihome/bin/ohasd.bin reboot
grid      3921     1  0 22:39 ?        00:00:05 /dg/app/product/gihome/bin/evmd.bin
grid      3922     1  0 22:39 ?        00:00:01 /dg/app/product/gihome/bin/mdnsd.bin
grid      3953     1  0 22:39 ?        00:00:02 /dg/app/product/gihome/bin/gpnpd.bin
grid      4025     1  0 22:39 ?        00:00:05 /dg/app/product/gihome/bin/gipcd.bin
root      4125     1  2 22:39 ?        00:00:23 /dg/app/product/gihome/bin/osysmond.bin
grid      4153     1  1 22:39 ?        00:00:13 /dg/app/product/gihome/bin/ocssd.bin
root      4729     1  0 22:40 ?        00:00:04 /dg/app/product/gihome/bin/octssd.bin reboot
root      4824     1  0 22:40 ?        00:00:09 /dg/app/product/gihome/bin/crsd.bin reboot
grid     20062 17824  0 22:57 pts/2    00:00:00 grep --color=auto d.bin
[grid@db19c2(+ASM2):/dg] 

## 1번 crs, 2번 crs 가 모두 구동된 상태입니다. 
## db sw 만 설치 된 상태 이므로 db가 설치는 되어 있지 않습니다.


*** 절대로 crs는 내리지 마세요. db는 정지를 해 주세요. 

2번노드가 죽었거나, 2번노드에서 현재 패치 수행 중 인 경우에서 1번 노드에서 만약 패치를 실행 하게 되면 
Patching Failed 메세지를 만나게 됩니다. 


아래 로그 확인 바랍니다. 


[root@db19c1(+ASM1):/dg/app/product/gihome/OPatch] opatchauto apply /PATCH/30501910 -oh /dg/app/product/gihome

OPatchauto session is initiated at Thu Apr 16 00:59:00 2020

System initialization log file is /dg/app/product/gihome/cfgtoollogs/opatchautodb/systemconfig2020-04-16_12-59-48AM.log.

Session log file is /dg/app/product/gihome/cfgtoollogs/opatchauto/opatchauto2020-04-16_01-03-13AM.log
The id for this session is BP8U

Executing OPatch prereq operations to verify patch applicability on home /dg/app/product/gihome
Patch applicability verified successfully on home /dg/app/product/gihome


Bringing down CRS service on home /dg/app/product/gihome
Failed to bring down CRS service on home /dg/app/product/gihome

Execution of [GIShutDownAction] patch action failed, check log for more details. Failures:
Patch Target : db19c1->/dg/app/product/gihome Type[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /dg/app/product/gihome, host: db19c1.
Command failed:  /dg/app/product/gihome/perl/bin/perl -I/dg/app/product/gihome/perl/lib -I/dg/app/product/gihome/OPatch/auto/dbtmp/bootstrap_db19c1/patchwork/crs/install -I/dg/app/product/gihome/OPatch/auto/dbtmp/bootstrap_db19c1/patchwork/xag /dg/app/product/gihome/OPatch/auto/dbtmp/bootstrap_db19c1/patchwork/crs/install/rootcrs.pl -prepatch
Command failure output: 
Using configuration parameter file: /dg/app/product/gihome/OPatch/auto/dbtmp/bootstrap_db19c1/patchwork/crs/install/crsconfig_params
The log of current session can be found at:
  /dg/app/grid_base/crsdata/db19c1/crsconfig/crs_prepatch_db19c1_2020-04-16_01-07-06AM.log
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [724960844].
CRS-1159: The cluster cannot be set to rolling patch mode because Oracle Clusterware is not active on at least one remote node.
CRS-4000: Command Start failed, or completed with errors.
2020/04/16 01:07:44 CLSRSC-430: Failed to start rolling patch mode 

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.

OPatchauto session completed at Thu Apr 16 01:07:50 2020
Time taken to complete the session 8 minutes, 52 seconds

 opatchauto failed with error code 42
[root@db19c1(+ASM1):/dg/app/product/gihome/OPatch] 


따라서 반드시 crs가 모든 노드에서 구동 중인 상태에서 한 노드에서 수행 완료 후 그 다음 노드를 진행해야 합니다.
그러면 전체 노드의 패치가 깔끔하게 마무리 될 것입니다.


[root@db19c1(+ASM1):/PATCH] opatchauto apply /PATCH/30501910 -oh /dg/app/product/gihome

OPatchauto session is initiated at Thu Apr 16 22:58:10 2020

System initialization log file is /dg/app/product/gihome/cfgtoollogs/opatchautodb/systemconfig2020-04-16_10-58-26PM.log.

Session log file is /dg/app/product/gihome/cfgtoollogs/opatchauto/opatchauto2020-04-16_11-00-47PM.log
The id for this session is 7VHG

Executing OPatch prereq operations to verify patch applicability on home /dg/app/product/gihome
Patch applicability verified successfully on home /dg/app/product/gihome


Bringing down CRS service on home /dg/app/product/gihome
CRS service brought down successfully on home /dg/app/product/gihome


Start applying binary patch on home /dg/app/product/gihome
Binary patch applied successfully on home /dg/app/product/gihome


Starting CRS service on home /dg/app/product/gihome

CRS service started successfully on home /dg/app/product/gihome

OPatchAuto successful.

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

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

Host:db19c1
CRS Home:/dg/app/product/gihome
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /PATCH/30501910/30489227
Log: /dg/app/product/gihome/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-16_23-10-00PM_1.log

Patch: /PATCH/30501910/30489632
Log: /dg/app/product/gihome/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-16_23-10-00PM_1.log

Patch: /PATCH/30501910/30557433
Log: /dg/app/product/gihome/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-16_23-10-00PM_1.log

Patch: /PATCH/30501910/30655595
Log: /dg/app/product/gihome/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-16_23-10-00PM_1.log



OPatchauto session completed at Thu Apr 16 23:31:25 2020
Time taken to complete the session 33 minutes, 16 seconds
[root@db19c1(+ASM1):/PATCH] 
[root@db19c1(+ASM1):/PATCH] su - grid
Last login: Thu Apr 16 23:41:08 KST 2020
[grid@db19c1(+ASM1):/dg] opatch lsinventory | grep Patch
Oracle Interim Patch Installer version 12.2.0.1.19
OPatch version    : 12.2.0.1.19
Patch  30655595     : applied on Thu Apr 16 23:20:03 KST 2020
Unique Patch ID:  23265660
Patch description:  "TOMCAT RELEASE UPDATE 19.0.0.0.0 (30655595)"
Patch  30557433     : applied on Thu Apr 16 23:15:49 KST 2020
Unique Patch ID:  23305305
Patch description:  "Database Release Update : 19.6.0.0.200114 (30557433)"
Patch  30489632     : applied on Thu Apr 16 23:12:08 KST 2020
Unique Patch ID:  23190753
Patch description:  "ACFS RELEASE UPDATE 19.6.0.0.0 (30489632)"
Patch  30489227     : applied on Thu Apr 16 23:11:03 KST 2020
Unique Patch ID:  23305624
Patch description:  "OCW RELEASE UPDATE 19.6.0.0.0 (30489227)"
OPatch succeeded.
[grid@db19c1(+ASM1):/dg] 



[root@db19c1(+ASM1):/PATCH] id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@db19c1(+ASM1):/PATCH] cd /db
[root@db19c1(+ASM1):/db] . ./.bash_profile 
[root@db19c1(DBRAC1):/db]echo $ORACLE_HOME
/db/app/product/dbhome
[root@db19c1(DBRAC1):/db]

[root@db19c1(DBRAC1):/PATCH]opatchauto apply /PATCH/30501910 -oh /db/app/product/dbhome

opatchauto must run from one of the homes specified
opatchauto returns with error code = 2
[root@db19c1(DBRAC1):/PATCH]
==> 같은 창에서 바로 db 패치를 수행을 하게 되면 위와 같은 에러 발생 .. 창을 닫고 다시 새로운 창을 열고 시도 

==> 새창에서 root유저에서 db 환경변수를 읽어 온다 
[root@db19c1 ~]# cd /db
[root@db19c1 db]# 
[root@db19c1 db]# . ./.bash_profile 
[root@db19c1(DBRAC1):/db]
[root@db19c1(DBRAC1):/db]id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@db19c1(DBRAC1):/db]cd /PATCH/
[root@db19c1(DBRAC1):/PATCH]opatchauto apply /PATCH/30501910 -oh /db/app/product/dbhome

OPatchauto session is initiated at Thu Apr 16 23:54:25 2020

System initialization log file is /db/app/product/dbhome/cfgtoollogs/opatchautodb/systemconfig2020-04-16_11-54-39PM.log.

Session log file is /db/app/product/dbhome/cfgtoollogs/opatchauto/opatchauto2020-04-16_11-56-57PM.log
The id for this session is 78FY

Executing OPatch prereq operations to verify patch applicability on home /db/app/product/dbhome
Patch applicability verified successfully on home /db/app/product/dbhome


Verifying SQL patch applicability on home /db/app/product/dbhome
No step execution required.........
 

Preparing to bring down database service on home /db/app/product/dbhome
No step execution required.........
 

Performing prepatch operation on home /db/app/product/dbhome
Perpatch operation completed successfully on home /db/app/product/dbhome


Start applying binary patch on home /db/app/product/dbhome
Binary patch applied successfully on home /db/app/product/dbhome


Performing postpatch operation on home /db/app/product/dbhome
Postpatch operation completed successfully on home /db/app/product/dbhome


Preparing home /db/app/product/dbhome after database service restarted
No step execution required.........
 

Trying to apply SQL patch on home /db/app/product/dbhome
No step execution required.........
 
OPatchAuto successful.

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

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

Host:db19c1
RAC Home:/db/app/product/dbhome
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /PATCH/30501910/30489632
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /PATCH/30501910/30655595
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /PATCH/30501910/30489227
Log: /db/app/product/dbhome/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-16_23-58-31PM_1.log

Patch: /PATCH/30501910/30557433
Log: /db/app/product/dbhome/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-16_23-58-31PM_1.log



OPatchauto session completed at Fri Apr 17 00:09:13 2020
Time taken to complete the session 14 minutes, 50 seconds
[root@db19c1(DBRAC1):/PATCH]
[root@db19c1(DBRAC1):/PATCH]su - oracle
Last login: Fri Apr 17 00:09:11 KST 2020
[oracle@db19c1(DBRAC1):/db]
[oracle@db19c1(DBRAC1):/db]opatch lsinventory | grep Patch
Oracle Interim Patch Installer version 12.2.0.1.19
OPatch version    : 12.2.0.1.19
Patch  30557433     : applied on Fri Apr 17 00:03:49 KST 2020
Unique Patch ID:  23305305
Patch description:  "Database Release Update : 19.6.0.0.200114 (30557433)"
Patch  30489227     : applied on Thu Apr 16 23:59:17 KST 2020
Unique Patch ID:  23305624
Patch description:  "OCW RELEASE UPDATE 19.6.0.0.0 (30489227)"
OPatch succeeded.
[oracle@db19c1(DBRAC1):/db]


==> 만약  db 까지 설치가 완료 된 상태 이면  1번노드 GRID, DB 패치 완료  후 다음 2번노드  GRID, DB 패치 수행 완료 후 최종 적인 작업 후 
    datapatch -verbose => utlrp.sql 수행 필요.


[grid@db19c2(+ASM2):/dg] opatch version
OPatch Version: 12.2.0.1.19

OPatch succeeded.
[grid@db19c2(+ASM2):/dg] 

[grid@db19c2(+ASM2):/dg] opatch lsinventory | grep Patch
Oracle Interim Patch Installer version 12.2.0.1.19
OPatch version    : 12.2.0.1.19
Patch  29585399     : applied on Thu Apr 18 16:36:24 KST 2019
Unique Patch ID:  22840393
Patch description:  "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"
Patch  29517247     : applied on Thu Apr 18 16:36:02 KST 2019
Unique Patch ID:  22840392
Patch description:  "ACFS RELEASE UPDATE 19.3.0.0.0 (29517247)"
Patch  29517242     : applied on Thu Apr 18 16:35:39 KST 2019
Unique Patch ID:  22862832
Patch description:  "Database Release Update : 19.3.0.0.190416 (29517242)"
Patch  29401763     : applied on Thu Apr 18 16:35:16 KST 2019
Unique Patch ID:  22759421
Patch description:  "TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)"
OPatch succeeded.
[grid@db19c2(+ASM2):/dg] 
[grid@db19c2(+ASM2):/dg]
[grid@db19c2(+ASM2):/dg] su - root
Password: 
[root@db19c2 ~]# 

root@db19c2 ~]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@db19c2 ~]# 
[root@db19c2 ~]# 
[root@db19c2 ~]# 
[root@db19c2 ~]# cd /dg
[root@db19c2 dg]# . ./.bash_profile 
[root@db19c2(+ASM2):/dg] cd /PATCH/
[root@db19c2(+ASM2):/PATCH] 
[root@db19c2(+ASM2):/PATCH] 
[root@db19c2(+ASM2):/PATCH] id    
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@db19c2(+ASM2):/PATCH] echo $GRID_HOME
/dg/app/product/gihome
[root@db19c2(+ASM2):/PATCH] echo $ORACLE_HOME
/dg/app/product/gihome
[root@db19c2(+ASM2):/PATCH] 

[root@db19c2(+ASM2):/PATCH] opatchauto apply /PATCH/30501910 -oh /dg/app/product/gihome

OPatchauto session is initiated at Fri Apr 17 00:10:54 2020

System initialization log file is /dg/app/product/gihome/cfgtoollogs/opatchautodb/systemconfig2020-04-17_12-11-23AM.log.

Session log file is /dg/app/product/gihome/cfgtoollogs/opatchauto/opatchauto2020-04-17_12-13-27AM.log
The id for this session is NLYE

Executing OPatch prereq operations to verify patch applicability on home /dg/app/product/gihome
Patch applicability verified successfully on home /dg/app/product/gihome


Bringing down CRS service on home /dg/app/product/gihome
CRS service brought down successfully on home /dg/app/product/gihome


Start applying binary patch on home /dg/app/product/gihome
Binary patch applied successfully on home /dg/app/product/gihome


Starting CRS service on home /dg/app/product/gihome


--> 시간이 많이 걸림..  ??? 


CRS service started successfully on home /dg/app/product/gihome

OPatchAuto successful.

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

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

Host:db19c2
CRS Home:/dg/app/product/gihome
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /PATCH/30501910/30489227
Log: /dg/app/product/gihome/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-17_00-22-05AM_1.log

Patch: /PATCH/30501910/30489632
Log: /dg/app/product/gihome/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-17_00-22-05AM_1.log

Patch: /PATCH/30501910/30557433
Log: /dg/app/product/gihome/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-17_00-22-05AM_1.log

Patch: /PATCH/30501910/30655595
Log: /dg/app/product/gihome/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-17_00-22-05AM_1.log



OPatchauto session completed at Fri Apr 17 01:14:19 2020
Time taken to complete the session 63 minutes, 27 seconds
[root@db19c2(+ASM2):/PATCH] 

[grid@db19c2(+ASM2):/dg] opatch lsinventory | grep Patch
Oracle Interim Patch Installer version 12.2.0.1.19
OPatch version    : 12.2.0.1.19
Patch  30655595     : applied on Fri Apr 17 00:32:53 KST 2020
Unique Patch ID:  23265660
Patch description:  "TOMCAT RELEASE UPDATE 19.0.0.0.0 (30655595)"
Patch  30557433     : applied on Fri Apr 17 00:28:31 KST 2020
Unique Patch ID:  23305305
Patch description:  "Database Release Update : 19.6.0.0.200114 (30557433)"
Patch  30489632     : applied on Fri Apr 17 00:24:39 KST 2020
Unique Patch ID:  23190753
Patch description:  "ACFS RELEASE UPDATE 19.6.0.0.0 (30489632)"
Patch  30489227     : applied on Fri Apr 17 00:23:34 KST 2020
Unique Patch ID:  23305624
Patch description:  "OCW RELEASE UPDATE 19.6.0.0.0 (30489227)"
OPatch succeeded.
[grid@db19c2(+ASM2):/dg] 


-- 패치중 에러 발생 되는 부분이 있으니 잘 참고 해 주시길 바랍니다.

[root@db19c2(DBRAC2):/PATCH]opatchauto apply /PATCH/30501910 -oh /db/app/product/dbhome

OPatchauto session is initiated at Fri Apr 17 01:16:27 2020

System initialization log file is /db/app/product/dbhome/cfgtoollogs/opatchautodb/systemconfig2020-04-17_01-16-43AM.log.

Session log file is /db/app/product/dbhome/cfgtoollogs/opatchauto/opatchauto2020-04-17_01-19-34AM.log
The id for this session is 17LC

Executing OPatch prereq operations to verify patch applicability on home /db/app/product/dbhome
Patch applicability verified successfully on home /db/app/product/dbhome


Verifying SQL patch applicability on home /db/app/product/dbhome
No step execution required.........
 

Preparing to bring down database service on home /db/app/product/dbhome
No step execution required.........
 

Performing prepatch operation on home /db/app/product/dbhome
Perpatch operation completed successfully on home /db/app/product/dbhome


Start applying binary patch on home /db/app/product/dbhome
Failed while applying binary patches on home /db/app/product/dbhome

Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : db19c2->/db/app/product/dbhome Type[rac]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /db/app/product/dbhome, host: db19c2.
Command failed:  /db/app/product/dbhome/OPatch/opatchauto  apply /PATCH/30501910 -oh /db/app/product/dbhome -target_type rac_database -binary -invPtrLoc /db/app/product/dbhome/oraInst.loc -jre /db/app/product/dbhome/OPatch/jre -persistresult /db/app/product/dbhome/opatchautocfg/db/sessioninfo/sessionresult_db19c2_rac.ser -analyzedresult /db/app/product/dbhome/opatchautocfg/db/sessioninfo/sessionresult_analyze_db19c2_rac.ser
Command failure output: 
==Following patches FAILED in apply:

Patch: /PATCH/30501910/30489227
Log: /db/app/product/dbhome/cfgtoollogs/opatchauto/core/opatch/opatch2020-04-17_01-21-14AM_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: ApplySession failed in system modification phase... 'ApplySession::apply failed: java.io.IOException: oracle.sysman.oui.patch.PatchException: java.io.FileNotFoundException: /dg/app/oraInventory/ContentsXML/oui-patch.xml (Permission denied)' 
--> 중점적으로 봐야 하는 곳 입니다. 그 후 디렉토리 복사 퍼미션 변경 필요
After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.

OPatchauto session completed at Fri Apr 17 01:22:36 2020
Time taken to complete the session 6 minutes, 11 seconds

 opatchauto failed with error code 42
[root@db19c2(DBRAC2):/PATCH]



==> 1조치 방법 oneoffs 디렉토리 안의 30489227, 30557433 복사를 한다  (1번 노드에서 성공한 것을 가지고 복사 수행)

[oracle@db19c1(DBRAC1):/db/app/product/dbhome/inventory/oneoffs]ls -lart
total 0
drwxr-x---.  4 oracle oinstall  29 Apr 18  2019 29517242
drwxr-x---.  4 oracle oinstall  29 Apr 18  2019 29585399
drwxr-x---. 14 oracle oinstall 233 Apr 16 20:52 ..
drwxr-xr-x.  4 oracle oinstall  29 Apr 16 23:59 30489227
drwxr-xr-x.  4 oracle oinstall  29 Apr 17 00:07 30557433
drwxr-x---.  6 oracle oinstall  70 Apr 17 00:07 .
[oracle@db19c1(DBRAC1):/db/app/product/dbhome/inventory/oneoffs]scp -r 30489227 oracle@db19c2:/db/app/product/dbhome/inventory/oneoffs/
inventory.xml                                                                                                                                                      100%   45KB   1.6MB/s   00:00    
actions.xml                                                                                                                                                        100%   95KB  13.4MB/s   00:00    
[oracle@db19c1(DBRAC1):/db/app/product/dbhome/inventory/oneoffs]scp -r 30557433 oracle@db19c2:/db/app/product/dbhome/inventory/oneoffs/
inventory.xml                                                                                                                                                      100%  163KB   4.4MB/s   00:00    
actions.xml                                                                                                                                                        100% 1806KB  10.1MB/s   00:00    
[oracle@db19c1(DBRAC1):/db/app/product/dbhome/inventory/oneoffs]

[root@db19c2(DBRAC2):/db/app/product/dbhome/inventory/oneoffs]ls -lart
total 0
drwxr-x---.  4 oracle dba       29 Apr 16 20:54 29585399
drwxr-x---.  4 oracle dba       29 Apr 16 20:55 29517242
drwxr-x---. 14 oracle dba      233 Apr 16 20:55 ..
drwxr-xr-x.  4 oracle oinstall  29 Apr 18 19:42 30489227
drwxr-x---.  6 oracle dba       70 Apr 18 20:12 .
drwxr-xr-x.  4 oracle oinstall  29 Apr 18 20:12 30557433
[root@db19c2(DBRAC2):/db/app/product/dbhome/inventory/oneoffs]


==> 2차 시도 퍼미션 
root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]chown -R grid:oinstall *
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]ls -lart
total 20
-rw-rw----. 1 grid oinstall 546 Apr 16 21:00 inventory.xml
-rw-r--r--. 1 grid oinstall 174 Apr 17 00:32 oui-patch.xml
-rw-rw----. 1 grid oinstall 292 Apr 17 00:32 libs.xml
-rw-rw----. 1 grid oinstall 300 Apr 17 00:32 comps.xml
drwxrwx---. 2 grid oinstall 107 Apr 17 01:22 .
drwxrwx---. 6 grid oinstall 105 Apr 18 19:54 ..
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]chmod 660 oui-patch.xml
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]ls -lart
total 20
-rw-rw----. 1 grid oinstall 546 Apr 16 21:00 inventory.xml
-rw-rw----. 1 grid oinstall 174 Apr 17 00:32 oui-patch.xml
-rw-rw----. 1 grid oinstall 292 Apr 17 00:32 libs.xml
-rw-rw----. 1 grid oinstall 300 Apr 17 00:32 comps.xml
drwxrwx---. 2 grid oinstall 107 Apr 17 01:22 .
drwxrwx---. 6 grid oinstall 105 Apr 18 19:54 ..
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]ls -lart
total 20
-rw-rw----. 1 grid oinstall 546 Apr 16 21:00 inventory.xml
-rw-rw----. 1 grid oinstall 174 Apr 17 00:32 oui-patch.xml
-rw-rw----. 1 grid oinstall 292 Apr 17 00:32 libs.xml
-rw-rw----. 1 grid oinstall 300 Apr 17 00:32 comps.xml
drwxrwx---. 2 grid oinstall 107 Apr 17 01:22 .
drwxrwx---. 6 grid oinstall 105 Apr 18 19:54 ..
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]opatchauto apply /PATCH/30501910 -oh /db/app/product/dbhome

OPatchauto session is initiated at Sat Apr 18 20:06:23 2020

System initialization log file is /db/app/product/dbhome/cfgtoollogs/opatchautodb/systemconfig2020-04-18_08-06-53PM.log.



Session log file is /db/app/product/dbhome/cfgtoollogs/opatchauto/opatchauto2020-04-18_08-09-00PM.log
The id for this session is A82G

Executing OPatch prereq operations to verify patch applicability on home /db/app/product/dbhome
Patch applicability verification failed on home /db/app/product/dbhome

Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : db19c2->/db/app/product/dbhome Type[rac]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /db/app/product/dbhome, host: db19c2.
Command failed:  /db/app/product/dbhome/OPatch/opatchauto  apply /PATCH/30501910 -oh /db/app/product/dbhome -target_type rac_database -binary -invPtrLoc /db/app/product/dbhome/oraInst.loc -jre /db/app/product/dbhome/OPatch/jre -persistresult /db/app/product/dbhome/opatchautocfg/db/sessioninfo/sessionresult_analyze_db19c2_rac.ser -analyze -online -prepare_home
Command failure output: 
==Following patches FAILED in analysis for apply:

Patch: /PATCH/30501910/30489227
Log: 
Reason: Failed during listing in Analysis: java.lang.Exception: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
   ORACLE_HOME/inventory/oneoffs/30557433 is corrupted. PatchObject constructor: Input file "/db/app/product/dbhome/inventory/oneoffs/30557433/etc/config/actions" or "/db/app/product/dbhome/inventory/oneoffs/30557433/etc/config/inventory" does not exist.


Patch: /PATCH/30501910/30557433
Log: 
Reason: Failed during listing in Analysis: java.lang.Exception: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
   ORACLE_HOME/inventory/oneoffs/30557433 is corrupted. PatchObject constructor: Input file "/db/app/product/dbhome/inventory/oneoffs/30557433/etc/config/actions" or "/db/app/product/dbhome/inventory/oneoffs/30557433/etc/config/inventory" does not exist. 

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.

OPatchauto session completed at Sat Apr 18 20:09:57 2020
Time taken to complete the session 3 minutes, 41 seconds

 opatchauto failed with error code 42
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]

[oracle@db19c1(DBRAC1):/dg/app/oraInventory/ContentsXML]ls -lart 
total 16
-rw-rw----. 1 grid oinstall 546 Apr 16 20:52 inventory.xml
-rw-rw----. 1 grid oinstall 174 Apr 17 00:07 oui-patch.xml
drwxrwx---. 2 grid oinstall  81 Apr 17 00:07 .
-rw-rw----. 1 grid oinstall 300 Apr 17 00:07 comps.xml
-rw-rw----. 1 grid oinstall 292 Apr 17 00:07 libs.xml
drwxrwx---. 5 grid oinstall  92 Apr 18 19:45 ..
[oracle@db19c1(DBRAC1):/dg/app/oraInventory/ContentsXML]


[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]ls -lart
total 20
-rw-rw----. 1 grid oinstall 546 Apr 16 21:00 inventory.xml
-rw-r--r--. 1 grid oinstall 174 Apr 17 00:32 oui-patch.xml
-rw-rw----. 1 grid oinstall 292 Apr 17 00:32 libs.xml
-rw-rw----. 1 grid oinstall 300 Apr 17 00:32 comps.xml
drwxrwx---. 2 grid oinstall 107 Apr 17 01:22 .
drwxrwx---. 6 grid oinstall 105 Apr 18 19:54 ..
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]chmod 660 oui-patch.xml
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]ls -lart
total 20
-rw-rw----. 1 grid oinstall 546 Apr 16 21:00 inventory.xml
-rw-rw----. 1 grid oinstall 174 Apr 17 00:32 oui-patch.xml
-rw-rw----. 1 grid oinstall 292 Apr 17 00:32 libs.xml
-rw-rw----. 1 grid oinstall 300 Apr 17 00:32 comps.xml
drwxrwx---. 2 grid oinstall 107 Apr 17 01:22 .
drwxrwx---. 6 grid oinstall 105 Apr 18 19:54 ..
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]chmod 660  oui-patch.xml.back
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]ls -lart
total 20
-rw-rw----. 1 grid oinstall 546 Apr 16 21:00 inventory.xml
-rw-rw----. 1 grid oinstall 174 Apr 17 00:32 oui-patch.xml
-rw-rw----. 1 grid oinstall 292 Apr 17 00:32 libs.xml
-rw-rw----. 1 grid oinstall 300 Apr 17 00:32 comps.xml
drwxrwx---. 2 grid oinstall 107 Apr 17 01:22 .
drwxrwx---. 6 grid oinstall 105 Apr 18 19:54 ..
[root@db19c2(DBRAC2):/dg/app/oraInventory/ContentsXML]



[oracle@db19c1(DBRAC1):/db/app/product/dbhome/inventory/oneoffs]scp -r 30557433 oracle@db19c2:/db/app/product/dbhome/inventory/oneoffs/
inventory.xml                                                                                                                                               100%  163KB  24.6MB/s   00:00    
actions.xml                                                                                                                                                 100% 1806KB   7.2MB/s   00:00    
[oracle@db19c1(DBRAC1):/db/app/product/dbhome/inventory/oneoffs]
[root@db19c2(DBRAC2):/db/app/product/dbhome/inventory/oneoffs]ls -lart
total 0
drwxr-x---.  4 oracle dba       29 Apr 16 20:54 29585399
drwxr-x---.  4 oracle dba       29 Apr 16 20:55 29517242
drwxr-x---. 14 oracle dba      233 Apr 16 20:55 ..
drwxr-xr-x.  4 oracle oinstall  29 Apr 18 19:42 30489227
drwxr-x---.  6 oracle dba       70 Apr 18 20:12 .
drwxr-xr-x.  4 oracle oinstall  29 Apr 18 20:12 30557433
[root@db19c2(DBRAC2):/db/app/product/dbhome/inventory/oneoffs]
[root@db19c2(DBRAC2):/db/app/product/dbhome/inventory/oneoffs]
[root@db19c2(DBRAC2):/db/app/product/dbhome/inventory/oneoffs]


[root@db19c2(DBRAC2):/db/app/product/dbhome/inventory/oneoffs]opatchauto apply /PATCH/30501910 -oh /db/app/product/dbhome

OPatchauto session is initiated at Sat Apr 18 20:13:14 2020

System initialization log file is /db/app/product/dbhome/cfgtoollogs/opatchautodb/systemconfig2020-04-18_08-13-27PM.log.

Session log file is /db/app/product/dbhome/cfgtoollogs/opatchauto/opatchauto2020-04-18_08-15-47PM.log
The id for this session is D9SI

Executing OPatch prereq operations to verify patch applicability on home /db/app/product/dbhome
Patch applicability verified successfully on home /db/app/product/dbhome


Verifying SQL patch applicability on home /db/app/product/dbhome
No step execution required.........
 

Preparing to bring down database service on home /db/app/product/dbhome
No step execution required.........
 

Preparing home /db/app/product/dbhome after database service restarted
No step execution required.........
 
OPatchAuto successful.

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

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

Host:db19c2
RAC Home:/db/app/product/dbhome
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /PATCH/30501910/30489632
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /PATCH/30501910/30655595
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /PATCH/30501910/30489227
Reason: This patch is already been applied, so not going to apply again.

Patch: /PATCH/30501910/30557433
Reason: This patch is already been applied, so not going to apply again.



OPatchauto session completed at Sat Apr 18 20:17:31 2020
Time taken to complete the session 4 minutes, 18 seconds
[root@db19c2(DBRAC2):/db/app/product/dbhome/inventory/oneoffs]


[oracle@db19c2(DBRAC2):/db]opatch lsinventory | grep Patch
Oracle Interim Patch Installer version 12.2.0.1.19
OPatch version    : 12.2.0.1.19
Patch  30557433     : applied on Sat Apr 18 19:55:01 KST 2020
Unique Patch ID:  23305305
Patch description:  "Database Release Update : 19.6.0.0.200114 (30557433)"
Patch  30489227     : applied on Fri Apr 17 22:34:20 KST 2020
Unique Patch ID:  23305624
Patch description:  "OCW RELEASE UPDATE 19.6.0.0.0 (30489227)"
OPatch succeeded.
[oracle@db19c2(DBRAC2):/db]

--> 정상이라고 판단이 되면 종료. 
 

 

번호 제목 글쓴이 날짜 조회 수
40 Oracle Database 19c Patch Update(단일 인스턴스 오라클 DB 19.3 에서 19.9로 RU Update) 명품관 2020.11.24 34927
39 New version of our Hands-On Lab available for download "Upgrade/Migrate/Consolidate to Oracle 12c" HOL 명품관 2015.12.22 8992
38 How to Enable/Disable Oracle Binary Option [1] Talros 2016.03.09 8620
37 19c RAC OJVM 패치작업 우뽕 2020.04.22 5209
36 Oracle RAC RU rolling patching from 19.3 to 19.9.0.0.201020(Patch 31750108) [1] file 명품관 2020.12.08 5155
35 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 2 (Grid Infrastructure) file 명품관 2020.11.19 4939
34 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 1 (OS 및 스토리지 설정) 명품관 2020.11.14 4745
33 ASM 에 spfile 등록 및 삭제 하기 우뽕 2020.07.27 4433
32 오라클 21c RAC 설치 with Oracle Linux 8.2 - 1 (OS 및 스토리지 설정) 명품관 2021.12.01 2990
31 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 5 (DBCA로 Database 생성) file 명품관 2020.11.19 2806
30 19c RAC 2Node 설치 -1 [ 환경 ,OS 세팅 ] file 우뽕 2020.04.14 2647
29 19c RAC - Manual Patch 적용방법 우뽕 2020.05.05 2334
28 Oracle EM(Enterprise Manager) 13.4 설치 및 구성 - 2(EM 설치) file 명품관 2020.11.27 2241
27 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 3 (사용할 Disk Group 생성) file 명품관 2020.11.19 1479
26 DBCA/DBUA 사용시 마지막 단계 Finish 버튼 클릭 후 행 현상 발생 시 체크 사항 명품관 2015.12.17 1460
» 19c RAC 2Node 설치-8 [ Patch ] 우뽕 2020.04.22 1397
24 19c RAC 2Node 삭제 하기 file 우뽕 2020.04.22 1336
23 메뉴얼하게 DB 추가 작업 - GRID 리소스에 DB 추가 작업 우뽕 2020.07.27 1254
22 Oracle EM(Enterprise Manager) 13.4 설치 및 구성 - 1(Repository DB 설치) file 명품관 2020.11.23 1146
21 Automatic Storage Management (ASM) 사용시 고려해야 할 사항 [2] 우뽕 2020.02.06 1041
위로