1. 패치 환경 설정
root 유저로 수행
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
2. OPatch 업데이트
root 유저로 수행
cd $GRID_HOME OPatch/opatch version mv OPatch OPatch.old cp -r <패치 파일 압축 해제 경로>/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.
root 유저로 수행
cd $DB_HOME mv OPatch OPatch.old cp -r <패치 파일 압축 해제 경로>/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.
3. 패치 현황 조사
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.
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.
4. 패치 충돌 여부 검증
grid 유저로 수행
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 파일 압축 해제 경로>/27100009/27105253 $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 파일 압축 해제 경로>/27100009/27335416 $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 파일 압축 해제 경로>/27100009/27128906 $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 파일 압축 해제 경로>/27100009/26839277 $GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 파일 압축 해제 경로>/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 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-10오후_1.log 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 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-15오후_1.log 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 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-21오후_1.log 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 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-26오후_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
oracle 유저로 수행
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 파일 압축 해제 경로>/27100009/27105253 $DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <패치 파일 압축 해제 경로>/27100009/27335416
[oracle@orcl ~]$ $DB_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/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오후_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@orcl ~]$ $DB_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 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-49오후_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
5. 디스크 공간 확인
grid 유저로 수행
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 [grid@+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 ~]$ $GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_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/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-11-43오후_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded.
oracle 유저로 수행
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.
6. 패치 분석
root 유저로 수행
$GRID_HOME/OPatch/opatchauto apply <패치 파일 압축 해제 경로>/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
7. 패치 적용
root 유저로 수행
$GRID_HOME/OPatch/opatchauto apply <패치 파일 압축 해제 경로>/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
8. 패치 결과 확인
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.
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.
9. Pluggable DB 기동
oracle 유저로 수행
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
10. Datapatch 적용
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
oracle 유저로 수행
select PATCH_ID, VERSION, ACTION, STATUS, ACTION_TIME from DBA_REGISTRY_SQLPATCH;
SQL> select PATCH_ID, VERSION, ACTION, STATUS, ACTION_TIME from DBA_REGISTRY_SQLPATCH; PATCH_ID VERSION ACTION STATUS ACTION_TIME ---------- -------------------- --------------- --------------- --------------------------------------------------------------------------- 27105253 12.2.0.1 APPLY SUCCESS 18/02/08 15:39:24.629152
