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

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