探索Oracle之数据库升级一,探索Oracle之数据库升级十 12c(12.1.0.2)CPU 19774304

最新推荐文章于 2023-08-19 22:15:41 发布

编程光影幻梦

最新推荐文章于 2023-08-19 22:15:41 发布

阅读量580

点赞数

文章标签：探索Oracle之数据库升级一

探索Oracle之数据库升级十

12c(12.1.0.2)CPU 19774304

一、补丁描述

参考metalink doc: (Doc ID 19774304.8)

Bug19774304 - 12.1.0.2 Bundle Patch 2 for Engineered Systems and DB In-Memory (Nov2014) (Doc ID 19774304.8)

二、补丁包含

19649591

DATABASE BUNDLE PATCH 12.1.0.2.2

(Oracle Database)

19392590

ACFS PATCH SET UPDATE 12.1.0.2.1

(Oracle Database)

19392604

OCW PATCH SET UPDATE 12.1.0.2.1

(Oracle Database)

19392590

ACFS PATCH SET UPDATE 12.1.0.2.1

(Oracle Database)

19392590

ACFS PATCH SET UPDATE 12.1.0.2.1

(Oracle Database)

19392604

OCW PATCH SET UPDATE 12.1.0.2.1

(Oracle Database)

19392604

OCW PATCH SET UPDATE 12.1.0.2.1

(Oracle Database)

三、补丁修复包含如下bug

五、了解补丁相关知识之后对漏洞进行修复

5.1 下载对应的OPatch utility 工具，该补丁最低要求使用 Opatch v12.1.0.1.5版本进行升级，下载参考MOS:6880880

5.2 停止所有数据库及监听

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@db01 ~]$ lsnrctl stop

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 03-DEC-2014 04:17:40

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db01)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 2: No such file or directory

[oracle@db01 ~]$ ps -ef|grep ora-

oracle 32466 31415 0 04:20 pts/1 00:00:00 grep ora-

5.3 上传介质，并解压缩

[oracle@db01 ~]$ ll p*

-rw-r--r-- 1 oracle oinstall 919632149 Dec 3 03:55 p19774304_121020_Linux-x86-64.zip

-rw-r--r-- 1 oracle oinstall 49904740 Dec 3 04:23 p6880880_121010_Linux-x86-64.zip

-rwxr-xr-x 1 oracle oinstall 5436 Nov 20 05:17 preupgrd.sql

[oracle@db01 ~]$ unzip p6880880_121010_Linux-x86-64.zip

[oracle@db01 ~]$ unzip p19774304_121020_Linux-x86-64.zip

[oracle@db01 ~]$ ll

total 948276

drwxr-xr-x 6 oracle oinstall 4096 Nov 14 14:14 19774304

drwxrwxr-x 7 oracle oinstall 4096 Sep 29 18:01 OPatch

-rw-r--r-- 1 oracle oinstall 919632149 Dec 3 03:55 p19774304_121020_Linux-x86-64.zip

-rw-r--r-- 1 oracle oinstall 49904740 Dec 3 04:23 p6880880_121010_Linux-x86-64.zip

5.4 查看当前的OPatch 版本及CPU信息

[oracle@db01 OPatch]$ ./opatch version

OPatch Version: 12.1.0.1.5

OPatch succeeded.

[oracle@db01 OPatch]$ ./opatch lsinv

Oracle Interim Patch Installer version 12.1.0.1.5

Oracle Home : /DBSoft/Product/12.1.0.2/db_1

Central Inventory : /DBSoft/oraInventory

from : /DBSoft/Product/12.1.0.2/db_1/oraInst.loc

OPatch version : 12.1.0.1.5

OUI version : 12.1.0.2.0

Log file location : /DBSoft/Product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2014-12-03_04-48-08AM_1.log

Lsinventory Output file location : /DBSoft/Product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-12-03_04-48-08AM.txt

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

Installed Top-level Products (1):

Oracle Database 12c 12.1.0.2.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

5.5 查看升级前各组件的版本信息

[oracle@db01 19774304]$ opatch lsinventory -detail -oh $ORACLE_HOME

Oracle Interim Patch Installer version 12.1.0.1.5

Oracle Home : /DBSoft/Product/12.1.0.2/db_1

Central Inventory : /DBSoft/oraInventory

from : /DBSoft/Product/12.1.0.2/db_1/oraInst.loc

OPatch version : 12.1.0.1.5

OUI version : 12.1.0.2.0

Log file location : /DBSoft/Product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2014-12-03_05-14-41AM_1.log

Lsinventory Output file location : /DBSoft/Product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-12-03_05-14-41AM.txt

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

Installed Top-level Products (1):

Oracle Database 12c 12.1.0.2.0

There are 1 products installed in this Oracle Home.

Installed Products (135):

Assistant Common Files 12.1.0.2.0

Buildtools Common Files 12.1.0.2.0

Cluster Verification Utility Common Files 12.1.0.2.0

Database Configuration and Upgrade Assistants 12.1.0.2.0

Database Migration Assistant for Unicode 12.1.0.2.0

Database SQL Scripts 12.1.0.2.0

Database Workspace Manager 12.1.0.2.0

DB TOOLS Listener 12.1.0.2.0

Deinstallation Tool 12.1.0.2.0

Enterprise Edition Options 12.1.0.2.0

Expat libraries 2.0.1.0.2

Generic Connectivity Common Files 12.1.0.2.0

Hadoopcore Component 12.1.0.2.0

HAS Common Files 12.1.0.2.0

HAS Files for DB 12.1.0.2.0

Installation Common Files 12.1.0.2.0

Installation Plugin Files 12.1.0.2.0

Installer SDK Component 12.1.0.2.0

JAccelerator (COMPANION) 12.1.0.2.0

Java Development Kit 1.6.0.75.0

LDAP Required Support Files 12.1.0.2.0

OLAP SQL Scripts 12.1.0.2.0

Oracle Advanced Security 12.1.0.2.0

Oracle Application Express 12.1.0.2.0

Oracle Bali Share 11.1.1.6.0

Oracle Call Interface (OCI) 12.1.0.2.0

Oracle Clusterware RDBMS Files 12.1.0.2.0

Oracle Configuration Manager 10.3.8.1.1

Oracle Configuration Manager Client 10.3.2.1.0

Oracle Configuration Manager Deconfiguration 10.3.1.0.0

Oracle Containers for Java 12.1.0.2.0

Oracle Context Companion 12.1.0.2.0

Oracle Core Required Support Files 12.1.0.2.0

Oracle Core Required Support Files for Core DB 12.1.0.2.0

Oracle Core XML Development Kit 12.1.0.2.0

Oracle Data Mining RDBMS Files 12.1.0.2.0

Oracle Database 12c 12.1.0.2.0

Oracle Database 12c Multimedia Files 12.1.0.2.0

Oracle Database Deconfiguration 12.1.0.2.0

Oracle Database Gateway for ODBC 12.1.0.2.0

Oracle Database Plugin for Oracle Virtual Assembly Builder 12.1.0.2.0

Oracle Database User Interface 11.0.0.0.0

Oracle Database Utilities 12.1.0.2.0

Oracle Database Vault option 12.1.0.2.0

Oracle DBCA Deconfiguration 12.1.0.2.0

Oracle Extended Windowing Toolkit 11.1.1.6.0

Oracle Globalization Support 12.1.0.2.0

Oracle Globalization Support For Core 12.1.0.2.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.1.0.2.0

Oracle Java Client 12.1.0.2.0

Oracle Java Layout Engine 11.0.0.0.0

Oracle JDBC Server Support Package 12.1.0.2.0

Oracle JDBC/OCI Instant Client 12.1.0.2.0

Oracle JDBC/THIN Interfaces 12.1.0.2.0

Oracle JFC Extended Windowing Toolkit 11.1.1.6.0

Oracle JVM 12.1.0.2.0

Oracle JVM For Core 12.1.0.2.0

Oracle Label Security 12.1.0.2.0

Oracle LDAP administration 12.1.0.2.0

Oracle Locale Builder 12.1.0.2.0

Oracle Message Gateway Common Files 12.1.0.2.0

Oracle Multimedia 12.1.0.2.0

Oracle Multimedia Client Option 12.1.0.2.0

Oracle Multimedia Java Advanced Imaging 12.1.0.2.0

Oracle Multimedia Locator 12.1.0.2.0

Oracle Multimedia Locator Java Required Support Files 12.1.0.2.0

Oracle Multimedia Locator RDBMS Files 12.1.0.2.0

Oracle Net 12.1.0.2.0

Oracle Net Java Required Support Files 12.1.0.2.0

Oracle Net Listener 12.1.0.2.0

Oracle Net Required Support Files 12.1.0.2.0

Oracle Net Services 12.1.0.2.0

Oracle Netca Client 12.1.0.2.0

Oracle Notification Service 12.1.0.2.0

Oracle Notification Service (eONS) 12.1.0.2.0

Oracle Notification Service for Instant Client 12.1.0.2.0

Oracle ODBC Driver 12.1.0.2.0

Oracle ODBC Driverfor Instant Client 12.1.0.2.0

Oracle OLAP 12.1.0.2.0

Oracle OLAP API 12.1.0.2.0

Oracle OLAP RDBMS Files 12.1.0.2.0

Oracle One-Off Patch Installer 12.1.0.1.2

Oracle Partitioning 12.1.0.2.0

Oracle Programmer 12.1.0.2.0

Oracle Quality of Service Management (Client) 12.1.0.2.0

Oracle R Enterprise Server Files 12.1.0.2.0

Oracle RAC Deconfiguration 12.1.0.2.0

Oracle RAC Required Support Files-HAS 12.1.0.2.0

Oracle Real Application Testing 12.1.0.2.0

Oracle Recovery Manager 12.1.0.2.0

Oracle Security Developer Tools 12.1.0.2.0

Oracle Spatial and Graph 12.1.0.2.0

Oracle SQL Developer 12.1.0.2.0

Oracle Starter Database 12.1.0.2.0

Oracle Text 12.1.0.2.0

Oracle Text ATG Language Support Files 12.1.0.2.0

Oracle Text for Core 12.1.0.2.0

Oracle Text Required Support Files 12.1.0.2.0

Oracle Universal Connection Pool 12.1.0.2.0

Oracle Universal Installer 12.1.0.2.0

Oracle USM Deconfiguration 12.1.0.2.0

Oracle Wallet Manager 12.1.0.2.0

Oracle XML Development Kit 12.1.0.2.0

Oracle XML Query 12.1.0.2.0

oracle.swd.oui.core.min 12.1.0.2.0

Parser Generator Required Support Files 12.1.0.2.0

Perl Interpreter 5.14.1.0.0

Perl Modules 5.14.1.0.0

PL/SQL 12.1.0.2.0

PL/SQL Embedded Gateway 12.1.0.2.0

Platform Required Support Files 12.1.0.2.0

Precompiler Common Files 12.1.0.2.0

Precompiler Common Files for Core 12.1.0.2.0

Precompiler Required Support Files 12.1.0.2.0

Precompilers 12.1.0.2.0

RDBMS Required Support Files 12.1.0.2.0

RDBMS Required Support Files for Instant Client 12.1.0.2.0

RDBMS Required Support Files Runtime 12.1.0.2.0

Required Support Files 12.1.0.2.0

Sample Schema Data 12.1.0.2.0

Secure Socket Layer 12.1.0.2.0

SQL*Plus 12.1.0.2.0

SQL*Plus Files for Instant Client 12.1.0.2.0

SQL*Plus Required Support Files 12.1.0.2.0

SQLJ Runtime 12.1.0.2.0

SSL Required Support Files for InstantClient 12.1.0.2.0

Tracle File Analyzer 12.1.0.2.0

XDK Required Support Files 12.1.0.2.0

XML Parser for Java 12.1.0.2.0

XML Parser for Oracle JVM 12.1.0.2.0

There are 135 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

5.5 进入解压后的CPU 19774304目录

5.6 开始应用补丁：

[oracle@db01 ~]$ opatch apply 19774304/19392604/

Oracle Interim Patch Installer version 12.1.0.1.5

Oracle Home : /DBSoft/Product/12.1.0.2/db_1

Central Inventory : /DBSoft/oraInventory

from : /DBSoft/Product/12.1.0.2/db_1/oraInst.loc

OPatch version : 12.1.0.1.5

OUI version : 12.1.0.2.0

Log file location : /DBSoft/Product/12.1.0.2/db_1/cfgtoollogs/opatch/19392604_Dec_03_2014_05_22_58/apply2014-12-03_05-22-58AM_1.log

Applying interim patch '19392604' to OH '/DBSoft/Product/12.1.0.2/db_1'

Verifying environment and performing prerequisite checks...

Patch 19392604: Optional component(s) missing : [ oracle.crs, 12.1.0.2.0 ]

All checks passed.

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: N

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/DBSoft/Product/12.1.0.2/db_1')

Is the local system ready for patching? [y|n]

User Responded with: Y

Backing up files...

Patching component oracle.has.db, 12.1.0.2.0...

Patching component oracle.has.common, 12.1.0.2.0...

Verifying the update...

Patch 19392604 successfully applied

Log file location: /DBSoft/Product/12.1.0.2/db_1/cfgtoollogs/opatch/19392604_Dec_03_2014_05_22_58/apply2014-12-03_05-22-58AM_1.log

OPatch succeeded.

5.7 至此，CPU升级已经完成：

[oracle@db01 ~]$ opatch lsinventory

Oracle Interim Patch Installer version 12.1.0.1.5

Oracle Home : /DBSoft/Product/12.1.0.2/db_1

Central Inventory : /DBSoft/oraInventory

from : /DBSoft/Product/12.1.0.2/db_1/oraInst.loc

OPatch version : 12.1.0.1.5

OUI version : 12.1.0.2.0

Log file location : /DBSoft/Product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2014-12-03_05-27-12AM_1.log

Lsinventory Output file location : /DBSoft/Product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-12-03_05-27-12AM.txt

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

Installed Top-level Products (1):

Oracle Database 12c 12.1.0.2.0

There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch 19392604 : applied on Wed Dec 03 05:24:11 CST 2014

Unique Patch ID: 17950910

Patch description: "OCW PATCH SET UPDATE : 12.1.0.2.1 (19392604)"

Created on 15 Oct 2014, 00:35:12 hrs PST8PDT

Bugs fixed:

19164099, 18589889, 19139608, 19280860, 18955644, 19061429, 19133945

18798432, 19146822, 19135521, 19187207, 19302350, 19130141, 16286734

19266658, 18899171, 18945249, 19045143, 19146980, 19244316, 19184799

18634372, 19027351, 19205086, 19184188, 19131709, 18862203, 19079087

19031737, 18991776, 18439295, 18968981, 19148367, 19150517, 18943696

19217019, 19163425, 18849021, 18730096, 18890943, 18975620, 19205617

18861196, 19154753, 17940721, 19150313, 18843054, 18708349, 18748932

18835283, 19184765, 19499021, 19067804, 19046190, 19051385, 19209951

19054979, 19050688, 19154673, 19226141, 19053891, 18871287, 19150088

18998228, 18922918, 18980002, 19013444, 18956780, 19234177, 18998379

19026993, 19273577, 18777835, 17338864, 19075747, 19288396, 18990354

19427050, 18952577, 19127078, 19147513, 18910443, 19148982, 19178517

18813323, 18643483, 18523468, 19277814, 19134098, 19071526, 18536826

18965694, 19226858, 18850051, 19602208, 19192901, 18417590, 18920408

18636884, 18776786, 18989446, 19148793, 19043795, 18317489, 19029647

18919682, 18901356, 19140712, 19807548, 19124972, 18678829, 18910748

18849896, 19147509, 18953878, 19273758, 18964974, 18999195, 18759724

18835366, 19184276, 19207286, 19013789, 18950232, 19259765, 19066844

19148791, 18962892, 19062675, 19187515, 18859710, 19230771, 19453778

18304090, 19314048, 18834934, 19068333, 19241655, 18843572, 19458082

18242738, 18894342, 18945435, 19185148, 19232454, 18953889, 19319192

19259290, 19140711, 19204743, 19023430, 19045388, 19241857, 19140891

19076778, 18875012, 18861564, 19066699, 19273760, 19225265, 18798573

19018001, 19325701, 19270956, 18819158, 19068003, 18937186, 19049721

18700893, 19222693, 18406774, 18868829, 19010177, 19141785, 19163887

18715868, 18852058

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

OPatch succeeded.

[oracle@db01 ~]$ opatch lsinventory -detail -oh $ORACLE_HOME |more

Oracle Interim Patch Installer version 12.1.0.1.5

Oracle Home : /DBSoft/Product/12.1.0.2/db_1

Central Inventory : /DBSoft/oraInventory

from : /DBSoft/Product/12.1.0.2/db_1/oraInst.loc

OPatch version : 12.1.0.1.5

OUI version : 12.1.0.2.0

Log file location : /DBSoft/Product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2014-12-03_05-28-07AM_1.log

Lsinventory Output file location : /DBSoft/Product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-12-03_05-28-07AM.txt