버전 비교

이전 버전 1

changes.mady.by.user 윤병훈

에 저장

비교대상

새 버전 2

changes.mady.by.user 윤병훈

에 저장

키

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.
코드 블럭
languagebash
titleroot 유저로 수행
linenumberstrue
export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/12.1.0/grid
export DB_HOME=$ORACLE_BASE/product/12.1.0/db_1
# mkdir -p /u01/app/oracle/cfgtoollogs/sqlpatch/26925263/21857460
# chown -R grid:oinstall /u01/app/oracle/cfgtoollogs/sqlpatch
# chmod -R 775 /u01/app/oracle/cfgtoollogs
코드 블럭
languagebash
linenumberstrue

$GRID_HOME/bin/crsctl stat res -t
펼치기
서식 미적용
[root@rac1 ~]# export ORACLE_BASE=/u01/app/oracle
[root@rac1 ~]# export GRID_HOME=/u01/app/12.1.0/grid
[root@rac1 ~]# export DB_HOME=$ORACLE_BASE/product/12.1.0/db_1
[root@rac1 ~]# $GRID_HOME/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.DATA.dg
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.FRA.dg
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.asm
               ONLINE  ONLINE       rac1                     Started,STABLE
               ONLINE  ONLINE       rac2                     Started,STABLE
ora.net1.network
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
ora.ons
               ONLINE  ONLINE       rac1                     STABLE
               ONLINE  ONLINE       rac2                     STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac1                     STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       rac1                     169.254.147.231 10.0
                                                             .5.111,STABLE
ora.cvu
      1        ONLINE  ONLINE       rac1                     STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       rac1                     Open,STABLE
ora.oc4j
      1        ONLINE  ONLINE       rac1                     STABLE
ora.rac1       .vip
      1        ONLINE  ONLINE       rac1                     STABLE
ora.rac2       .vip
      1        ONLINE  ONLINE       rac2                     STABLE
ora.racdb.db
      1        ONLINE  ONLINE       rac1                     Open,STABLE
      2        ONLINE  ONLINE       rac2                     Open,STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac1                     STABLE
--------------------------------------------------------------------------------
코드 블럭
languagebash
titleroot 유저로 수행
linenumberstrue
cd $GRID_HOME
OPatch/opatch version
mv OPatch OPatch.old
cp -r /media/sf_oracle/OPatch .
chown -R grid:oinstall OPatch
ll | grep OPatch
OPatch/opatch version
펼치기
서식 미적용
[root@rac1 ~]# cd $GRID_HOME
[root@rac1 grid]# OPatch/opatch version
OPatch Version: 12.1.0.1.3

OPatch succeeded.
[root@rac1 grid]# mv OPatch OPatch.old
[root@rac1 grid]# cp -r /media/sf_oracle/OPatch .
[root@rac1 grid]# chown -R grid:oinstall OPatch
[root@rac1 grid]# ll | grep OPatch
drwxr-x---. 14 grid oinstall  4096 2018-02-01 12:07 OPatch
drwxr-xr-x.  7 grid oinstall  4096 2018-01-31 13:33 OPatch.old
[root@rac1 grid]# OPatch/opatch version
OPatch Version: 12.2.0.1.12

OPatch succeeded.
서식 미적용
[root@rac2 ~]# cd $GRID_HOME
[root@rac2 grid]# OPatch/opatch version
OPatch Version: 12.1.0.1.3

OPatch succeeded.
[root@rac2 grid]# mv OPatch OPatch.old
[root@rac2 grid]# cp -r /media/sf_oracle/OPatch .
[root@rac2 grid]# chown -R grid:oinstall OPatch
[root@rac2 grid]# ll | grep OPatch
drwxr-x---. 14 grid oinstall  4096 2018-02-01 12:24 OPatch
drwxr-xr-x.  7 grid oinstall  4096 2018-01-31 13:35 OPatch.old
[root@rac2 grid]# OPatch/opatch version
OPatch Version: 12.2.0.1.12

OPatch succeeded.
코드 블럭
languagebash
titleroot 유저로 수행
linenumberstrue
cd $DB_HOME
OPatch/opatch version
mv OPatch OPatch.old
cp -r /media/sf_oracle/OPatch .
chown -R oracle:oinstall OPatch
ll | grep OPatch
OPatch/opatch version
펼치기
서식 미적용
[root@rac1 grid]# OPatch/opatch version
OPatch Version: 12.2.0.1.12

OPatch succeeded.
[root@rac1 grid]# cd
[root@rac1 ~]# cd $DB_HOME
[root@rac1 db_1]# OPatch/opatch version
OPatch Version: 12.1.0.1.3

OPatch succeeded.
[root@rac1 db_1]# mv OPatch OPatch.old
[root@rac1 db_1]# cp -r /media/sf_oracle/OPatch .
[root@rac1 db_1]# chown -R oracle:oinstall OPatch
[root@rac1 db_1]# ll | grep OPatch
drwxr-x---. 14 oracle oinstall  4096 2018-02-01 12:07 OPatch
drwxr-xr-x.  7 oracle oinstall  4096 2018-01-31 14:09 OPatch.old
[root@rac1 db_1]# OPatch/opatch version
OPatch Version: 12.2.0.1.12

OPatch succeeded.
서식 미적용
[root@rac2 ~]# cd $DB_HOME
[root@rac2 db_1]# OPatch/opatch version
OPatch Version: 12.1.0.1.3

OPatch succeeded.
[root@rac2 db_1]# mv OPatch OPatch.old
[root@rac2 db_1]# cp -r /media/sf_oracle/OPatch .
[root@rac2 db_1]# chown -R oracle:oinstall OPatch
[root@rac2 db_1]# ll | grep OPatch
drwxr-x---. 14 oracle oinstall  4096 2018-02-01 12:25 OPatch
drwxr-xr-x.  7 oracle oinstall  4096 2018-01-31 14:12 OPatch.old
[root@rac2 db_1]# OPatch/opatch version
OPatch Version: 12.2.0.1.12

OPatch succeeded.
코드 블럭
languagebash
titlegrid 유저로 수행
linenumberstrue
$GRID_HOME/OPatch/opatch lsinventory
펼치기
서식 미적용
[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch lsinventory

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-01_15-23-16오후_1.log

Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-02-01_15-23-16오후.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1
ARU platform id: 226
ARU platform description:: Linux x86-64

설치된 최상위 레벨 제품(1):

Oracle Grid Infrastructure 12c                                       12.1.0.2.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


이 Oracle 홈에 설치된 Interim 패치가 없습니다.


--------------------------------------------------------------------------------

OPatch succeeded. 
서식 미적용
[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch lsinventory

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-01_15-23-47오후_1.log

Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-02-01_15-23-47오후.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2
ARU platform id: 226
ARU platform description:: Linux x86-64

설치된 최상위 레벨 제품(1):

Oracle Grid Infrastructure 12c                                       12.1.0.2.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


이 Oracle 홈에 설치된 Interim 패치가 없습니다.


--------------------------------------------------------------------------------

OPatch succeeded.
코드 블럭
languagebash
titlegrid 유저로 수행
linenumberstrue
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925263
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925218
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26910974
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26983807
vi /tmp/patch_list_gihome.txt
# cat /tmp/patch_list_gihome.txt
$GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
펼치기
서식 미적용
[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925263
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26910974
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26983807
Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-01_15-26-08오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.


[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925218

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-01_15-26-17오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.


[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26910974

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-01_15-26-20오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.


[grid@+ASM1 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26983807

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-01_15-26-26오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
서식 미적용
[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925263

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-01_15-26-10오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.


[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925218

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-01_15-26-20오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.


[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26910974

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-01_15-26-23오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.


[grid@+ASM2 ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26983807

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2018-02-01_15-27-30오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
코드 블럭
languagebash
titleoracle 유저로 수행
linenumberstrue
$DB_HOME/OPatch/opatch lsinventory
펼치기
서식 미적용
[oracle@racdb1 ~]$ $DB_HOME/OPatch/opatch lsinventory

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-01_15-24-38오후_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-02-01_15-24-38오후.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1
ARU platform id: 226
ARU platform description:: Linux x86-64

설치된 최상위 레벨 제품(1):

Oracle Database 12c                                                  12.1.0.2.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


이 Oracle 홈에 설치된 Interim 패치가 없습니다.


--------------------------------------------------------------------------------

OPatch succeeded.
서식 미적용
[oracle@racdb2 ~]$ $DB_HOME/OPatch/opatch lsinventory

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-01_15-24-41오후_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-02-01_15-24-41오후.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2
ARU platform id: 226
ARU platform description:: Linux x86-64

설치된 최상위 레벨 제품(1):

Oracle Database 12c                                                  12.1.0.2.0
이 Oracle 홈에 1개의 제품이 설치되어 있습니다.


이 Oracle 홈에 설치된 Interim 패치가 없습니다.


--------------------------------------------------------------------------------

OPatch succeeded.
코드 블럭
languagebash
titleoracle 유저로 수행
linenumberstrue
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925263
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925218
vi /tmp/patch_list_dbhome.txt
# cat /tmp/patch_list_dbhome.txt
$DB_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt
펼치기
서식 미적용
[oracle@racdb1 ~]$ $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925263

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-01_15-28-20오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.


[oracle@racdb1 ~]$ $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925218

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-01_15-28-34오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
서식 미적용
[oracle@racdb2 ~]$ $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925263

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-01_15-28-28오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
 

[oracle@racdb2 ~]$ $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925218

Oracle Interim 패치 설치 프로그램 버전 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2018-02-01_15-29-00오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
코드 블럭
linenumberstrue
SELECT name, open_mode FROM v$pdbs; ALTER PLUGGABLE DATABASE ALL OPEN; SELECT name, open_mode FROM v$pdbs;
 코드 블럭
languagebash
titleroot 유저로 수행
linenumberstrue
opatchauto apply /media/sf_oracle/27010930
 펼치기
 서식 미적용
 
 코드 블럭
languagebash
titlegrid 유저로 수행
linenumberstrue
export ORACLE_SID=-MGMTDB
sqlplus / as sysdba
 펼치기
 서식 미적용
 
 코드 블럭
titleMGMTDB 상태 조회
linenumberstrue
SELECT instance_name FROM v$instance;
SELECT name, open_mode FROM v$pdbs;
 펼치기
 서식 미적용
 
 코드 블럭
languagebash
titlegrid 유저로 한 번만 수행
linenumberstrue
cd $ORACLE_HOME/OPatch
datapatch -verbose
 펼치기
 서식 미적용
 
 코드 블럭
titleMGMTDB 패치 결과 조회
linenumberstrue
SELECT patch_id, version, action, status, action_time FROM dba_registry_sqlpatch;
 펼치기
 서식 미적용
 
 코드 블럭
titlePDB를 모두 OPEN
linenumberstrue
SELECT name, open_mode FROM v$pdbs;
ALTER PLUGGABLE DATABASE ALL OPEN;
SELECT name, open_mode FROM v$pdbs;
 펼치기
 서식 미적용
 
 코드 블럭
languagebash
titleoracle 유저로 한번만 수행
linenumberstrue
cd $ORACLE_HOME/OPatch
datapatch -verbose
 펼치기
 서식 미적용
 
 코드 블럭
titleDB 패치 결과 조회
linenumberstrue
SELECT patch_id, version, action, status, action_time FROM dba_registry_sqlpatch;
 펼치기
 서식 미적용