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

探索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


14643995


ONLY 1 SQLPATCH
INVOCATION AT A TIME


15996428


SESSIONS SID BLOCKING
0 SESSIONS


16010876


ORA-00600: [KFDPARALLELIO2]
IN ASM WHEN I/O EMULATION


16286734


NLS:12.1_WIN64_130128:THERE
ARE MANY QUESTION MASK IN GI INSTALLATION LOG


16293223


HEALTH FACTOR IMPROVEMENTS.


16359751


ORA-600[QCSGPVC:TBL2EVCOLNO:COLUMNS]
DURING INSERT


17158137


RULES TESTS FAIL
IN LOGICAL STANDBY WITH ORA-600 [17182]


17338864


LNX64-12.1-GH:PROVISION
FROM GHS TO GHC FAILED WITH PRGO-1129


17940721


W2K8_12102:CVU
PREREQ CHECK SHOULD FAIL WHEN ASM DISK IS OFFLINE IN REMOTE NODE


17972478


PACKAGE DBMS_COMPRESSION.GET_COMRESSION_TYPE
SHOWS INCORRECT INFORMATION

四、   该补丁具体说明:
https://updates.oracle.com/Orion/Services/download?type=readme&aru=18125377#CIHCFEJE

五、   了解补丁相关知识之后对漏洞进行修复
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

Copyright (c) 1991, 2014, Oracle. All rights reserved.

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
Copyright (c) 2014, Oracle Corporation. All rights reserved.

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
Copyright (c) 2014, Oracle Corporation. All rights reserved.

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 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 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
Copyright (c) 2014, Oracle Corporation.  All rights reserved.

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]
y
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
Copyright (c) 2014, Oracle Corporation.  All rights reserved.

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
Copyright (c) 2014, Oracle Corporation.  All rights reserved.

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

--------------------------------------------------------------------------------
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                                                  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                                         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.
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
   Files Touched:
     cluvfyrac.sh --> ORACLE_HOME/bin/cluvfyrac.sh
     crsdiag.pl --> ORACLE_HOME/bin/crsdiag.pl
     kfod --> ORACLE_HOME/bin/kfod
     lsnodes --> ORACLE_HOME/bin/lsnodes
     srvconfig --> ORACLE_HOME/bin/srvconfig
     libclsr12.a --> ORACLE_HOME/lib/libclsr12.a
     libskjcx12.so --> ORACLE_HOME/lib/libskjcx12.so
     libsrvm12.so --> ORACLE_HOME/oui/lib/libsrvm12.so
     ins_has.mk --> ORACLE_HOME/racg/lib/ins_has.mk
     clustdb.sql --> ORACLE_HOME/srvm/admin/clustdb.sql
     init.ora --> ORACLE_HOME/srvm/admin/init.ora
     libdbcfg12.a --> ORACLE_HOME/srvm/lib/libdbcfg12.a
     libocr12.a --> ORACLE_HOME/srvm/lib/libocr12.a
     libocrb12.a --> ORACLE_HOME/srvm/lib/libocrb12.a
     libocrutl12.a --> ORACLE_HOME/srvm/lib/libocrutl12.a
     libsrvm12.a --> ORACLE_HOME/srvm/lib/libsrvm12.a
     libsrvmhas12.a --> ORACLE_HOME/srvm/lib/libsrvmhas12.a
     libsrvmocr12.a --> ORACLE_HOME/srvm/lib/libsrvmocr12.a
     libuini12.a --> ORACLE_HOME/srvm/lib/libuini12.a
     pradmgrp.o --> ORACLE_HOME/srvm/lib/pradmgrp.o
     prifcg.o --> ORACLE_HOME/srvm/lib/prifcg.o
     prifcmn.o --> ORACLE_HOME/srvm/lib/prifcmn.o
     prifutl.o --> ORACLE_HOME/srvm/lib/prifutl.o
     prraw.o --> ORACLE_HOME/srvm/lib/prraw.o
     sprdbgrp.o --> ORACLE_HOME/srvm/lib/sprdbgrp.o
     sprifcg.o --> ORACLE_HOME/srvm/lib/sprifcg.o
     sprraw.o --> ORACLE_HOME/srvm/lib/sprraw.o
     srvm.jar --> ORACLE_HOME/oui/jlib/srvm.jar
     srvmasm.jar --> ORACLE_HOME/oui/jlib/srvmasm.jar
     libsrvm12.so --> ORACLE_HOME/oui/lib/linux/libsrvm12.so
     s_crsconfig_defs --> ORACLE_HOME/crs/install/s_crsconfig_defs
     env_has.mk --> ORACLE_HOME/crs/lib/env_has.mk
     crsar.msb --> ORACLE_HOME/crs/mesg/crsar.msb
     crscs.msb --> ORACLE_HOME/crs/mesg/crscs.msb
     crsd.msb --> ORACLE_HOME/crs/mesg/crsd.msb
     crsdk.msb --> ORACLE_HOME/crs/mesg/crsdk.msb
     crse.msb --> ORACLE_HOME/crs/mesg/crse.msb
     crsel.msb --> ORACLE_HOME/crs/mesg/crsel.msb
     crshu.msb --> ORACLE_HOME/crs/mesg/crshu.msb
     crsi.msb --> ORACLE_HOME/crs/mesg/crsi.msb
     crsiw.msb --> ORACLE_HOME/crs/mesg/crsiw.msb
     crsja.msb --> ORACLE_HOME/crs/mesg/crsja.msb
     crsko.msb --> ORACLE_HOME/crs/mesg/crsko.msb
     crsn.msb --> ORACLE_HOME/crs/mesg/crsn.msb
     crsnl.msb --> ORACLE_HOME/crs/mesg/crsnl.msb
     crspl.msb --> ORACLE_HOME/crs/mesg/crspl.msb
     crspt.msb --> ORACLE_HOME/crs/mesg/crspt.msb
     crsptb.msb --> ORACLE_HOME/crs/mesg/crsptb.msb
     crsro.msb --> ORACLE_HOME/crs/mesg/crsro.msb
     crsru.msb --> ORACLE_HOME/crs/mesg/crsru.msb
     crss.msb --> ORACLE_HOME/crs/mesg/crss.msb
     crssf.msb --> ORACLE_HOME/crs/mesg/crssf.msb
     crssk.msb --> ORACLE_HOME/crs/mesg/crssk.msb
     crsth.msb --> ORACLE_HOME/crs/mesg/crsth.msb
     crstr.msb --> ORACLE_HOME/crs/mesg/crstr.msb
     crsus.msb --> ORACLE_HOME/crs/mesg/crsus.msb
     crsus.msg --> ORACLE_HOME/crs/mesg/crsus.msg
     crszhs.msb --> ORACLE_HOME/crs/mesg/crszhs.msb
     crszht.msb --> ORACLE_HOME/crs/mesg/crszht.msb
     clsrwrap.sbs --> ORACLE_HOME/crs/sbs/clsrwrap.sbs
     diagcollection.sh.sbs --> ORACLE_HOME/crs/sbs/diagcollection.sh.sbs
     localconfig.sbs --> ORACLE_HOME/crs/sbs/localconfig.sbs
     srvctl.sbs --> ORACLE_HOME/crs/sbs/srvctl.sbs
     clssar.msb --> ORACLE_HOME/css/mesg/clssar.msb
     clsscs.msb --> ORACLE_HOME/css/mesg/clsscs.msb
     clssd.msb --> ORACLE_HOME/css/mesg/clssd.msb
     clssdk.msb --> ORACLE_HOME/css/mesg/clssdk.msb
     clsse.msb --> ORACLE_HOME/css/mesg/clsse.msb
     clssel.msb --> ORACLE_HOME/css/mesg/clssel.msb
     clsshu.msb --> ORACLE_HOME/css/mesg/clsshu.msb
     clssi.msb --> ORACLE_HOME/css/mesg/clssi.msb
     clssiw.msb --> ORACLE_HOME/css/mesg/clssiw.msb
     clssja.msb --> ORACLE_HOME/css/mesg/clssja.msb
     clssko.msb --> ORACLE_HOME/css/mesg/clssko.msb
     clssn.msb --> ORACLE_HOME/css/mesg/clssn.msb
     clssnl.msb --> ORACLE_HOME/css/mesg/clssnl.msb
     clsspl.msb --> ORACLE_HOME/css/mesg/clsspl.msb
     clsspt.msb --> ORACLE_HOME/css/mesg/clsspt.msb
     clssptb.msb --> ORACLE_HOME/css/mesg/clssptb.msb
     clssro.msb --> ORACLE_HOME/css/mesg/clssro.msb
     clssru.msb --> ORACLE_HOME/css/mesg/clssru.msb
     clsss.msb --> ORACLE_HOME/css/mesg/clsss.msb
     clsssf.msb --> ORACLE_HOME/css/mesg/clsssf.msb
     clsssk.msb --> ORACLE_HOME/css/mesg/clsssk.msb
     clssth.msb --> ORACLE_HOME/css/mesg/clssth.msb
     clsstr.msb --> ORACLE_HOME/css/mesg/clsstr.msb
     clssus.msb --> ORACLE_HOME/css/mesg/clssus.msb
     clssus.msg --> ORACLE_HOME/css/mesg/clssus.msg
     clsszhs.msb --> ORACLE_HOME/css/mesg/clsszhs.msb
     clsszht.msb --> ORACLE_HOME/css/mesg/clsszht.msb
     catus.msg --> ORACLE_HOME/has/mesg/catus.msg
     clsdar.msb --> ORACLE_HOME/has/mesg/clsdar.msb
     clsdcs.msb --> ORACLE_HOME/has/mesg/clsdcs.msb
     clsdd.msb --> ORACLE_HOME/has/mesg/clsdd.msb
     clsddk.msb --> ORACLE_HOME/has/mesg/clsddk.msb
     clsde.msb --> ORACLE_HOME/has/mesg/clsde.msb
     clsdel.msb --> ORACLE_HOME/has/mesg/clsdel.msb
     clsdf.msb --> ORACLE_HOME/has/mesg/clsdf.msb
     clsdhu.msb --> ORACLE_HOME/has/mesg/clsdhu.msb
     clsdi.msb --> ORACLE_HOME/has/mesg/clsdi.msb
     clsdiw.msb --> ORACLE_HOME/has/mesg/clsdiw.msb
     clsdja.msb --> ORACLE_HOME/has/mesg/clsdja.msb
     clsdko.msb --> ORACLE_HOME/has/mesg/clsdko.msb
     clsdn.msb --> ORACLE_HOME/has/mesg/clsdn.msb
     clsdnl.msb --> ORACLE_HOME/has/mesg/clsdnl.msb
     clsdpl.msb --> ORACLE_HOME/has/mesg/clsdpl.msb
     clsdpt.msb --> ORACLE_HOME/has/mesg/clsdpt.msb
     clsdptb.msb --> ORACLE_HOME/has/mesg/clsdptb.msb
     clsdro.msb --> ORACLE_HOME/has/mesg/clsdro.msb
     clsdru.msb --> ORACLE_HOME/has/mesg/clsdru.msb
     clsds.msb --> ORACLE_HOME/has/mesg/clsds.msb
     clsdsf.msb --> ORACLE_HOME/has/mesg/clsdsf.msb
     clsdsk.msb --> ORACLE_HOME/has/mesg/clsdsk.msb
     clsdth.msb --> ORACLE_HOME/has/mesg/clsdth.msb
     clsdtr.msb --> ORACLE_HOME/has/mesg/clsdtr.msb
     clsdus.msb --> ORACLE_HOME/has/mesg/clsdus.msb
     clsdus.msg --> ORACLE_HOME/has/mesg/clsdus.msg
     clsdzhs.msb --> ORACLE_HOME/has/mesg/clsdzhs.msb
     clsdzht.msb --> ORACLE_HOME/has/mesg/clsdzht.msb
     clsgnar.msb --> ORACLE_HOME/has/mesg/clsgnar.msb
     clsgnca.msb --> ORACLE_HOME/has/mesg/clsgnca.msb
     clsgncs.msb --> ORACLE_HOME/has/mesg/clsgncs.msb
     clsgnd.msb --> ORACLE_HOME/has/mesg/clsgnd.msb
     clsgndk.msb --> ORACLE_HOME/has/mesg/clsgndk.msb
     clsgne.msb --> ORACLE_HOME/has/mesg/clsgne.msb
     clsgnel.msb --> ORACLE_HOME/has/mesg/clsgnel.msb
     clsgnesa.msb --> ORACLE_HOME/has/mesg/clsgnesa.msb
     clsgnf.msb --> ORACLE_HOME/has/mesg/clsgnf.msb
     clsgnhu.msb --> ORACLE_HOME/has/mesg/clsgnhu.msb
     clsgni.msb --> ORACLE_HOME/has/mesg/clsgni.msb
     clsgniw.msb --> ORACLE_HOME/has/mesg/clsgniw.msb
     clsgnja.msb --> ORACLE_HOME/has/mesg/clsgnja.msb
     clsgnko.msb --> ORACLE_HOME/has/mesg/clsgnko.msb
     clsgnn.msb --> ORACLE_HOME/has/mesg/clsgnn.msb
     clsgnnl.msb --> ORACLE_HOME/has/mesg/clsgnnl.msb
     clsgnpl.msb --> ORACLE_HOME/has/mesg/clsgnpl.msb
     clsgnpt.msb --> ORACLE_HOME/has/mesg/clsgnpt.msb
     clsgnptb.msb --> ORACLE_HOME/has/mesg/clsgnptb.msb
     clsgnro.msb --> ORACLE_HOME/has/mesg/clsgnro.msb
     clsgnru.msb --> ORACLE_HOME/has/mesg/clsgnru.msb
     clsgns.msb --> ORACLE_HOME/has/mesg/clsgns.msb
     clsgnsf.msb --> ORACLE_HOME/has/mesg/clsgnsf.msb
     clsgnsk.msb --> ORACLE_HOME/has/mesg/clsgnsk.msb
     clsgnth.msb --> ORACLE_HOME/has/mesg/clsgnth.msb
     clsgntr.msb --> ORACLE_HOME/has/mesg/clsgntr.msb
     clsgnus.msb --> ORACLE_HOME/has/mesg/clsgnus.msb
     clsgnus.msg --> ORACLE_HOME/has/mesg/clsgnus.msg
     clsgnzhs.msb --> ORACLE_HOME/has/mesg/clsgnzhs.msb
     clsgnzht.msb --> ORACLE_HOME/has/mesg/clsgnzht.msb
     clsnsar.msb --> ORACLE_HOME/has/mesg/clsnsar.msb
     clsnscs.msb --> ORACLE_HOME/has/mesg/clsnscs.msb
     clsnsd.msb --> ORACLE_HOME/has/mesg/clsnsd.msb
     clsnsdk.msb --> ORACLE_HOME/has/mesg/clsnsdk.msb
     clsnse.msb --> ORACLE_HOME/has/mesg/clsnse.msb
     clsnsel.msb --> ORACLE_HOME/has/mesg/clsnsel.msb
     clsnsf.msb --> ORACLE_HOME/has/mesg/clsnsf.msb
     clsnshu.msb --> ORACLE_HOME/has/mesg/clsnshu.msb
     clsnsi.msb --> ORACLE_HOME/has/mesg/clsnsi.msb
     clsnsiw.msb --> ORACLE_HOME/has/mesg/clsnsiw.msb
     clsnsja.msb --> ORACLE_HOME/has/mesg/clsnsja.msb
     clsnsko.msb --> ORACLE_HOME/has/mesg/clsnsko.msb
     clsnsn.msb --> ORACLE_HOME/has/mesg/clsnsn.msb
     clsnsnl.msb --> ORACLE_HOME/has/mesg/clsnsnl.msb
     clsnspl.msb --> ORACLE_HOME/has/mesg/clsnspl.msb
     clsnspt.msb --> ORACLE_HOME/has/mesg/clsnspt.msb
     clsnsptb.msb --> ORACLE_HOME/has/mesg/clsnsptb.msb
     clsnsro.msb --> ORACLE_HOME/has/mesg/clsnsro.msb
     clsnsru.msb --> ORACLE_HOME/has/mesg/clsnsru.msb
     clsnss.msb --> ORACLE_HOME/has/mesg/clsnss.msb
     clsnssf.msb --> ORACLE_HOME/has/mesg/clsnssf.msb
     clsnssk.msb --> ORACLE_HOME/has/mesg/clsnssk.msb
     clsnsth.msb --> ORACLE_HOME/has/mesg/clsnsth.msb
     clsnstr.msb --> ORACLE_HOME/has/mesg/clsnstr.msb
     clsnsus.msb --> ORACLE_HOME/has/mesg/clsnsus.msb
     clsnsus.msg --> ORACLE_HOME/has/mesg/clsnsus.msg
     clsnszhs.msb --> ORACLE_HOME/has/mesg/clsnszhs.msb
     clsnszht.msb --> ORACLE_HOME/has/mesg/clsnszht.msb
     clstar.msb --> ORACLE_HOME/has/mesg/clstar.msb
     clstcs.msb --> ORACLE_HOME/has/mesg/clstcs.msb
     clstd.msb --> ORACLE_HOME/has/mesg/clstd.msb
     clstdk.msb --> ORACLE_HOME/has/mesg/clstdk.msb
     clste.msb --> ORACLE_HOME/has/mesg/clste.msb
     clstel.msb --> ORACLE_HOME/has/mesg/clstel.msb
     clstf.msb --> ORACLE_HOME/has/mesg/clstf.msb
     clsthu.msb --> ORACLE_HOME/has/mesg/clsthu.msb
     clsti.msb --> ORACLE_HOME/has/mesg/clsti.msb
     clstiw.msb --> ORACLE_HOME/has/mesg/clstiw.msb
     clstja.msb --> ORACLE_HOME/has/mesg/clstja.msb
     clstko.msb --> ORACLE_HOME/has/mesg/clstko.msb
     clstn.msb --> ORACLE_HOME/has/mesg/clstn.msb
     clstnl.msb --> ORACLE_HOME/has/mesg/clstnl.msb
     clstpl.msb --> ORACLE_HOME/has/mesg/clstpl.msb
     clstpt.msb --> ORACLE_HOME/has/mesg/clstpt.msb
     clstptb.msb --> ORACLE_HOME/has/mesg/clstptb.msb
     clstro.msb --> ORACLE_HOME/has/mesg/clstro.msb
     clstru.msb --> ORACLE_HOME/has/mesg/clstru.msb
     clsts.msb --> ORACLE_HOME/has/mesg/clsts.msb
     clstsf.msb --> ORACLE_HOME/has/mesg/clstsf.msb
     clstsk.msb --> ORACLE_HOME/has/mesg/clstsk.msb
     clstth.msb --> ORACLE_HOME/has/mesg/clstth.msb
     clsttr.msb --> ORACLE_HOME/has/mesg/clsttr.msb
     clstus.msb --> ORACLE_HOME/has/mesg/clstus.msb
     clstus.msg --> ORACLE_HOME/has/mesg/clstus.msg
     clstzhs.msb --> ORACLE_HOME/has/mesg/clstzhs.msb
     clstzht.msb --> ORACLE_HOME/has/mesg/clstzht.msb
     clsuar.msb --> ORACLE_HOME/has/mesg/clsuar.msb
     clsuca.msb --> ORACLE_HOME/has/mesg/clsuca.msb
     clsucs.msb --> ORACLE_HOME/has/mesg/clsucs.msb
     clsud.msb --> ORACLE_HOME/has/mesg/clsud.msb
     clsudk.msb --> ORACLE_HOME/has/mesg/clsudk.msb
     clsue.msb --> ORACLE_HOME/has/mesg/clsue.msb
     clsuel.msb --> ORACLE_HOME/has/mesg/clsuel.msb
     clsuf.msb --> ORACLE_HOME/has/mesg/clsuf.msb
     clsuhu.msb --> ORACLE_HOME/has/mesg/clsuhu.msb
     clsui.msb --> ORACLE_HOME/has/mesg/clsui.msb
     clsuiw.msb --> ORACLE_HOME/has/mesg/clsuiw.msb
     clsuja.msb --> ORACLE_HOME/has/mesg/clsuja.msb
     clsuko.msb --> ORACLE_HOME/has/mesg/clsuko.msb
     clsun.msb --> ORACLE_HOME/has/mesg/clsun.msb
     clsunl.msb --> ORACLE_HOME/has/mesg/clsunl.msb
     clsupl.msb --> ORACLE_HOME/has/mesg/clsupl.msb
     clsupt.msb --> ORACLE_HOME/has/mesg/clsupt.msb
     clsuptb.msb --> ORACLE_HOME/has/mesg/clsuptb.msb
     clsuro.msb --> ORACLE_HOME/has/mesg/clsuro.msb
     clsuru.msb --> ORACLE_HOME/has/mesg/clsuru.msb
     clsusf.msb --> ORACLE_HOME/has/mesg/clsusf.msb
     clsusk.msb --> ORACLE_HOME/has/mesg/clsusk.msb
     clsuth.msb --> ORACLE_HOME/has/mesg/clsuth.msb
     clsutr.msb --> ORACLE_HOME/has/mesg/clsutr.msb
     clsuus.msb --> ORACLE_HOME/has/mesg/clsuus.msb
     clsuus.msg --> ORACLE_HOME/has/mesg/clsuus.msg
     clsuzhs.msb --> ORACLE_HOME/has/mesg/clsuzhs.msb
     clsuzht.msb --> ORACLE_HOME/has/mesg/clsuzht.msb
     clswar.msb --> ORACLE_HOME/has/mesg/clswar.msb
     clswcs.msb --> ORACLE_HOME/has/mesg/clswcs.msb
     clswd.msb --> ORACLE_HOME/has/mesg/clswd.msb
     clswdk.msb --> ORACLE_HOME/has/mesg/clswdk.msb
     clswe.msb --> ORACLE_HOME/has/mesg/clswe.msb
     clswel.msb --> ORACLE_HOME/has/mesg/clswel.msb
     clswf.msb --> ORACLE_HOME/has/mesg/clswf.msb
     clswhu.msb --> ORACLE_HOME/has/mesg/clswhu.msb
     clswi.msb --> ORACLE_HOME/has/mesg/clswi.msb
     clswiw.msb --> ORACLE_HOME/has/mesg/clswiw.msb
     clswja.msb --> ORACLE_HOME/has/mesg/clswja.msb
     clswko.msb --> ORACLE_HOME/has/mesg/clswko.msb
     clswn.msb --> ORACLE_HOME/has/mesg/clswn.msb
     clswnl.msb --> ORACLE_HOME/has/mesg/clswnl.msb
     clswpl.msb --> ORACLE_HOME/has/mesg/clswpl.msb
     clswpt.msb --> ORACLE_HOME/has/mesg/clswpt.msb
     clswptb.msb --> ORACLE_HOME/has/mesg/clswptb.msb
     clswro.msb --> ORACLE_HOME/has/mesg/clswro.msb
     clswru.msb --> ORACLE_HOME/has/mesg/clswru.msb
     clsws.msb --> ORACLE_HOME/has/mesg/clsws.msb
     clswsf.msb --> ORACLE_HOME/has/mesg/clswsf.msb
     clswsk.msb --> ORACLE_HOME/has/mesg/clswsk.msb
     clswth.msb --> ORACLE_HOME/has/mesg/clswth.msb
     clswtr.msb --> ORACLE_HOME/has/mesg/clswtr.msb
     clswus.msb --> ORACLE_HOME/has/mesg/clswus.msb
     clswus.msg --> ORACLE_HOME/has/mesg/clswus.msg
     clswzhs.msb --> ORACLE_HOME/has/mesg/clswzhs.msb
     clswzht.msb --> ORACLE_HOME/has/mesg/clswzht.msb
     gipcar.msb --> ORACLE_HOME/has/mesg/gipcar.msb
     gipcca.msb --> ORACLE_HOME/has/mesg/gipcca.msb
     gipccs.msb --> ORACLE_HOME/has/mesg/gipccs.msb
     gipcd.msb --> ORACLE_HOME/has/mesg/gipcd.msb
     gipcdk.msb --> ORACLE_HOME/has/mesg/gipcdk.msb
     gipce.msb --> ORACLE_HOME/has/mesg/gipce.msb
     gipcel.msb --> ORACLE_HOME/has/mesg/gipcel.msb
     gipcf.msb --> ORACLE_HOME/has/mesg/gipcf.msb
     gipchu.msb --> ORACLE_HOME/has/mesg/gipchu.msb
     gipci.msb --> ORACLE_HOME/has/mesg/gipci.msb
     gipciw.msb --> ORACLE_HOME/has/mesg/gipciw.msb
     gipcja.msb --> ORACLE_HOME/has/mesg/gipcja.msb
     gipcko.msb --> ORACLE_HOME/has/mesg/gipcko.msb
     gipcn.msb --> ORACLE_HOME/has/mesg/gipcn.msb
     gipcnl.msb --> ORACLE_HOME/has/mesg/gipcnl.msb
     gipcpl.msb --> ORACLE_HOME/has/mesg/gipcpl.msb
     gipcpt.msb --> ORACLE_HOME/has/mesg/gipcpt.msb
     gipcptb.msb --> ORACLE_HOME/has/mesg/gipcptb.msb
     gipcro.msb --> ORACLE_HOME/has/mesg/gipcro.msb
     gipcru.msb --> ORACLE_HOME/has/mesg/gipcru.msb
     gipcsf.msb --> ORACLE_HOME/has/mesg/gipcsf.msb
     gipcsk.msb --> ORACLE_HOME/has/mesg/gipcsk.msb
     gipcth.msb --> ORACLE_HOME/has/mesg/gipcth.msb
     gipctr.msb --> ORACLE_HOME/has/mesg/gipctr.msb
     gipcus.msb --> ORACLE_HOME/has/mesg/gipcus.msb
     gipcus.msg --> ORACLE_HOME/has/mesg/gipcus.msg
     gipczhs.msb --> ORACLE_HOME/has/mesg/gipczhs.msb
     gipczht.msb --> ORACLE_HOME/has/mesg/gipczht.msb
     odigus.msb --> ORACLE_HOME/has/mesg/odigus.msb
     odigus.msg --> ORACLE_HOME/has/mesg/odigus.msg
     rdear.msb --> ORACLE_HOME/has/mesg/rdear.msb
     rdeca.msb --> ORACLE_HOME/has/mesg/rdeca.msb
     rdecs.msb --> ORACLE_HOME/has/mesg/rdecs.msb
     rded.msb --> ORACLE_HOME/has/mesg/rded.msb
     rdedk.msb --> ORACLE_HOME/has/mesg/rdedk.msb
     rdee.msb --> ORACLE_HOME/has/mesg/rdee.msb
     rdeel.msb --> ORACLE_HOME/has/mesg/rdeel.msb
     rdef.msb --> ORACLE_HOME/has/mesg/rdef.msb
     rdehu.msb --> ORACLE_HOME/has/mesg/rdehu.msb
     rdei.msb --> ORACLE_HOME/has/mesg/rdei.msb
     rdeiw.msb --> ORACLE_HOME/has/mesg/rdeiw.msb
     rdeja.msb --> ORACLE_HOME/has/mesg/rdeja.msb
     rdeko.msb --> ORACLE_HOME/has/mesg/rdeko.msb
     rden.msb --> ORACLE_HOME/has/mesg/rden.msb
     rdenl.msb --> ORACLE_HOME/has/mesg/rdenl.msb
     rdepl.msb --> ORACLE_HOME/has/mesg/rdepl.msb
     rdept.msb --> ORACLE_HOME/has/mesg/rdept.msb
     rdeptb.msb --> ORACLE_HOME/has/mesg/rdeptb.msb
     rdero.msb --> ORACLE_HOME/has/mesg/rdero.msb
     rderu.msb --> ORACLE_HOME/has/mesg/rderu.msb
     rdes.msb --> ORACLE_HOME/has/mesg/rdes.msb
     rdesf.msb --> ORACLE_HOME/has/mesg/rdesf.msb
     rdesk.msb --> ORACLE_HOME/has/mesg/rdesk.msb
     rdeth.msb --> ORACLE_HOME/has/mesg/rdeth.msb
     rdetr.msb --> ORACLE_HOME/has/mesg/rdetr.msb
     rdeus.msb --> ORACLE_HOME/has/mesg/rdeus.msb
     rdeus.msg --> ORACLE_HOME/has/mesg/rdeus.msg
     rdezhs.msb --> ORACLE_HOME/has/mesg/rdezhs.msb
     rdezht.msb --> ORACLE_HOME/has/mesg/rdezht.msb
     clsce.jar --> ORACLE_HOME/jlib/clsce.jar
     consoleapps.jar --> ORACLE_HOME/jlib/consoleapps.jar
     gns.jar --> ORACLE_HOME/jlib/gns.jar
     rd.jar --> ORACLE_HOME/jlib/rd.jar
     rdtool.jar --> ORACLE_HOME/jlib/rdtool.jar
     srvm.jar --> ORACLE_HOME/jlib/srvm.jar
     srvmasm.jar --> ORACLE_HOME/jlib/srvmasm.jar
     srvmhas.jar --> ORACLE_HOME/jlib/srvmhas.jar
     supercluster-common.jar --> ORACLE_HOME/jlib/supercluster-common.jar
     supercluster.jar --> ORACLE_HOME/jlib/supercluster.jar
     liba**12.so --> ORACLE_HOME/lib/liba**12.so
     libclsce12.so --> ORACLE_HOME/lib/libclsce12.so
     libclsra12.so --> ORACLE_HOME/lib/libclsra12.so
     libdbcfg12.so --> ORACLE_HOME/lib/libdbcfg12.so
     libeons.so --> ORACLE_HOME/lib/libeons.so
     libgns12.so --> ORACLE_HOME/lib/libgns12.so
     libgnsjni12.so --> ORACLE_HOME/lib/libgnsjni12.so
     libhasgen12.so --> ORACLE_HOME/lib/libhasgen12.so
     libocr12.so --> ORACLE_HOME/lib/libocr12.so
     libocrb12.so --> ORACLE_HOME/lib/libocrb12.so
     libocrutl12.so --> ORACLE_HOME/lib/libocrutl12.so
     liboevm.a --> ORACLE_HOME/lib/liboevm.a
     librdjni12.so --> ORACLE_HOME/lib/librdjni12.so
     libsrvmcred12.so --> ORACLE_HOME/lib/libsrvmcred12.so
     libsrvmhas12.so --> ORACLE_HOME/lib/libsrvmhas12.so
     libsrvmocr12.so --> ORACLE_HOME/lib/libsrvmocr12.so
     libuini12.so --> ORACLE_HOME/lib/libuini12.so
     libsrvm12.so --> ORACLE_HOME/oui/lib/libsrvm12.so
     s0clsrdmai.o --> ORACLE_HOME/racg/lib/s0clsrdmai.o
     s0clsreut.o --> ORACLE_HOME/racg/lib/s0clsreut.o
     s0clsrmain.o --> ORACLE_HOME/racg/lib/s0clsrmain.o
     s0clsrmdb.o --> ORACLE_HOME/racg/lib/s0clsrmdb.o
     clsrar.msb --> ORACLE_HOME/racg/mesg/clsrar.msb
     clsrcs.msb --> ORACLE_HOME/racg/mesg/clsrcs.msb
     clsrd.msb --> ORACLE_HOME/racg/mesg/clsrd.msb
     clsrdk.msb --> ORACLE_HOME/racg/mesg/clsrdk.msb
     clsre.msb --> ORACLE_HOME/racg/mesg/clsre.msb
     clsrel.msb --> ORACLE_HOME/racg/mesg/clsrel.msb
     clsrf.msb --> ORACLE_HOME/racg/mesg/clsrf.msb
     clsrhu.msb --> ORACLE_HOME/racg/mesg/clsrhu.msb
     clsri.msb --> ORACLE_HOME/racg/mesg/clsri.msb
     clsriw.msb --> ORACLE_HOME/racg/mesg/clsriw.msb
     clsrja.msb --> ORACLE_HOME/racg/mesg/clsrja.msb
     clsrko.msb --> ORACLE_HOME/racg/mesg/clsrko.msb
     clsrn.msb --> ORACLE_HOME/racg/mesg/clsrn.msb
     clsrnl.msb --> ORACLE_HOME/racg/mesg/clsrnl.msb
     clsrpl.msb --> ORACLE_HOME/racg/mesg/clsrpl.msb
     clsrpt.msb --> ORACLE_HOME/racg/mesg/clsrpt.msb
     clsrptb.msb --> ORACLE_HOME/racg/mesg/clsrptb.msb
     clsrro.msb --> ORACLE_HOME/racg/mesg/clsrro.msb
     clsrru.msb --> ORACLE_HOME/racg/mesg/clsrru.msb
     clsrs.msb --> ORACLE_HOME/racg/mesg/clsrs.msb
     clsrsf.msb --> ORACLE_HOME/racg/mesg/clsrsf.msb
     clsrsk.msb --> ORACLE_HOME/racg/mesg/clsrsk.msb
     clsrth.msb --> ORACLE_HOME/racg/mesg/clsrth.msb
     clsrtr.msb --> ORACLE_HOME/racg/mesg/clsrtr.msb
     clsrus.msb --> ORACLE_HOME/racg/mesg/clsrus.msb
     clsrus.msg --> ORACLE_HOME/racg/mesg/clsrus.msg
     clsrzhs.msb --> ORACLE_HOME/racg/mesg/clsrzhs.msb
     clsrzht.msb --> ORACLE_HOME/racg/mesg/clsrzht.msb
     ocrlog.ini --> ORACLE_HOME/srvm/admin/ocrlog.ini
     antlr-3.3-complete.jar --> ORACLE_HOME/srvm/jlib/antlr-3.3-complete.jar
     srvctl.jar --> ORACLE_HOME/srvm/jlib/srvctl.jar
     env_srvm.mk --> ORACLE_HOME/srvm/lib/env_srvm.mk
     ins_srvm.mk --> ORACLE_HOME/srvm/lib/ins_srvm.mk
     prgcrshm.o --> ORACLE_HOME/srvm/lib/prgcrshm.o
     sprgcrshm.o --> ORACLE_HOME/srvm/lib/sprgcrshm.o
     prcaus.msg --> ORACLE_HOME/srvm/mesg/prcaus.msg
     prccus.msg --> ORACLE_HOME/srvm/mesg/prccus.msg
     prcdus.msg --> ORACLE_HOME/srvm/mesg/prcdus.msg
     prceus.msg --> ORACLE_HOME/srvm/mesg/prceus.msg
     prcfus.msg --> ORACLE_HOME/srvm/mesg/prcfus.msg
     prchus.msg --> ORACLE_HOME/srvm/mesg/prchus.msg
     prcius.msg --> ORACLE_HOME/srvm/mesg/prcius.msg
     prclus.msg --> ORACLE_HOME/srvm/mesg/prclus.msg
     prcnus.msg --> ORACLE_HOME/srvm/mesg/prcnus.msg
     prcpus.msg --> ORACLE_HOME/srvm/mesg/prcpus.msg
     prcqus.msg --> ORACLE_HOME/srvm/mesg/prcqus.msg
     prcrus.msg --> ORACLE_HOME/srvm/mesg/prcrus.msg
     prcsus.msg --> ORACLE_HOME/srvm/mesg/prcsus.msg
     prctus.msg --> ORACLE_HOME/srvm/mesg/prctus.msg
     prcwus.msg --> ORACLE_HOME/srvm/mesg/prcwus.msg
     prczus.msg --> ORACLE_HOME/srvm/mesg/prczus.msg
     prghus.msg --> ORACLE_HOME/srvm/mesg/prghus.msg
     prgous.msg --> ORACLE_HOME/srvm/mesg/prgous.msg
     prgrus.msg --> ORACLE_HOME/srvm/mesg/prgrus.msg
     prgsus.msg --> ORACLE_HOME/srvm/mesg/prgsus.msg
     prifd.msb --> ORACLE_HOME/srvm/mesg/prifd.msb
     prife.msb --> ORACLE_HOME/srvm/mesg/prife.msb
     priff.msb --> ORACLE_HOME/srvm/mesg/priff.msb
     prifi.msb --> ORACLE_HOME/srvm/mesg/prifi.msb
     prifja.msb --> ORACLE_HOME/srvm/mesg/prifja.msb
     prifko.msb --> ORACLE_HOME/srvm/mesg/prifko.msb
     prifptb.msb --> ORACLE_HOME/srvm/mesg/prifptb.msb
     prifus.msb --> ORACLE_HOME/srvm/mesg/prifus.msb
     prifus.msg --> ORACLE_HOME/srvm/mesg/prifus.msg
     prkaus.msg --> ORACLE_HOME/srvm/mesg/prkaus.msg
     prkcus.msg --> ORACLE_HOME/srvm/mesg/prkcus.msg
     prkdus.msg --> ORACLE_HOME/srvm/mesg/prkdus.msg
     prkeus.msg --> ORACLE_HOME/srvm/mesg/prkeus.msg
     prkfus.msg --> ORACLE_HOME/srvm/mesg/prkfus.msg
     prkhus.msg --> ORACLE_HOME/srvm/mesg/prkhus.msg
     prknus.msg --> ORACLE_HOME/srvm/mesg/prknus.msg
     prkous.msg --> ORACLE_HOME/srvm/mesg/prkous.msg
     prkpus.msg --> ORACLE_HOME/srvm/mesg/prkpus.msg
     prkrus.msg --> ORACLE_HOME/srvm/mesg/prkrus.msg
     prksus.msg --> ORACLE_HOME/srvm/mesg/prksus.msg
     prkuus.msg --> ORACLE_HOME/srvm/mesg/prkuus.msg
     prkzus.msg --> ORACLE_HOME/srvm/mesg/prkzus.msg
     procd.msb --> ORACLE_HOME/srvm/mesg/procd.msb
     proce.msb --> ORACLE_HOME/srvm/mesg/proce.msb
     procf.msb --> ORACLE_HOME/srvm/mesg/procf.msb
     proci.msb --> ORACLE_HOME/srvm/mesg/proci.msb
     procja.msb --> ORACLE_HOME/srvm/mesg/procja.msb
     procko.msb --> ORACLE_HOME/srvm/mesg/procko.msb
     procld.msb --> ORACLE_HOME/srvm/mesg/procld.msb
     procle.msb --> ORACLE_HOME/srvm/mesg/procle.msb
     proclf.msb --> ORACLE_HOME/srvm/mesg/proclf.msb
     procli.msb --> ORACLE_HOME/srvm/mesg/procli.msb
     proclja.msb --> ORACLE_HOME/srvm/mesg/proclja.msb
     proclko.msb --> ORACLE_HOME/srvm/mesg/proclko.msb
     proclptb.msb --> ORACLE_HOME/srvm/mesg/proclptb.msb
     proclus.msb --> ORACLE_HOME/srvm/mesg/proclus.msb
     proclus.msg --> ORACLE_HOME/srvm/mesg/proclus.msg
     proclzhs.msb --> ORACLE_HOME/srvm/mesg/proclzhs.msb
     proclzht.msb --> ORACLE_HOME/srvm/mesg/proclzht.msb
     procptb.msb --> ORACLE_HOME/srvm/mesg/procptb.msb
     procus.msb --> ORACLE_HOME/srvm/mesg/procus.msb
     procus.msg --> ORACLE_HOME/srvm/mesg/procus.msg
     proczhs.msb --> ORACLE_HOME/srvm/mesg/proczhs.msb
     proczht.msb --> ORACLE_HOME/srvm/mesg/proczht.msb
     prveus.msg --> ORACLE_HOME/srvm/mesg/prveus.msg
     prvfus.msg --> ORACLE_HOME/srvm/mesg/prvfus.msg
     prvgus.msg --> ORACLE_HOME/srvm/mesg/prvgus.msg
     prvpus.msg --> ORACLE_HOME/srvm/mesg/prvpus.msg
     sclcus.msg --> ORACLE_HOME/srvm/mesg/sclcus.msg
     sclsus.msg --> ORACLE_HOME/srvm/mesg/sclsus.msg
     ins_srvm.mk --> ORACLE_HOME/srvm/lib/install_srvm
     ins_has.mk --> ORACLE_HOME/racg/lib/install
   Patch Location in Inventory:
     /DBSoft/Product/12.1.0.2/db_1/inventory/oneoffs/19392604
   Patch Location in Storage area:
     /DBSoft/Product/12.1.0.2/db_1/.patch_storage/19392604_Oct_15_2014_00_35_12

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

OPatch succeeded.

5.8 启动数据库检查

SQL> startup
ORACLE instance started.

Total System Global Area 1660944384 bytes
Fixed Size 2925072 bytes
Variable Size 989859312 bytes
Database Buffers 654311424 bytes
Redo Buffers 13848576 bytes
Database mounted.
Database opened.
SQL> show pdbs;

    CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED READ ONLY NO
         3 PDB01 MOUNTED
         4 WOO_ORA11G MOUNTED

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED READ ONLY NO
         3 PDB01 READ WRITE NO
         4 WOO_ORA11G READ WRITE NO
SQL> select name, open_mode from v$pdbs;

NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
PDB01 READ WRITE
WOO_ORA11G READ WRITE
时间: 2024-10-24 19:30:39

探索Oracle之数据库升级十 12c(12.1.0.2)CPU 19774304的相关文章

探索Oracle之数据库升级八 12c Downgrade 11gR2

探索Oracle之数据库升级八12c Downgrade 11gR2 前言:        我们前面已经完成了11gR2 upgrade to 12c 的升级,整个过程还是比较顺利的,虽然和以前版本升级有些不太一样,但是整个难度不是太大,但是由于太多的特性不同,大大的加长了升级的时间.        但是对于Oracle 12c降回到之前版本,会有些限制,只能降级到升级前所用的版本和补丁级别.        如果我们是直接从10.2.0.5.11.1.0.7或版本11.2.0.2及更高版进行升级

探索Oracle之数据库升级七 11gR2 to 12c 升级完成后插入PDB

探索Oracle之数据库升级七11gR2 to 12c 升级完成后插入PDB 前言:        从Oracle 12c开始,引入了容器数据库的概念,可以实现数据库插拔操作,如下图:现在我们就来看看如何将11.2.0.4的数据库插入到12c的CDP里面去,让其成为一个PDB 数据库. 一.查看数据库信息: SQL> col BANNER format a80 SQL> set line 300 SQL> select * from v$version; BANNER CON_ID --

探索Oracle之数据库升级九 12.1.0.1 Update 12.1.0.2

探索Oracle之数据库升级九 12.1.0.1 Update 12.1.0.2 一.检查当前数据库版本及系统信息 [oracle@db01 ~]$ lsb_release -a LSB Version: :core-4.0-amd64:core-4.0-ia32:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-ia32:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-ia32:printin

探索Oracle之数据库升级六 11.2.0.4.3 Upgrade12c(12.1.0.1)

探索Oracle之数据库升级六11.2.0.4.3 Upgrade12c(12.1.0.1) 一.前言:       Oracle 12c发布距今已经一年有余了,其最大亮点是一个可以插拔的数据库(PDB),这是在之前版本没有的:但是如果我们要将以前版本的数据库升级到12c来,那么也应顺其自然的将其变成一个pdb,那么我们的工作不仅包含了数据库软件的升级,同时也包含如何将一个NO-CDB的数据库plug to CDB none. 二.升级要求:   三.升级前准备:          3.1.查看

探索Oracle之数据库升级二 11.2.0.3升级到11.2.0.4完整步骤

探索Oracle之数据库升级二  11.2.0.3升级到11.2.0.4完整步骤   说明:         这篇文章主要是记录下单实例环境下Oracle 11.2.0.1升级到11.2.0.3的过程,当然RAC的升级是会有所不同.但是他们每个版本之间升级步骤都是差不多的,先升级Database Software,再升级Oracle Instance.  Oracle 11.2.0.4的Patchset No:19852360下载需要有Oracle Support才可以.  Patchset包含

探索Oracle之数据库升级一 升级补丁修复概述

探索Oracle之数据库升级一  升级补丁修复概述 一. 升级路线图         无论你是谁,要想做数据库升级,我想一定离不开如下这张升级线路图:企业中数据库的升级是一个浩大的工程,但是却又必不可少,小在打一个PSU解决一个简单的问题或实现某个功能,大到打安装Patch对数据库版本升级,都是作为一名合格的DBA必备的技能.再后面的几篇博客当中将详细讲述如何将数据库从11.2.0.3.0升级到11.2.0.4并且打上最新的OPATCH之后再升级到Oracle 12c.   二.  升级类型:

探索Oracle之数据库升级四 11.2.0.4.0 PSU 11.2.0.4.3

探索Oracle之数据库升级四11.2.0.4.0 PSU 11.2.0.4.3   一.  检查当前数据库PSU号: [oracle@db01 ~]$ cd/DBSoft/Product/11.2.4/db_1/OPatch/ [oracle@db01 OPatch]$ ls crs docs emdpatch.pl jlib ocm opatch opatch.bat opatchdiag opatchdiag.bat opatch.ini opatch.pl opatchprereqs o

探索Oracle之数据库升级三 回退升级操作(11.2.0.4Downgrade 11.2.0.3)

探索Oracle之数据库升级三 回退升级操作(11.2.0.4Downgrade 11.2.0.3)   我们可以选择2种回退办法: 1.   通过restore point还原到11.2.0.1的数据库 2.   执行catdwgrd.sql降级数据字典   第一种方法: [oracle@db01 dbs]$ sqlplus /as sysdba SQL*Plus: Release 11.2.0.4.0Production on Sat Oct 4 04:53:22 2014 Copyrigh

解决Jdbc连接oracle 12c(12.1.0.1)时快时慢的问题

某个朋友公司的客户,友情帮忙分析的.客户使用的是oracle 12c(12.1.0.1),应用通过jdbc访问发现时快时慢.但是通过sqlplus访问发现一切正常. 开始以为是防火墙问题,检查发现防火墙什么的都是禁用掉了,甚至我还修改了selinux=disable,发现问题依旧. 由于之前处理过几个类似的case,都是jdbc版本的问题,因此开始我让他们换几个jdbc版本测试下,发现问题依旧.类似如下结果: [oracle@12c_single ~]$ /oracle/product/12.1