ORA 12592的報錯處理及補丁更新

In some situations, the Client (possibly an Application or ETL job or Imp/EXp/SqlLoader) will fail intermittently with an ORA-12592 while the Database reports no errors or issues.

This can occur after an upgrade of the Database Server to 11.2.0.4. (reference Bug 18841764)

If you turn on tracing, you might not be able to reproduce the error (indicating a timing issue with communication).

SQL> shutdown immediate  

Database closed.  

Database dismounted.  

ORACLE instance shut down. 

[oracle@localhost OPatch]$ lsnrctl stop  

LSNRCTL for Linux: Version 11.2.0.4.0 -Production on 22-SEP-2015 20:51:15  

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

Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1528)))  

The command completed successfully  

1、先進行補丁包的解壓

unzip p18841764_112040_Linux-x86-64.zip 

2、進行補丁檢查

[oracle@localhost 18841764]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/18841764

Oracle 中間補丁程式安裝程式版本 11.2.0.3.4

版權所有 (c) 2012, Oracle Corporation。保留所有權利。

PREREQ session

Oracle Home       : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.4

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-10-16_11-29-02上午_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

3、進行補丁更新

[oracle@joe-b2bimg-01 18841764]$ cd /tmp/18841764/

[oracle@joe-b2bimg-01 18841764]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply 

Oracle 中間補丁程式安裝程式版本 11.2.0.3.4

版權所有 (c) 2012, Oracle Corporation。保留所有權利。

Oracle Home       : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.4

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/18841764_Oct_16_2017_11_31_00/apply2017-10-16_11-31-00上午_1.log

Applying interim patch '18841764' to OH '/u01/app/oracle/product/11.2.0/db_1'

Verifying environment and performing prerequisite checks... 

[oracle@localhost ]$ sqlplus / as sysdba  

SQL> startup  

SQL>@?/rdbms/admin/catbundle.sql psu apply  

SQL> select action_time,action,namespace,version,id from dba_registry_history;  

ACTION_TIME                       ACTION   NAMESPACE     VERSION    ID

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

13-OCT-17 05.51.54.155186 PM       APPLY    SERVER       11.2.0.4    0

SQL> select action,comments from registry$history;  

ACTION   MMENTS   APPLY

Patchset 11.2.0.2.0

[oracle@joe-b2bimg-01 OPatch]$ ./opatch lsinventory

Oracle 中間補丁程式安裝程式版本 11.2.0.3.4

版權所有 (c) 2012, Oracle Corporation。保留所有權利。

Oracle Home       : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.4

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-10-16_11-34-36上午_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-10-16_11-34-36上午.txt

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

已安裝的頂級產品 (1):

Oracle Database 11g                                                  11.2.0.4.0

此 Oracle 主目錄中已安裝 1 個產品。

中間補丁程式 (1) :

Patch  18841764     : applied on Fri Oct 13 17:50:38 CST 2017

Unique Patch ID:  17779414

   Created on 26 Jun 2014, 03:07:07 hrs PST8PDT

   Bugs fixed:

     18841764

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