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

简介: 探索Oracle之数据库升级十 12c(12.1.0.2)CPU 19774304 一、   补丁描述 参考metalink doc: (Doc ID 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


目录
相关文章
|
14天前
|
存储 Oracle 关系型数据库
Oracle数据库的应用场景有哪些?
【10月更文挑战第15天】Oracle数据库的应用场景有哪些?
129 64
|
4天前
|
SQL Oracle 关系型数据库
Oracle数据库优化方法
【10月更文挑战第25天】Oracle数据库优化方法
17 7
|
4天前
|
Oracle 关系型数据库 数据库
oracle数据库技巧
【10月更文挑战第25天】oracle数据库技巧
11 6
|
4天前
|
存储 Oracle 关系型数据库
Oracle数据库优化策略
【10月更文挑战第25天】Oracle数据库优化策略
11 5
|
11天前
|
存储 Oracle 关系型数据库
数据库数据恢复—Oracle ASM磁盘组故障数据恢复案例
Oracle数据库数据恢复环境&故障: Oracle ASM磁盘组由4块磁盘组成。Oracle ASM磁盘组掉线 ,ASM实例不能mount。 Oracle数据库故障分析&恢复方案: 数据库数据恢复工程师对组成ASM磁盘组的磁盘进行分析。对ASM元数据进行分析发现ASM存储元数据损坏,导致磁盘组无法挂载。
|
13天前
|
监控 Oracle 关系型数据库
Oracle数据库性能优化
【10月更文挑战第16天】Oracle数据库性能优化是
14 1
|
2月前
|
Oracle 关系型数据库 数据库
数据库数据恢复—Oracle数据库文件出现坏块的数据恢复案例
打开oracle数据库报错“system01.dbf需要更多的恢复来保持一致性,数据库无法打开”。 数据库没有备份,无法通过备份去恢复数据库。用户方联系北亚企安数据恢复中心并提供Oracle_Home目录中的所有文件,急需恢复zxfg用户下的数据。 出现“system01.dbf需要更多的恢复来保持一致性”这个报错的原因可能是控制文件损坏、数据文件损坏,数据文件与控制文件的SCN不一致等。数据库恢复工程师对数据库文件进一步检测、分析后,发现sysaux01.dbf文件损坏,有坏块。 修复并启动数据库后仍然有许多查询报错,export和data pump工具使用报错。从数据库层面无法修复数据库。
数据库数据恢复—Oracle数据库文件出现坏块的数据恢复案例
|
26天前
|
SQL 存储 Oracle
Oracle数据库SQL语句详解与应用指南
在数字化时代,数据库已成为各类企业和组织不可或缺的核心组件。Oracle数据库作为业界领先的数据库管理系统之一,广泛应用于各种业务场景。掌握Oracle数据库的SQL语句是数据库管理员、开发人员及运维人员的基本技能。本文将详细介绍Oracle数据库SQL语句的基本概念、语法、应用及最佳实践。一、Or
40 3
|
2月前
|
Oracle 关系型数据库 数据库
Oracle数据恢复—异常断电导致Oracle数据库数据丢失的数据恢复案例
Oracle数据库故障: 机房异常断电后,Oracle数据库启库报错:“system01.dbf需要更多的恢复来保持一致性,数据库无法打开”。数据库没有备份,归档日志不连续。用户方提供了Oracle数据库的在线文件,需要恢复zxfg用户的数据。 Oracle数据库恢复方案: 检测数据库故障;尝试挂起并修复数据库;解析数据文件。
|
13天前
|
监控 关系型数据库 MySQL
如何升级MySQL数据库?
【10月更文挑战第16天】如何升级MySQL数据库?