페이지 이력

버전 비교

이전 버전 1

changes.mady.by.user 윤병훈

에 저장 2월 08, 2018

비교대상

새 버전 현재

changes.mady.by.user 윤병훈

에 저장 2월 09, 2018

키

이 줄이 추가되었습니다.
이 줄이 삭제되었습니다.
서식이 변경되었습니다.

패치 환경 설정

코드 블럭

language	bash
title	root 유저로 수행
linenumbers	true

export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=$ORACLE_BASE/12.2.0/grid
export DB_HOME=$ORACLE_BASE/product/12.2.0/db_1
export PATH=$PATH:$GRID_HOME/OPatch

펼치기

서식 미적용

[root@ol7 ~]# export ORACLE_BASE=/u01/app/oracle
[root@ol7 ~]# export GRID_HOME=$ORACLE_BASE/12.2.0/grid
[root@ol7 ~]# export DB_HOME=$ORACLE_BASE/product/12.2.0/db_1
[root@ol7 ~]# export PATH=$PATH:$GRID_HOME/OPatch

OPatch 업데이트

코드 블럭

language	bash
title	root 유저로 수행
linenumbers	true

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@ol7 ~]# cd $GRID_HOME
[root@ol7 grid]# OPatch/opatch version
OPatch Version: 12.2.0.1.6

OPatch succeeded.
[root@ol7 grid]# mv OPatch OPatch.old
[root@ol7 grid]# cp -r /media/sf_oracle/OPatch .
[root@ol7 grid]# chown -R grid:oinstall OPatch
[root@ol7 grid]# ll | grep OPatch
drwxr-x---. 14 grid oinstall  4096  2월  8 15:05 OPatch
drwxr-xr-x. 12 grid oinstall  4096  1월 27  2017 OPatch.old
[root@ol7 grid]# OPatch/opatch version
OPatch Version: 12.2.0.1.12

OPatch succeeded.

코드 블럭

language	bash
title	root 유저로 수행
linenumbers	true

cd $DB_HOME
mv OPatch OPatch.old
cp -r /media/sf_oracle/<패치 파일 압축 해제 경로>/OPatch .
chown -R oracle:oinstall OPatch
OPatch/opatch version

펼치기

서식 미적용

[root@ol7 ~]# cd $DB_HOME
[root@ol7 db_1]# mv OPatch OPatch.old
[root@ol7 db_1]# cp -r /media/sf_oracle/OPatch .
[root@ol7 db_1]# chown -R oracle:oinstall OPatch
[root@ol7 db_1]# OPatch/opatch version
OPatch Version: 12.2.0.1.12

OPatch succeeded.

패치 현황 조사

코드 블럭

language	bash
title	grid 유저로 수행

$GRID_HOME/OPatch/opatch lsinventory -detail -oh $GRID_HOME

펼치기

서식 미적용

[grid@+ASM ~]$ $GRID_HOME/OPatch/opatch lsinventory -detail -oh $GRID_HOME

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


Oracle Home       : /u01/app/oracle/12.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/12.2.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatch/opatch2018-02-08_15-06-38오후_1.log

Lsinventory Output file location : /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-02-08_15-06-38오후.txt

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

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

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


설치된 제품(99):

Assistant Common Files                                               12.2.0.1.0
Automatic Storage Management Assistant                               12.2.0.1.0
BLASLAPACK Component                                                 12.2.0.1.0
Buildtools Common Files                                              12.2.0.1.0
Cluster Ready Services Files                                         12.2.0.1.0
Cluster Verification Utility Common Files                            12.2.0.1.0
Cluster Verification Utility Files                                   12.2.0.1.0
Database Configuration and Upgrade Assistants                        12.2.0.1.0
Database Migration Assistant for Unicode                             12.2.0.1.0
Database SQL Scripts                                                 12.2.0.1.0
Database Workspace Manager                                           12.2.0.1.0
DB TOOLS Listener                                                    12.2.0.1.0
Deinstallation Tool                                                  12.2.0.1.0
Expat libraries                                                       2.0.1.0.3
Hadoopcore Component                                                 12.2.0.1.0
HAS Common Files                                                     12.2.0.1.0
HAS Files for DB                                                     12.2.0.1.0
Installation Common Files                                            12.2.0.1.0
Installation Plugin Files                                            12.2.0.1.0
Installer SDK Component                                              12.2.0.1.4
Java Development Kit                                                 1.8.0.91.0
LDAP Required Support Files                                          12.2.0.1.0
OLAP SQL Scripts                                                     12.2.0.1.0
Oracle Advanced Security                                             12.2.0.1.0
Oracle Bali Share                                                    11.1.1.6.0
Oracle Clusterware RDBMS Files                                       12.2.0.1.0
Oracle Configuration Manager Deconfiguration                         10.3.1.0.0
Oracle Core Required Support Files                                   12.2.0.1.0
Oracle Core Required Support Files for Core DB                       12.2.0.1.0
Oracle Database 12c                                                  12.2.0.1.0
Oracle Database 12c Multimedia Files                                 12.2.0.1.0
Oracle Database Deconfiguration                                      12.2.0.1.0
Oracle Database Utilities                                            12.2.0.1.0
Oracle DBCA Deconfiguration                                          12.2.0.1.0
Oracle Extended Windowing Toolkit                                    11.1.1.6.0
Oracle Globalization Support                                         12.2.0.1.0
Oracle Globalization Support                                         12.2.0.1.0
Oracle Globalization Support For Core                                12.2.0.1.0
Oracle Grid Infrastructure 12c                                       12.2.0.1.0
Oracle Grid Infrastructure Bundled Agents                            12.2.0.1.0
Oracle Grid Management Database                                      12.2.0.1.0
Oracle Help for Java                                                 11.1.1.7.0
Oracle Help Share Library                                            11.1.1.7.0
Oracle Ice Browser                                                   11.1.1.7.0
Oracle Internet Directory Client                                     12.2.0.1.0
Oracle Java Client                                                   12.2.0.1.0
Oracle JDBC/OCI Instant Client                                       12.2.0.1.0
Oracle JDBC/THIN Interfaces                                          12.2.0.1.0
Oracle JFC Extended Windowing Toolkit                                11.1.1.6.0
Oracle JVM                                                           12.2.0.1.0
Oracle JVM For Core                                                  12.2.0.1.0
Oracle LDAP administration                                           12.2.0.1.0
Oracle Locale Builder                                                12.2.0.1.0
Oracle Multimedia                                                    12.2.0.1.0
Oracle Multimedia Client Option                                      12.2.0.1.0
Oracle Multimedia Java Advanced Imaging                              12.2.0.1.0
Oracle Multimedia Locator                                            12.2.0.1.0
Oracle Multimedia Locator Java Required Support Files                12.2.0.1.0
Oracle Multimedia Locator RDBMS Files                                12.2.0.1.0
Oracle Net                                                           12.2.0.1.0
Oracle Net Listener                                                  12.2.0.1.0
Oracle Net Required Support Files                                    12.2.0.1.0
Oracle Netca Client                                                  12.2.0.1.0
Oracle Notification Service                                          12.2.0.1.0
Oracle Notification Service for Instant Client                       12.2.0.1.0
Oracle One-Off Patch Installer                                       12.2.0.1.6
Oracle Quality of Service Management (Server)                        12.2.0.1.0
Oracle RAC Deconfiguration                                           12.2.0.1.0
Oracle RAC Required Support Files-HAS                                12.2.0.1.0
Oracle Recovery Manager                                              12.2.0.1.0
Oracle Security Developer Tools                                      12.2.0.1.0
Oracle Text Required Support Files                                   12.2.0.1.0
Oracle Universal Connection Pool                                     12.2.0.1.0
Oracle Universal Installer                                           12.2.0.1.4
Oracle USM Deconfiguration                                           12.2.0.1.0
Oracle Wallet Manager                                                12.2.0.1.0
oracle.swd.commonlogging                                             13.3.0.0.0
oracle.swd.opatchautodb                                              12.2.0.1.5
oracle.swd.oui.core.min                                              12.2.0.1.4
Parser Generator Required Support Files                              12.2.0.1.0
Perl Interpreter                                                     5.22.0.0.0
Perl Modules                                                         5.22.0.0.0
PL/SQL                                                               12.2.0.1.0
PL/SQL Embedded Gateway                                              12.2.0.1.0
Platform Required Support Files                                      12.2.0.1.0
Precompiler Required Support Files                                   12.2.0.1.0
RDBMS Required Support Files                                         12.2.0.1.0
RDBMS Required Support Files for Instant Client                      12.2.0.1.0
Required Support Files                                               12.2.0.1.0
Secure Socket Layer                                                  12.2.0.1.0
SQL*Plus                                                             12.2.0.1.0
SQL*Plus Files for Instant Client                                    12.2.0.1.0
SQL*Plus Required Support Files                                      12.2.0.1.0
SSL Required Support Files for InstantClient                         12.2.0.1.0
Tomcat Container                                                     12.2.0.1.0
Tracle File Analyzer                                                 12.2.0.1.0
Universal Storage Manager Files                                      12.2.0.1.0
XDK Required Support Files                                           12.2.0.1.0
XML Parser for Java                                                  12.2.0.1.0
이 Oracle 홈에 99개의 제품이 설치되어 있습니다.


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


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

OPatch succeeded.

코드 블럭

language	bash
title	oracle 유저로 수행

$DB_HOME/OPatch/opatch lsinventory -detail -oh $DB_HOME

펼치기

서식 미적용

[oracle@orcl ~]$ $DB_HOME/OPatch/opatch lsinventory -detail -oh $DB_HOME

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


Oracle Home       : /u01/app/oracle/product/12.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.2.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatch/opatch2018-02-08_15-07-10오후_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-02-08_15-07-10오후.txt

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

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

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


설치된 제품(128):

Assistant Common Files                                               12.2.0.1.0
BLASLAPACK Component                                                 12.2.0.1.0
Buildtools Common Files                                              12.2.0.1.0
Cluster Verification Utility Common Files                            12.2.0.1.0
Database Configuration and Upgrade Assistants                        12.2.0.1.0
Database Migration Assistant for Unicode                             12.2.0.1.0
Database SQL Scripts                                                 12.2.0.1.0
Database Workspace Manager                                           12.2.0.1.0
DB TOOLS Listener                                                    12.2.0.1.0
Deinstallation Tool                                                  12.2.0.1.0
Enterprise Edition Options                                           12.2.0.1.0
Expat libraries                                                       2.0.1.0.3
Generic Connectivity Common Files                                    12.2.0.1.0
Hadoopcore Component                                                 12.2.0.1.0
HAS Common Files                                                     12.2.0.1.0
HAS Files for DB                                                     12.2.0.1.0
Installation Common Files                                            12.2.0.1.0
Installation Plugin Files                                            12.2.0.1.0
Installer SDK Component                                              12.2.0.1.4
JAccelerator (COMPANION)                                             12.2.0.1.0
Java Development Kit                                                 1.8.0.91.0
LDAP Required Support Files                                          12.2.0.1.0
OLAP SQL Scripts                                                     12.2.0.1.0
Oracle Advanced Analytics                                            12.2.0.1.0
Oracle Advanced Security                                             12.2.0.1.0
Oracle Application Express                                           12.2.0.1.0
Oracle Bali Share                                                    11.1.1.6.0
Oracle Call Interface (OCI)                                          12.2.0.1.0
Oracle Clusterware RDBMS Files                                       12.2.0.1.0
Oracle Configuration Manager                                         12.1.2.0.0
Oracle Configuration Manager Client                                  10.3.2.1.0
Oracle Configuration Manager Deconfiguration                         10.3.1.0.0
Oracle Context Companion                                             12.2.0.1.0
Oracle Core Required Support Files                                   12.2.0.1.0
Oracle Core Required Support Files for Core DB                       12.2.0.1.0
Oracle Database 12c                                                  12.2.0.1.0
Oracle Database 12c                                                  12.2.0.1.0
Oracle Database 12c Multimedia Files                                 12.2.0.1.0
Oracle Database Deconfiguration                                      12.2.0.1.0
Oracle Database Gateway for ODBC                                     12.2.0.1.0
Oracle Database Utilities                                            12.2.0.1.0
Oracle Database Vault option                                         12.2.0.1.0
Oracle DBCA Deconfiguration                                          12.2.0.1.0
Oracle Extended Windowing Toolkit                                    11.1.1.6.0
Oracle Globalization Support                                         12.2.0.1.0
Oracle Globalization Support                                         12.2.0.1.0
Oracle Globalization Support For Core                                12.2.0.1.0
Oracle Help for Java                                                 11.1.1.7.0
Oracle Help Share Library                                            11.1.1.7.0
Oracle Ice Browser                                                   11.1.1.7.0
Oracle Internet Directory Client                                     12.2.0.1.0
Oracle Java Client                                                   12.2.0.1.0
Oracle JDBC Server Support Package                                   12.2.0.1.0
Oracle JDBC/OCI Instant Client                                       12.2.0.1.0
Oracle JDBC/THIN Interfaces                                          12.2.0.1.0
Oracle JFC Extended Windowing Toolkit                                11.1.1.6.0
Oracle JVM                                                           12.2.0.1.0
Oracle JVM For Core                                                  12.2.0.1.0
Oracle Label Security                                                12.2.0.1.0
Oracle LDAP administration                                           12.2.0.1.0
Oracle Locale Builder                                                12.2.0.1.0
Oracle Message Gateway Common Files                                  12.2.0.1.0
Oracle Multimedia                                                    12.2.0.1.0
Oracle Multimedia Client Option                                      12.2.0.1.0
Oracle Multimedia Java Advanced Imaging                              12.2.0.1.0
Oracle Multimedia Locator                                            12.2.0.1.0
Oracle Multimedia Locator Java Required Support Files                12.2.0.1.0
Oracle Multimedia Locator RDBMS Files                                12.2.0.1.0
Oracle Net                                                           12.2.0.1.0
Oracle Net Listener                                                  12.2.0.1.0
Oracle Net Required Support Files                                    12.2.0.1.0
Oracle Net Services                                                  12.2.0.1.0
Oracle Netca Client                                                  12.2.0.1.0
Oracle Notification Service                                          12.2.0.1.0
Oracle Notification Service for Instant Client                       12.2.0.1.0
Oracle ODBC Driver                                                   12.2.0.1.0
Oracle ODBC Driverfor Instant Client                                 12.2.0.1.0
Oracle OLAP                                                          12.2.0.1.0
Oracle OLAP API                                                      12.2.0.1.0
Oracle OLAP RDBMS Files                                              12.2.0.1.0
Oracle One-Off Patch Installer                                       12.2.0.1.6
Oracle Partitioning                                                  12.2.0.1.0
Oracle Programmer                                                    12.2.0.1.0
Oracle R Enterprise Server Files                                     12.2.0.1.0
Oracle RAC Deconfiguration                                           12.2.0.1.0
Oracle RAC Required Support Files-HAS                                12.2.0.1.0
Oracle Real Application Testing                                      12.2.0.1.0
Oracle Recovery Manager                                              12.2.0.1.0
Oracle Scheduler Agent                                               12.2.0.1.0
Oracle Security Developer Tools                                      12.2.0.1.0
Oracle Spatial and Graph                                             12.2.0.1.0
Oracle SQL Developer                                                 12.2.0.1.0
Oracle Starter Database                                              12.2.0.1.0
Oracle Text                                                          12.2.0.1.0
Oracle Text ATG Language Support Files                               12.2.0.1.0
Oracle Text Required Support Files                                   12.2.0.1.0
Oracle Universal Connection Pool                                     12.2.0.1.0
Oracle Universal Installer                                           12.2.0.1.4
Oracle USM Deconfiguration                                           12.2.0.1.0
Oracle Wallet Manager                                                12.2.0.1.0
Oracle XML Development Kit                                           12.2.0.1.0
Oracle XML Query                                                     12.2.0.1.0
oracle.swd.commonlogging                                             13.3.0.0.0
oracle.swd.opatchautodb                                              12.2.0.1.5
oracle.swd.oui.core.min                                              12.2.0.1.4
Parser Generator Required Support Files                              12.2.0.1.0
Perl Interpreter                                                     5.22.0.0.0
Perl Modules                                                         5.22.0.0.0
PL/SQL                                                               12.2.0.1.0
PL/SQL Embedded Gateway                                              12.2.0.1.0
Platform Required Support Files                                      12.2.0.1.0
Precompiler Common Files                                             12.2.0.1.0
Precompiler Common Files for Core                                    12.2.0.1.0
Precompiler Required Support Files                                   12.2.0.1.0
Precompilers                                                         12.2.0.1.0
RDBMS Required Support Files                                         12.2.0.1.0
RDBMS Required Support Files for Instant Client                      12.2.0.1.0
Required Support Files                                               12.2.0.1.0
Secure Socket Layer                                                  12.2.0.1.0
SQL*Plus                                                             12.2.0.1.0
SQL*Plus Files for Instant Client                                    12.2.0.1.0
SQL*Plus Required Support Files                                      12.2.0.1.0
SQLJ Runtime                                                         12.2.0.1.0
SSL Required Support Files for InstantClient                         12.2.0.1.0
Tracle File Analyzer                                                 12.2.0.1.0
XDK Required Support Files                                           12.2.0.1.0
XML Parser for Java                                                  12.2.0.1.0
XML Parser for Oracle JVM                                            12.2.0.1.0
이 Oracle 홈에 128개의 제품이 설치되어 있습니다.


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


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

OPatch succeeded.

패치 충돌 여부 검증

코드 블럭

language	bash
title	grid 유저로 수행
linenumbers	true

$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 /media/sf_oracle/파일 압축 해제 경로>/27100009/27105253
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 파일 압축 해제 경로>/media/sf_oracle/27100009/27335416
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/<패치 파일 압축 해제 경로>/27100009/27128906
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle <패치 파일 압축 해제 경로>/27100009/26839277
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle <패치 파일 압축 해제 경로>/27100009/27144050

펼치기

서식 미적용

[grid@+ASM ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27100009/27105253

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

PREREQ session

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

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@+ASM ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27100009/27335416

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

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@+ASM ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27100009/27128906

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

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@+ASM ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27100009/26839277

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

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@+ASM ~]$ $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27100009/27144050

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

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

코드 블럭

language	bash
title	oracle 유저로 수행
linenumbers	true

$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 파일 압축 해제 경로>/27100009/27105253
$DBvi /tmp/patch_list_gihome.txt
# cat /tmp/patch_list_gihome.txt
$GRID_HOME/OPatch/opatch prereq CheckSystemSpaceCheckConflictAgainstOHWithDetail -phBaseFile /tmp/patch_list_gihome.txtphBaseDir <패치 파일 압축 해제 경로>/27100009/27335416

펼치기

서식 미적용

[grid@+ASMoracle@orcl ~]$ vi /tmp/patch_list_gihome.txt

[grid@+ASM ~]$ cat /tmp/patch_list_gihome.txt
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27100009/27144050
/media/sf_oracle/27100009/26839277
/media/sf_oracle/27100009/27128906
/media/sf_oracle/27100009/27335416
/media/sf_oracle/27100009/27105253

[grid@+ASM ~]$ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt

Oracle Interim 패치 27105253

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

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.2.0/griddb_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.2.0/griddb_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0/griddb_1/cfgtoollogs/opatch/opatch2018-02-08_15-1113-43오후41오후_1.log

Invoking prereq "checksystemspacecheckconflictagainstohwithdetail"

Prereq "checkSystemSpacecheckConflictAgainstOHWithDetail" passed.

OPatch succeeded.

코드 블럭
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27100009/27105253 $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27100009/27335416

코드 블럭

$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27100009/27105253
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27100009/27335416

펼치기

서식 미적용



[oracle@orcl ~]$ $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27100009/2710525327335416

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

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.2.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatch/opatch2018-02-08_15-13-41오후49오후_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

디스크 공간 확인

코드 블럭

language	bash
title	grid 유저로 수행
linenumbers	true

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@+ASM ~]$ vi /tmp/patch_list_gihome.txt

[oracle@orclgrid@+ASM ~]$ cat /tmp/patch_list_gihome.txt
/media/sf_oracle/27100009/27144050
/media/sf_oracle/27100009/26839277
/media/sf_oracle/27100009/27128906
/media/sf_oracle/27100009/27335416
/media/sf_oracle/27100009/27105253

[grid@+ASM ~]$ $DB$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetailCheckSystemSpace -phBaseDirphBaseFile /mediatmp/sf_oracle/27100009/27335416patch_list_gihome.txt

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

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.2.0/db_1grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.2.0/db_1grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0/db_1grid/cfgtoollogs/opatch/opatch2018-02-08_15-1311-49오후43오후_1.log

Invoking prereq "checkconflictagainstohwithdetailchecksystemspace"

Prereq "checkConflictAgainstOHWithDetailcheckSystemSpace" passed.

OPatch succeeded.

코드 블럭

language	bash
title	oracle 유저로 수행
linenumbers	true

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@orcl ~]$ vi /tmp/patch_list_dbhome.txt

[oracle@orcl ~]$ cat /tmp/patch_list_dbhome.txt
/media/sf_oracle/27100009/27335416
/media/sf_oracle/27100009/27105253

[oracle@orcl ~]$ $DB_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

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

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.2.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatch/opatch2018-02-08_15-14-35오후_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

패치 분석

코드 블럭

language	bash
title	root 유저로 수행

$GRID_HOME/OPatch/opatchauto apply /media/sf_oracle<패치 파일 압축 해제 경로>/27100009 -analyze

펼치기

서식 미적용

[root@ol7 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/27100009 -analyze

OPatchauto session is initiated at Thu Feb  8 15:15:51 2018

System initialization log file is /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-08_03-16-01PM.log.

세션 로그 파일은 /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2018-02-08_03-16-07PM.log입니다.
이 세션의 ID는 5C61입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1


Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/12.2.0/grid
Patch applicability verified successfully on home /u01/app/oracle/12.2.0/grid

OPatchAuto를 성공했습니다.

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

Analysis for applying patches has completed successfully:

Host:ol7
SIDB Home:/u01/app/oracle/product/12.2.0/db_1


==Following patches were SKIPPED:

Patch: /media/sf_oracle/27100009/27128906
Reason: This patch is not applicable to this specified target type - "oracle_database"

Patch: /media/sf_oracle/27100009/26839277
Reason: This patch is not applicable to this specified target type - "oracle_database"

Patch: /media/sf_oracle/27100009/27144050
Reason: This patch is not applicable to this specified target type - "oracle_database"


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /media/sf_oracle/27100009/27335416
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-16-20오후_1.log

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-16-20오후_1.log


Host:ol7
SIHA Home:/u01/app/oracle/12.2.0/grid


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /media/sf_oracle/27100009/27335416
Log: /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-16-50오후_1.log

Patch: /media/sf_oracle/27100009/27128906
Log: /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-16-50오후_1.log

Patch: /media/sf_oracle/27100009/26839277
Log: /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-16-50오후_1.log

Patch: /media/sf_oracle/27100009/27144050
Log: /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-16-50오후_1.log

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-16-50오후_1.log



OPatchauto session completed at Thu Feb  8 15:18:22 2018
Time taken to complete the session 2 minutes, 31 seconds

패치 적용

코드 블럭

language	bash
title	root 유저로 수행

$GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/ <패치 파일 압축 해제 경로>/27100009

펼치기

서식 미적용

[root@ol7 ~]# $GRID_HOME/OPatch/opatchauto apply /media/sf_oracle/27100009

OPatchauto session is initiated at Thu Feb  8 15:21:05 2018

System initialization log file is /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-02-08_03-21-15PM.log.

세션 로그 파일은 /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2018-02-08_03-21-21PM.log입니다.
이 세션의 ID는 YQKF입니다.

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_1


Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/12.2.0/grid
Patch applicability verified successfully on home /u01/app/oracle/12.2.0/grid


Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/db_1
Successfully prepared home /u01/app/oracle/product/12.2.0/db_1 to bring down database service


Bringing down database service on home /u01/app/oracle/product/12.2.0/db_1
Following database has been stopped and will be restarted later during the session: orcl
Database service successfully brought down on home /u01/app/oracle/product/12.2.0/db_1


Bringing down CRS service on home /u01/app/oracle/12.2.0/grid
Prepatch operation log file location: /u01/app/oracle/crsdata/ol7/crsconfig/hapatch_2018-02-08_03-23-53PM.log
CRS service brought down successfully on home /u01/app/oracle/12.2.0/grid


Start applying binary patch on home /u01/app/oracle/product/12.2.0/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1


Start applying binary patch on home /u01/app/oracle/12.2.0/grid
Binary patch applied successfully on home /u01/app/oracle/12.2.0/grid


Starting CRS service on home /u01/app/oracle/12.2.0/grid
Postpatch operation log file location: /u01/app/oracle/crsdata/ol7/crsconfig/hapatch_2018-02-08_03-31-26PM.log
CRS service started successfully on home /u01/app/oracle/12.2.0/grid


Starting database service on home /u01/app/oracle/product/12.2.0/db_1
Database service successfully started on home /u01/app/oracle/product/12.2.0/db_1


Preparing home /u01/app/oracle/product/12.2.0/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.2.0/db_1 successfully after database service restarted


Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/db_1
SQL patch applied successfully on home /u01/app/oracle/product/12.2.0/db_1

OPatchAuto를 성공했습니다.

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

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

Host:ol7
SIDB Home:/u01/app/oracle/product/12.2.0/db_1
Summary:

==Following patches were SKIPPED:

Patch: /media/sf_oracle/27100009/27128906
Reason: This patch is not applicable to this specified target type - "oracle_database"

Patch: /media/sf_oracle/27100009/26839277
Reason: This patch is not applicable to this specified target type - "oracle_database"

Patch: /media/sf_oracle/27100009/27144050
Reason: This patch is not applicable to this specified target type - "oracle_database"


==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-24-15오후_1.log

Patch: /media/sf_oracle/27100009/27335416
Log: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-24-15오후_1.log


Host:ol7
SIHA Home:/u01/app/oracle/12.2.0/grid
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /media/sf_oracle/27100009/26839277
Log: /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-25-47오후_1.log

Patch: /media/sf_oracle/27100009/27105253
Log: /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-25-47오후_1.log

Patch: /media/sf_oracle/27100009/27128906
Log: /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-25-47오후_1.log

Patch: /media/sf_oracle/27100009/27144050
Log: /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-25-47오후_1.log

Patch: /media/sf_oracle/27100009/27335416
Log: /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-02-08_15-25-47오후_1.log


Patching session reported following warning(s):
_________________________________________________

[WARNING] The database instance 'orcl' from '/u01/app/oracle/product/12.2.0/db_1', in host'ol7' is not running. SQL changes, if any,  will not be applied.
To apply. the SQL changes, bring up the database instance and run the command manually from any one node (run as oracle).
Refer to the readme to get the correct steps for applying the sql changes.




OPatchauto session completed at Thu Feb  8 15:33:41 2018
Time taken to complete the session 12 minutes, 37 seconds

패치 결과 확인

코드 블럭

language	bash
title	grid 유저로 수행

$GRID_HOME/OPatch/opatch lsinventory

펼치기

서식 미적용

[grid@+ASM ~]$ $GRID_HOME/OPatch/opatch lsinventory

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


Oracle Home       : /u01/app/oracle/12.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/12.2.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatch/opatch2018-02-08_15-34-52오후_1.log

Lsinventory Output file location : /u01/app/oracle/12.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-02-08_15-34-52오후.txt

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

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

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


Interim 패치(5):

Patch  27335416     : applied on Thu Feb 08 15:31:24 KST 2018
Unique Patch ID:  21843624
Patch description:  "OCW JAN 2018 RELEASE UPDATE 12.2.0.1.180116 (27335416)"
   Created on 8 Jan 2018, 23:51:29 hrs PST8PDT
   Bugs fixed:
     27068526, 27006180, 26755613, 26433979, 25698636, 25644425, 26664476
     26418606, 26115835, 26950548, 26419112, 25137752, 24902553, 25685286
     24696235, 24372941, 25716769, 26818368, 25576767, 26710631, 26624184
     26547521, 26111524, 25890662, 25803563, 25987595, 26817081, 26633228
     26593581, 26567325, 26493466, 26316238, 26144044, 25662028, 25540583
     24673586, 26818064, 26817995, 26791882, 25100966, 26431982, 25795447
     26822082, 26264417, 26052877, 24792446, 26357098, 26473232, 26552807
     26581118, 26257547, 25360754, 25774482, 26529142, 24736511, 26379711
     26248428, 25865563, 25408895, 25667162, 26301456, 26238801, 25801922
     25216003, 25825755, 25943805, 25233797, 25164540, 25049033, 24824518
     24509984, 24462646, 24422155, 23762756, 26546632, 24396050, 25956724
     25037011, 24831217, 25947195, 25066549, 25851874, 25397620, 25518447
     26391418, 26387283, 25996923, 24953946, 13250991, 22999793, 23301767
     25496699, 24670214, 22322021, 24583356, 22986384, 25291358, 26326556
     25784424, 25369170, 25301463, 25131365, 24797972, 25448476, 24403376
     25832312, 25697364, 25655495, 25646592, 25591658, 25569634, 25541343
     25537905, 25505841, 25493588, 25485737, 25409838, 25307145, 25245759
     25197670, 25197395, 25037836, 25026470, 25025157, 24932026, 24831158
     24808260, 24801915, 24796183, 24732650, 24665035, 24664849, 24663993
     24657753, 24584419, 24578464, 24464953, 24451580, 24423011, 20559126
     23722215, 23340259, 25499276, 25556203, 25564644, 25856024, 25354530
     26198627, 25785073, 25717212, 24445255, 25327670, 24600431, 25825732
     25790699, 25742471, 25715179, 25832375, 26088770, 25728787, 25371632

Patch  27144050     : applied on Thu Feb 08 15:29:28 KST 2018
Unique Patch ID:  21771994
Patch description:  "Tomcat Release Update 12.2.0.1.0(ID:171023.0830) (27144050)"
   Created on 26 Dec 2017, 23:52:30 hrs PST8PDT
   Bugs fixed:
     25728967, 26934551

Patch  27128906     : applied on Thu Feb 08 15:29:19 KST 2018
Unique Patch ID:  21724186
Patch description:  "ACFS Release Update : 12.2.0.1.0 (27128906)"
   Created on 16 Nov 2017, 02:05:54 hrs PST8PDT
   Bugs fixed:
     21129279, 22591010, 23152694, 23181299, 23625427, 24285969, 24652931
     24661214, 24674652, 24679041, 24690973, 24964969, 25078431, 25098392
     25375360, 25381434, 25480028, 25491831, 25526314, 25549648, 25560948
     25726952, 25764672, 25826440, 25966987, 26051087, 26085458, 26247490
     26275740, 26396215, 26625494, 26667459, 26759355, 26844019, 26871374
     26912733

Patch  27105253     : applied on Thu Feb 08 15:26:33 KST 2018
Unique Patch ID:  21862470
Patch description:  "Database Release Update : 12.2.0.1.180116 (27105253)"
   Created on 9 Jan 2018, 07:49:55 hrs PST8PDT
   Bugs fixed:
     23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877
     25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421
     25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959
     25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846
     24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398
     24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007
     25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332
     25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017
     22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726
     25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817
     24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628
     24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167
     25967985, 26546754, 26546664, 26544823, 26575788, 26271001, 26198926
     26025681, 26078437, 25789579, 25034396, 24655717, 25124363, 23527363
     25530814, 21981529, 25062592, 25057811, 23179662, 25530080, 25528838
     25417056, 25100579, 25739065, 25700654, 25655966, 25631933, 25616645
     25616417, 25594901, 25825910, 25789041, 22568728, 21159907, 20736227
     19327292, 14690846, 25099497, 24938784, 25257085, 25237577, 25230945
     25425760, 25337640, 25263960, 22654475, 21186167, 23491861, 23300142
     23234232, 23151677, 22981722, 23733981, 24556967, 24485161, 24457597
     24737064, 24578718, 24792678, 20324049, 17533661, 17027695, 22645009
     22628825, 23521523, 23499160, 24289874, 24421668, 24332831, 24425998
     24555417, 24737403, 25121089, 25192729, 25164293, 25150925, 25579761
     25570929, 25980605, 25954022, 25797124, 26308650, 26261327, 26088836
     25874050, 25178179, 25176408, 22072543, 23735292, 21985256, 22950945
     23746128, 25175723, 25451531, 25575628, 25838361, 25932524, 26479173
     26526726, 26609942, 24717183, 26362821, 25397936, 25554787, 26523432
     26599395, 26331743, 26476244, 26388538, 25498930, 26421667, 26446098
     26108080, 25648731, 25087436, 24812047, 25382812, 25695903, 25797092
     22179537, 26111842, 19285025, 25558986, 25551676, 24642495, 25633101
     25852885, 25897615, 26486365, 26333141, 26537307, 26444887, 26396790
     26358670, 26244115, 25489607, 25947799, 26095405, 26492866, 25248384
     26430737, 26187943, 26426526, 22898198, 23581777, 25694206, 26088426
     26045732, 24693290, 26153977, 25654936, 25870579, 20003668, 24912588
     25638456, 25320555, 25240590, 23599216, 25182817, 24735430, 25872127
     25192044, 20620169, 26324769, 24960044, 24677696, 25995938, 23125560
     23061453, 25166187, 25722608, 25662524, 25598473, 25774077, 19614243
     24664211, 25145215, 25123585, 24968162, 25241625, 25472112, 25463844
     25410802, 25383204, 22446455, 23481673, 23055900, 26249718, 25967544
     22087683, 23730961, 24376875, 24368004, 25162645, 25029022, 25099339
     25093872, 25433696, 25392535, 25357142, 25328518, 25553616, 25970731
     25953857, 26169345, 26169341, 26091640, 26032573, 22503297, 24341675
     24850622, 25186079, 25602488, 25861398, 25980770, 26096382, 26765212
     23035249, 24797119, 25405813, 24443539, 25098160, 25384462, 24593740
     25241448, 26751171, 26751106, 26545688, 26367012, 25871639, 25597525
     25546580, 25063971, 24654629, 23105538, 24401351, 25764020, 25259611
     25244807, 25265499, 26650226, 26330994, 26658759, 26351334, 22347493
     25140197, 26659182, 25990907, 25660847, 25411036, 24845157, 25888073
     20591151, 25954054, 25822410, 25788879, 25335790, 25199585, 24717859
     22564336, 24461826, 24337882, 24010030, 22826067, 26680105, 26626879
     26641610, 26189861, 25826740, 25335249, 25335360, 25100063, 21216226
     26327624, 25977302, 26597140, 26493289, 26435073, 25895224, 25634317
     24617969, 19211433, 25911724, 22599050, 24843188, 24486059, 24922704
     18594510, 19649997, 24680959, 25107662, 25964954, 23645516, 26237431
     25754606, 23572982, 25045228, 25462714, 25722720, 24848746, 24760407
     25203656, 25444961, 21520266, 23600861, 24600330, 24415926, 24423416
     17947871, 23066146, 24326444, 24346821, 24623975, 24699619, 24801152
     24786669, 24710696, 25065563, 25179774, 25129925, 25417958, 26237773
     27087426, 27009164, 26969321, 26366517, 26898563, 26784509, 26522439
     23271203, 22364044, 25307368, 26758193, 26542135, 15931756, 26548363
     25710420, 26434999, 25207410, 26223039, 25524955, 25579458, 25489367
     25313411, 24554533, 20756305, 25478885, 25858672, 26036748, 24966788
     24766309, 21178363, 23715460, 23197730, 23602213, 25072986, 25729507
     25890056, 25807997, 25206864, 23065002, 24345420, 24303148, 22864303
     24435982, 24848923, 24978100, 24953434, 25210268, 25209912, 25981498
     25919622, 25871177, 26569225, 26744595, 26908788, 25313154, 27135993
     26635897, 26939314, 26983259, 26820076, 25785441, 27142373, 26729494
     20532077, 23249829, 27073314, 26629381, 27079140, 26911000, 26944190
     25305405, 23741944, 25348956, 25768681, 26794786, 25646373, 24570598
     26399626, 25674386, 25225795, 25224242, 25536819, 25296876, 26375250
     25963024, 26615690, 26442308, 25476149, 26170715, 25685152, 24307571
     19526548, 24468470, 24744383, 25171084, 24713381, 24827654, 24343905
     21433452, 24373756, 24923790, 24911709, 26019148, 24940060, 24595699
     25691904, 25687460, 25672640, 25874678, 25785331, 22379010, 18521691
     8480838, 25159176, 25227381, 25561296, 25440818, 23588722, 24470606
     24692973, 24674197, 20118035, 24563422, 24759556, 25201454, 27165231

Patch  26839277     : applied on Thu Feb 08 15:25:59 KST 2018
Unique Patch ID:  21578760
Patch description:  "DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277)"
   Created on 21 Sep 2017, 03:13:10 hrs PST8PDT
   Bugs fixed:
     26584906



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

OPatch succeeded.

코드 블럭

language	bash
title	oracle 유저로 수행

$DB_HOME/OPatch/opatch lsinventory

펼치기

서식 미적용

[oracle@orcl ~]$ $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.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.2.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.12
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatch/opatch2018-02-08_15-35-23오후_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-02-08_15-35-23오후.txt

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

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

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


Interim 패치(2):

Patch  27335416     : applied on Thu Feb 08 15:25:42 KST 2018
Unique Patch ID:  21843624
Patch description:  "OCW JAN 2018 RELEASE UPDATE 12.2.0.1.180116 (27335416)"
   Created on 8 Jan 2018, 23:51:29 hrs PST8PDT
   Bugs fixed:
     27068526, 27006180, 26755613, 26433979, 25698636, 25644425, 26664476
     26418606, 26115835, 26950548, 26419112, 25137752, 24902553, 25685286
     24696235, 24372941, 25716769, 26818368, 25576767, 26710631, 26624184
     26547521, 26111524, 25890662, 25803563, 25987595, 26817081, 26633228
     26593581, 26567325, 26493466, 26316238, 26144044, 25662028, 25540583
     24673586, 26818064, 26817995, 26791882, 25100966, 26431982, 25795447
     26822082, 26264417, 26052877, 24792446, 26357098, 26473232, 26552807
     26581118, 26257547, 25360754, 25774482, 26529142, 24736511, 26379711
     26248428, 25865563, 25408895, 25667162, 26301456, 26238801, 25801922
     25216003, 25825755, 25943805, 25233797, 25164540, 25049033, 24824518
     24509984, 24462646, 24422155, 23762756, 26546632, 24396050, 25956724
     25037011, 24831217, 25947195, 25066549, 25851874, 25397620, 25518447
     26391418, 26387283, 25996923, 24953946, 13250991, 22999793, 23301767
     25496699, 24670214, 22322021, 24583356, 22986384, 25291358, 26326556
     25784424, 25369170, 25301463, 25131365, 24797972, 25448476, 24403376
     25832312, 25697364, 25655495, 25646592, 25591658, 25569634, 25541343
     25537905, 25505841, 25493588, 25485737, 25409838, 25307145, 25245759
     25197670, 25197395, 25037836, 25026470, 25025157, 24932026, 24831158
     24808260, 24801915, 24796183, 24732650, 24665035, 24664849, 24663993
     24657753, 24584419, 24578464, 24464953, 24451580, 24423011, 20559126
     23722215, 23340259, 25499276, 25556203, 25564644, 25856024, 25354530
     26198627, 25785073, 25717212, 24445255, 25327670, 24600431, 25825732
     25790699, 25742471, 25715179, 25832375, 26088770, 25728787, 25371632

Patch  27105253     : applied on Thu Feb 08 15:24:46 KST 2018
Unique Patch ID:  21862470
Patch description:  "Database Release Update : 12.2.0.1.180116 (27105253)"
   Created on 9 Jan 2018, 07:49:55 hrs PST8PDT
   Bugs fixed:
     23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877
     25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421
     25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959
     25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846
     24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398
     24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007
     25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332
     25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017
     22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726
     25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817
     24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628
     24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167
     25967985, 26546754, 26546664, 26544823, 26575788, 26271001, 26198926
     26025681, 26078437, 25789579, 25034396, 24655717, 25124363, 23527363
     25530814, 21981529, 25062592, 25057811, 23179662, 25530080, 25528838
     25417056, 25100579, 25739065, 25700654, 25655966, 25631933, 25616645
     25616417, 25594901, 25825910, 25789041, 22568728, 21159907, 20736227
     19327292, 14690846, 25099497, 24938784, 25257085, 25237577, 25230945
     25425760, 25337640, 25263960, 22654475, 21186167, 23491861, 23300142
     23234232, 23151677, 22981722, 23733981, 24556967, 24485161, 24457597
     24737064, 24578718, 24792678, 20324049, 17533661, 17027695, 22645009
     22628825, 23521523, 23499160, 24289874, 24421668, 24332831, 24425998
     24555417, 24737403, 25121089, 25192729, 25164293, 25150925, 25579761
     25570929, 25980605, 25954022, 25797124, 26308650, 26261327, 26088836
     25874050, 25178179, 25176408, 22072543, 23735292, 21985256, 22950945
     23746128, 25175723, 25451531, 25575628, 25838361, 25932524, 26479173
     26526726, 26609942, 24717183, 26362821, 25397936, 25554787, 26523432
     26599395, 26331743, 26476244, 26388538, 25498930, 26421667, 26446098
     26108080, 25648731, 25087436, 24812047, 25382812, 25695903, 25797092
     22179537, 26111842, 19285025, 25558986, 25551676, 24642495, 25633101
     25852885, 25897615, 26486365, 26333141, 26537307, 26444887, 26396790
     26358670, 26244115, 25489607, 25947799, 26095405, 26492866, 25248384
     26430737, 26187943, 26426526, 22898198, 23581777, 25694206, 26088426
     26045732, 24693290, 26153977, 25654936, 25870579, 20003668, 24912588
     25638456, 25320555, 25240590, 23599216, 25182817, 24735430, 25872127
     25192044, 20620169, 26324769, 24960044, 24677696, 25995938, 23125560
     23061453, 25166187, 25722608, 25662524, 25598473, 25774077, 19614243
     24664211, 25145215, 25123585, 24968162, 25241625, 25472112, 25463844
     25410802, 25383204, 22446455, 23481673, 23055900, 26249718, 25967544
     22087683, 23730961, 24376875, 24368004, 25162645, 25029022, 25099339
     25093872, 25433696, 25392535, 25357142, 25328518, 25553616, 25970731
     25953857, 26169345, 26169341, 26091640, 26032573, 22503297, 24341675
     24850622, 25186079, 25602488, 25861398, 25980770, 26096382, 26765212
     23035249, 24797119, 25405813, 24443539, 25098160, 25384462, 24593740
     25241448, 26751171, 26751106, 26545688, 26367012, 25871639, 25597525
     25546580, 25063971, 24654629, 23105538, 24401351, 25764020, 25259611
     25244807, 25265499, 26650226, 26330994, 26658759, 26351334, 22347493
     25140197, 26659182, 25990907, 25660847, 25411036, 24845157, 25888073
     20591151, 25954054, 25822410, 25788879, 25335790, 25199585, 24717859
     22564336, 24461826, 24337882, 24010030, 22826067, 26680105, 26626879
     26641610, 26189861, 25826740, 25335249, 25335360, 25100063, 21216226
     26327624, 25977302, 26597140, 26493289, 26435073, 25895224, 25634317
     24617969, 19211433, 25911724, 22599050, 24843188, 24486059, 24922704
     18594510, 19649997, 24680959, 25107662, 25964954, 23645516, 26237431
     25754606, 23572982, 25045228, 25462714, 25722720, 24848746, 24760407
     25203656, 25444961, 21520266, 23600861, 24600330, 24415926, 24423416
     17947871, 23066146, 24326444, 24346821, 24623975, 24699619, 24801152
     24786669, 24710696, 25065563, 25179774, 25129925, 25417958, 26237773
     27087426, 27009164, 26969321, 26366517, 26898563, 26784509, 26522439
     23271203, 22364044, 25307368, 26758193, 26542135, 15931756, 26548363
     25710420, 26434999, 25207410, 26223039, 25524955, 25579458, 25489367
     25313411, 24554533, 20756305, 25478885, 25858672, 26036748, 24966788
     24766309, 21178363, 23715460, 23197730, 23602213, 25072986, 25729507
     25890056, 25807997, 25206864, 23065002, 24345420, 24303148, 22864303
     24435982, 24848923, 24978100, 24953434, 25210268, 25209912, 25981498
     25919622, 25871177, 26569225, 26744595, 26908788, 25313154, 27135993
     26635897, 26939314, 26983259, 26820076, 25785441, 27142373, 26729494
     20532077, 23249829, 27073314, 26629381, 27079140, 26911000, 26944190
     25305405, 23741944, 25348956, 25768681, 26794786, 25646373, 24570598
     26399626, 25674386, 25225795, 25224242, 25536819, 25296876, 26375250
     25963024, 26615690, 26442308, 25476149, 26170715, 25685152, 24307571
     19526548, 24468470, 24744383, 25171084, 24713381, 24827654, 24343905
     21433452, 24373756, 24923790, 24911709, 26019148, 24940060, 24595699
     25691904, 25687460, 25672640, 25874678, 25785331, 22379010, 18521691
     8480838, 25159176, 25227381, 25561296, 25440818, 23588722, 24470606
     24692973, 24674197, 20118035, 24563422, 24759556, 25201454, 27165231



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

OPatch succeeded.

Pluggable DB 기동

코드 블럭

title	oracle 유저로 수행
linenumbers	true

select name, open_mode from v$pdbs;
alter pluggable database all open;
select name, open_mode from v$pdbs;

펼치기

서식 미적용

SQL> select name, open_mode from v$pdbs;

NAME                                                                             OPEN_MODE
-------------------------------------------------------------------------------- ----------
PDB$SEED                                                                         READ ONLY
ORCLPDB                                                                          MOUNTED

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> select name, open_mode from v$pdbs;

NAME                                                                             OPEN_MODE
-------------------------------------------------------------------------------- ----------
PDB$SEED                                                                         READ ONLY
ORCLPDB                                                                          READ WRITE

Datapatch 적용

코드 블럭

language	bash
title	oracle 유저로 수행

datapatch -verbose

펼치기

서식 미적용

[oracle@orcl ~]$ datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Thu Feb  8 15:37:07 2018
Copyright (c) 2012, 2017, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_28170_2018_02_08_15_37_07/sqlpatch_invocation.log

Connecting to database...OK
Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Bundle series DBRU:
  ID 180116 in the binary registry and not installed in any PDB

Adding patches to installation queue and performing prereq checks...
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED ORCLPDB
    Nothing to roll back
    The following patches will be applied:
      27105253 (DATABASE RELEASE UPDATE 12.2.0.1.180116)

Installing patches...
Patch installation complete.  Total patches installed: 3

Validating logfiles...
Patch 27105253 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27105253/21862470/27105253_apply_ORCL_CDBROOT_2018Feb08_15_37_21.log (no errors)
Patch 27105253 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27105253/21862470/27105253_apply_ORCL_PDBSEED_2018Feb08_15_38_30.log (no errors)
Patch 27105253 apply (pdb ORCLPDB): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27105253/21862470/27105253_apply_ORCL_ORCLPDB_2018Feb08_15_38_31.log (no errors)
SQL Patching tool complete on Thu Feb  8 15:39:28 2018

코드 블럭

title	oracle 유저로 수행

select PATCH_ID, VERSION, ACTION, STATUS, ACTION_TIME from DBA_REGISTRY_SQLPATCH;

...

Content

공간 도구

버전 비교

이전 버전 1

새 버전 현재

키

패치 환경 설정

OPatch 업데이트

패치 현황 조사

패치 충돌 여부 검증

디스크 공간 확인

패치 분석

패치 적용

패치 결과 확인

Pluggable DB 기동

Datapatch 적용