Oracle数据库11G新特性-online补丁确认

最新推荐文章于 2024-01-22 10:43:14 发布
最新推荐文章于 2024-01-22 10:43:14 发布
阅读量505 收藏
点赞数
分类专栏： ORACLE数据库11G新特性分析
版权声明：本文为博主原创文章，遵循 CC 4.0 BY 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/oradbm/article/details/86479733
版权

[oracle@rac1 solaris11.2.0.4]$ opatch query 26925532 -all
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/oraInventory
   from           : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2019-01-14_16-32-32PM_1.log

--------------------------------------------------------------------------------
 Patch created on 28 Nov 2017, 07:01:35 hrs PST8PDT
 Patch description: "OJVM PATCH SET UPDATE 11.2.0.4.180116"

 Need to shutdown Oracle instances: true
 Patch is roll-backable: true
 Patch is a "Patchset Update": false
 Patch is a rolling patch: false
 Patch has sql related actions: false
 Patch is an online patch: false
 Patch is a portal patch: false
 Patch is an "auto-enabled" patch: false
 Patch is translatable: false

 List of platforms supported:
   23: Sun SPARC Solaris (64-BIT)


 List of bugs to be fixed:
   18933818: ORA-29532; JAVA CALL TERMINATED BY UNCAUGHT JAVA EXCEPTION; JAVA.LANG.ILLEGALMON
   19176885: Fix for Bug 19176885
   17201047: FIX FOR BUG 17201047
   25067795: ORA-29548 CONTINUES TO OCCUR ON A RAC NODE EVEN AFTER OJVM PSU POST-INSTALL
   14774730: FIX FOR BUG 14774730
   19153980: FIX FOR BUG 19153980
   21911849: ORA-29548 EVEN AFTER OJVM PSU POST-INSTALL IS RUN
   23727132: ORACLE JAVAVM COMPONENT 11.2.0.4.160719 DATABASE PSU - GENERIC JDBC PATCH
   18166577: JAVA STORED PROCEDURE FAILS WITH ORA-29532 IN 11.2.0.4
   27000663: Fix for Bug 27000663
   24448240: Fix for Bug 24448240
   17056813: FIX FOR BUG 17056813
   21811517: UPDATE NEEDED TO VERSION FILES FOR OJVM PSU5
   19909862: IMPROVEMENTS NEEDED FOR OJVM PSU
   25494379: Fix for Bug 25494379
   22675136: Fix for Bug 22675136
   24534298: EXIT THE SESSION WHILE ROLLING PATCHING FOR AN OJVM SESSION THAT MISMATCHES
   19895326: Fix for Bug 19895326
   22253904: ORA-07445[JOEVM_INVOKEVIRTUAL()+584] AFTER APPLYING THE COMBO PATCH 21744343
   17804361: SET COLLECTION TYPE AS A BIND VARIABLE IS VERY SLOW AFTER UPGRADE TO 11.2.0.4
   19231857: FIX FOR BUG 19231857
   26023002: FIX FOR BUG 26023002
   17528315: ORA-29532 ON JAVAMAIL API AFTER UPGRADE TO 11.2.0.4
   19058059: FIX FOR BUG 19058059
   19554117: FIX TO ADDRESS JOX.O CONFLICT BETWEEN OJVM AND OTHER BUNDLES [JAVAVM SIDE FIX]
   19007266: FIX FOR BUG 19007266
   17285560: FIX FOR BUG 17285560
   22670385: Fix for Bug 22670385
   18458318: LOW QUALITY FONT IMAGE FILE CREATED USING JAVA CLASS AFTER UPGRADE TO 11.2.0.4
   19187988: QUERIES FROM JDBC DRIVER RESULT IN CURSOR LEAK
   23265914: Fix for Bug 23265914
   19699946: REMOVE CHECK FROM JVMPSU.SQL FOR JAVAVM BEING VALID
   19006757: FIX FOR BUG 19006757
   19374518: JAVAVM RELEASE VERSION NOT CORRECTLY PARSED FROM PSU LABEL NAMES
   19223010: FIX FOR BUG 19223010
   25076732: Fix for Bug 25076732
   22118835: Fix for Bug 22118835
   26637592: FIX FOR BUG 26637592
   19852360: ORACLE JAVAVM COMPONENT 11.2.0.4.1 DATABASE PSU - GENERIC JDBC PATCH (OCT2014)
   20408829: Fix for Bug 20408829
   21047766: Fix for Bug 21047766
   21566944: Fix for Bug 21566944

 This patch is a "singleton" patch.

 This patch belongs to the "db" product family 

 This patch supports the patching model as "one-off"

 This patch supports the language "en"

 List of executables affected:
   ORACLE_HOME/bin/oracle

 List of optional components:
   oracle.javavm.server:  11.2.0.4.0
   oracle.rdbms:  11.2.0.4.0
   oracle.rdbms.dbscripts:  11.2.0.4.0
   oracle.sqlj:  11.2.0.4.0
   oracle.sqlj.companion:  11.2.0.4.0
   oracle.dbjava.jdbc:  11.2.0.4.0
   oracle.dbjava.ic:  11.2.0.4.0
   oracle.javavm.client:  11.2.0.4.0

 List of optional actions:
   Copy jox.o to /u01/app/oracle/product/11.2.0.4/db_1/javavm/admin/jox.o
   Copy classes.bin to /u01/app/oracle/product/11.2.0.4/db_1/javavm/admin/classes.bin
   Copy libjavavm11.a to /u01/app/oracle/product/11.2.0.4/db_1/lib/libjavavm11.a
   Copy jce.jar to /u01/app/oracle/product/11.2.0.4/db_1/javavm/lib/jce.jar
   Copy sunjce_provider.jar to /u01/app/oracle/product/11.2.0.4/db_1/javavm/lib/sunjce_provider.jar
   Copy java.security to /u01/app/oracle/product/11.2.0.4/db_1/javavm/lib/security/java.security
   Copy cacerts to /u01/app/oracle/product/11.2.0.4/db_1/javavm/lib/security/cacerts
   Copy US_export_policy.jar to /u01/app/oracle/product/11.2.0.4/db_1/javavm/lib/security/US_export_policy.jar
   Copy local_policy.jar to /u01/app/oracle/product/11.2.0.4/db_1/javavm/lib/security/local_policy.jar
   Copy initdbj.sql to /u01/app/oracle/product/11.2.0.4/db_1/javavm/install/initdbj.sql
   Copy initsqlj.sql to /u01/app/oracle/product/11.2.0.4/db_1/javavm/install/initsqlj.sql
   Copy jvmrm.sql to /u01/app/oracle/product/11.2.0.4/db_1/javavm/install/jvmrm.sql
   Copy jvmsec5.sql to /u01/app/oracle/product/11.2.0.4/db_1/javavm/install/jvmsec5.sql
   Copy initdbj.sql to /u01/app/oracle/product/11.2.0.4/db_1/rdbms/admin/initdbj.sql
   Copy initsqlj.sql to /u01/app/oracle/product/11.2.0.4/db_1/rdbms/admin/initsqlj.sql
[onewaycopyAction: copyName="jvmpsu.sql", path="javavm/install", fileName="javavm/install/jvmpsu.sql", lineNumer="18", parentPath="%ORACLE_HOME%/javavm/install/jvmpsu.sql", sourcePath="%patch_path%/files/javavm/install/jvmpsu.sql" rawonewaycopyAction=" <onewaycopy name="jvmpsu.sql" path="%ORACLE_HOME%/javavm/install" file_name="javavm/install/jvmpsu.sql" />"]
[onewaycopyAction: copyName="jvmpsui.sql", path="javavm/install", fileName="javavm/install/jvmpsui.sql", lineNumer="19", parentPath="%ORACLE_HOME%/javavm/install/jvmpsui.sql", sourcePath="%patch_path%/files/javavm/install/jvmpsui.sql" rawonewaycopyAction=" <onewaycopy name="jvmpsui.sql" path="%ORACLE_HOME%/javavm/install" file_name="javavm/install/jvmpsui.sql" />"]
[onewaycopyAction: copyName="jvmpsupdi.sql", path="javavm/install", fileName="javavm/install/jvmpsupdi.sql", lineNumer="20", parentPath="%ORACLE_HOME%/javavm/install/jvmpsupdi.sql", sourcePath="%patch_path%/files/javavm/install/jvmpsupdi.sql" rawonewaycopyAction=" <onewaycopy name="jvmpsupdi.sql" path="%ORACLE_HOME%/javavm/install" file_name="javavm/install/jvmpsupdi.sql" />"]
[onewaycopyAction: copyName="jvmpsupdii.sql", path="javavm/install", fileName="javavm/install/jvmpsupdii.sql", lineNumer="21", parentPath="%ORACLE_HOME%/javavm/install/jvmpsupdii.sql", sourcePath="%patch_path%/files/javavm/install/jvmpsupdii.sql" rawonewaycopyAction=" <onewaycopy name="jvmpsupdii.sql" path="%ORACLE_HOME%/javavm/install" file_name="javavm/install/jvmpsupdii.sql" />"]
[onewaycopyAction: copyName="jvmpsupi.sql", path="javavm/install", fileName="javavm/install/jvmpsupi.sql", lineNumer="22", parentPath="%ORACLE_HOME%/javavm/install/jvmpsupi.sql", sourcePath="%patch_path%/files/javavm/install/jvmpsupi.sql" rawonewaycopyAction=" <onewaycopy name="jvmpsupi.sql" path="%ORACLE_HOME%/javavm/install" file_name="javavm/install/jvmpsupi.sql" />"]
[onewaycopyAction: copyName="jvmpsupii.sql", path="javavm/install", fileName="javavm/install/jvmpsupii.sql", lineNumer="23", parentPath="%ORACLE_HOME%/javavm/install/jvmpsupii.sql", sourcePath="%patch_path%/files/javavm/install/jvmpsupii.sql" rawonewaycopyAction=" <onewaycopy name="jvmpsupii.sql" path="%ORACLE_HOME%/javavm/install" file_name="javavm/install/jvmpsupii.sql" />"]
   cd /u01/app/oracle/product/11.2.0.4/db_1/rdbms/lib
     ; make -f ins_rdbms.mk jox_refresh_knlopt ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1
[onewaycopyAction: copyName="postinstall.sql", path="sqlpatch/26925532", fileName="sqlpatch/26925532/postinstall.sql", lineNumer="29", parentPath="%ORACLE_HOME%/sqlpatch/26925532/postinstall.sql", sourcePath="%patch_path%/files/sqlpatch/26925532/postinstall.sql" rawonewaycopyAction=" <onewaycopy name="postinstall.sql" path="%ORACLE_HOME%/sqlpatch/26925532" file_name="sqlpatch/26925532/postinstall.sql" />"]
[onewaycopyAction: copyName="postdeinstall.sql", path="sqlpatch/26925532", fileName="sqlpatch/26925532/postdeinstall.sql", lineNumer="30", parentPath="%ORACLE_HOME%/sqlpatch/26925532/postdeinstall.sql", sourcePath="%patch_path%/files/sqlpatch/26925532/postdeinstall.sql" rawonewaycopyAction=" <onewaycopy name="postdeinstall.sql" path="%ORACLE_HOME%/sqlpatch/26925532" file_name="sqlpatch/26925532/postdeinstall.sql" />"]
   Copy sqljutl.jar to /u01/app/oracle/product/11.2.0.4/db_1/sqlj/lib/sqljutl.jar
   Copy sqljutl2.sql to /u01/app/oracle/product/11.2.0.4/db_1/jpub/sql/sqljutl2.sql
   Copy README.txt to /u01/app/oracle/product/11.2.0.4/db_1/jpub/demo/README.txt
   Update jdbc/lib/ojdbc5_g.jar with /jdbc/lib/ojdbc5_g.jar/oracle/jdbc/OracleDatabaseMetaData.class
   Update jdbc/lib/ojdbc5_g.jar with /jdbc/lib/ojdbc5_g.jar/oracle/jdbc/driver/OracleSql$1.class
   Update jdbc/lib/ojdbc5_g.jar with /jdbc/lib/ojdbc5_g.jar/oracle/jdbc/driver/OracleSql$ParseMode.class
   Update jdbc/lib/ojdbc5_g.jar with /jdbc/lib/ojdbc5_g.jar/oracle/jdbc/driver/OracleSql.class
   Update jdbc/lib/ojdbc5_g.jar with /jdbc/lib/ojdbc5_g.jar/oracle/jdbc/driver/T4CConnection$1.class
   Update jdbc/lib/ojdbc5_g.jar with /jdbc/lib/ojdbc5_g.jar/oracle/jdbc/driver/T4CConnection.class
   Update jdbc/lib/ojdbc5_g.jar with /jdbc/lib/ojdbc5_g.jar/oracle/jdbc/oracore/OracleTypeCOLLECTION.class
   Update jdbc/lib/ojdbc5_g.jar with /jdbc/lib/ojdbc5_g.jar/oracle/net/resolver/AddrResolution.class
   Update jdbc/lib/ojdbc5dms.jar with /jdbc/lib/ojdbc5dms.jar/oracle/jdbc/OracleDatabaseMetaData.class
   Update jdbc/lib/ojdbc5dms.jar with /jdbc/lib/ojdbc5dms.jar/oracle/jdbc/driver/OracleSql$1.class
   Update jdbc/lib/ojdbc5dms.jar with /jdbc/lib/ojdbc5dms.jar/oracle/jdbc/driver/OracleSql$ParseMode.class
   Update jdbc/lib/ojdbc5dms.jar with /jdbc/lib/ojdbc5dms.jar/oracle/jdbc/driver/OracleSql.class
   Update jdbc/lib/ojdbc5dms.jar with /jdbc/lib/ojdbc5dms.jar/oracle/jdbc/driver/T4CConnection$1.class
   Update jdbc/lib/ojdbc5dms.jar with /jdbc/lib/ojdbc5dms.jar/oracle/jdbc/driver/T4CConnection.class
   Update jdbc/lib/ojdbc5dms.jar with /jdbc/lib/ojdbc5dms.jar/oracle/jdbc/oracore/OracleTypeCOLLECTION.class
   Update jdbc/lib/ojdbc5dms.jar with /jdbc/lib/ojdbc5dms.jar/oracle/net/resolver/AddrResolution.class
   Update jdbc/lib/ojdbc5dms_g.jar with /jdbc/lib/ojdbc5dms_g.jar/oracle/jdbc/OracleDatabaseMetaData.class
   Update jdbc/lib/ojdbc5dms_g.jar with /jdbc/lib/ojdbc5dms_g.jar/oracle/jdbc/driver/OracleSql$1.class
   Update jdbc/lib/ojdbc5dms_g.jar with /jdbc/lib/ojdbc5dms_g.jar/oracle/jdbc/driver/OracleSql$ParseMode.class
   Update jdbc/lib/ojdbc5dms_g.jar with /jdbc/lib/ojdbc5dms_g.jar/oracle/jdbc/driver/OracleSql.class
   Update jdbc/lib/ojdbc5dms_g.jar with /jdbc/lib/ojdbc5dms_g.jar/oracle/jdbc/driver/T4CConnection$1.class
   Update jdbc/lib/ojdbc5dms_g.jar with /jdbc/lib/ojdbc5dms_g.jar/oracle/jdbc/driver/T4CConnection.class
   Update jdbc/lib/ojdbc5dms_g.jar with /jdbc/lib/ojdbc5dms_g.jar/oracle/jdbc/oracore/OracleTypeCOLLECTION.class
   Update jdbc/lib/ojdbc5dms_g.jar with /jdbc/lib/ojdbc5dms_g.jar/oracle/net/resolver/AddrResolution.class
   Update jdbc/lib/ojdbc6_g.jar with /jdbc/lib/ojdbc6_g.jar/oracle/jdbc/OracleDatabaseMetaData.class
   Update jdbc/lib/ojdbc6_g.jar with /jdbc/lib/ojdbc6_g.jar/oracle/jdbc/driver/OracleSql$1.class
   Update jdbc/lib/ojdbc6_g.jar with /jdbc/lib/ojdbc6_g.jar/oracle/jdbc/driver/OracleSql$ParseMode.class
   Update jdbc/lib/ojdbc6_g.jar with /jdbc/lib/ojdbc6_g.jar/oracle/jdbc/driver/OracleSql.class
   Update jdbc/lib/ojdbc6_g.jar with /jdbc/lib/ojdbc6_g.jar/oracle/jdbc/driver/T4CConnection$1.class
   Update jdbc/lib/ojdbc6_g.jar with /jdbc/lib/ojdbc6_g.jar/oracle/jdbc/driver/T4CConnection.class
   Update jdbc/lib/ojdbc6_g.jar with /jdbc/lib/ojdbc6_g.jar/oracle/jdbc/oracore/OracleTypeCOLLECTION.class
   Update jdbc/lib/ojdbc6_g.jar with /jdbc/lib/ojdbc6_g.jar/oracle/net/resolver/AddrResolution.class
   Update jdbc/lib/ojdbc6dms.jar with /jdbc/lib/ojdbc6dms.jar/oracle/jdbc/OracleDatabaseMetaData.class
   Update jdbc/lib/ojdbc6dms.jar with /jdbc/lib/ojdbc6dms.jar/oracle/jdbc/driver/OracleSql$1.class
   Update jdbc/lib/ojdbc6dms.jar with /jdbc/lib/ojdbc6dms.jar/oracle/jdbc/driver/OracleSql$ParseMode.class
   Update jdbc/lib/ojdbc6dms.jar with /jdbc/lib/ojdbc6dms.jar/oracle/jdbc/driver/OracleSql.class
   Update jdbc/lib/ojdbc6dms.jar with /jdbc/lib/ojdbc6dms.jar/oracle/jdbc/driver/T4CConnection$1.class
   Update jdbc/lib/ojdbc6dms.jar with /jdbc/lib/ojdbc6dms.jar/oracle/jdbc/driver/T4CConnection.class
   Update jdbc/lib/ojdbc6dms.jar with /jdbc/lib/ojdbc6dms.jar/oracle/jdbc/oracore/OracleTypeCOLLECTION.class
   Update jdbc/lib/ojdbc6dms.jar with /jdbc/lib/ojdbc6dms.jar/oracle/net/resolver/AddrResolution.class
   Update jdbc/lib/ojdbc6dms_g.jar with /jdbc/lib/ojdbc6dms_g.jar/oracle/jdbc/OracleDatabaseMetaData.class
   Update jdbc/lib/ojdbc6dms_g.jar with /jdbc/lib/ojdbc6dms_g.jar/oracle/jdbc/driver/OracleSql$1.class
   Update jdbc/lib/ojdbc6dms_g.jar with /jdbc/lib/ojdbc6dms_g.jar/oracle/jdbc/driver/OracleSql$ParseMode.class
   Update jdbc/lib/ojdbc6dms_g.jar with /jdbc/lib/ojdbc6dms_g.jar/oracle/jdbc/driver/OracleSql.class
   Update jdbc/lib/ojdbc6dms_g.jar with /jdbc/lib/ojdbc6dms_g.jar/oracle/jdbc/driver/T4CConnection$1.class
   Update jdbc/lib/ojdbc6dms_g.jar with /jdbc/lib/ojdbc6dms_g.jar/oracle/jdbc/driver/T4CConnection.class
   Update jdbc/lib/ojdbc6dms_g.jar with /jdbc/lib/ojdbc6dms_g.jar/oracle/jdbc/oracore/OracleTypeCOLLECTION.class
   Update jdbc/lib/ojdbc6dms_g.jar with /jdbc/lib/ojdbc6dms_g.jar/oracle/net/resolver/AddrResolution.class
   Update jdbc/lib/ojdbc5.jar with /jdbc/lib/ojdbc5.jar/oracle/jdbc/OracleDatabaseMetaData.class
   Update jdbc/lib/ojdbc5.jar with /jdbc/lib/ojdbc5.jar/oracle/jdbc/driver/OracleSql$1.class
   Update jdbc/lib/ojdbc5.jar with /jdbc/lib/ojdbc5.jar/oracle/jdbc/driver/OracleSql$ParseMode.class
   Update jdbc/lib/ojdbc5.jar with /jdbc/lib/ojdbc5.jar/oracle/jdbc/driver/OracleSql.class
   Update jdbc/lib/ojdbc5.jar with /jdbc/lib/ojdbc5.jar/oracle/jdbc/driver/T4CConnection$1.class
   Update jdbc/lib/ojdbc5.jar with /jdbc/lib/ojdbc5.jar/oracle/jdbc/driver/T4CConnection.class
   Update jdbc/lib/ojdbc5.jar with /jdbc/lib/ojdbc5.jar/oracle/jdbc/oracore/OracleTypeCOLLECTION.class
   Update jdbc/lib/ojdbc5.jar with /jdbc/lib/ojdbc5.jar/oracle/net/resolver/AddrResolution.class
   Update jdbc/lib/ojdbc6.jar with /jdbc/lib/ojdbc6.jar/oracle/jdbc/OracleDatabaseMetaData.class
   Update jdbc/lib/ojdbc6.jar with /jdbc/lib/ojdbc6.jar/oracle/jdbc/driver/OracleSql$1.class
   Update jdbc/lib/ojdbc6.jar with /jdbc/lib/ojdbc6.jar/oracle/jdbc/driver/OracleSql$ParseMode.class
   Update jdbc/lib/ojdbc6.jar with /jdbc/lib/ojdbc6.jar/oracle/jdbc/driver/OracleSql.class
   Update jdbc/lib/ojdbc6.jar with /jdbc/lib/ojdbc6.jar/oracle/jdbc/driver/T4CConnection$1.class
   Update jdbc/lib/ojdbc6.jar with /jdbc/lib/ojdbc6.jar/oracle/jdbc/driver/T4CConnection.class
   Update jdbc/lib/ojdbc6.jar with /jdbc/lib/ojdbc6.jar/oracle/jdbc/oracore/OracleTypeCOLLECTION.class
   Update jdbc/lib/ojdbc6.jar with /jdbc/lib/ojdbc6.jar/oracle/net/resolver/AddrResolution.class
   Copy aurora.zip to /u01/app/oracle/product/11.2.0.4/db_1/javavm/lib/aurora.zip

  Possible XML representation of the patch:
<ONEOFF REF_ID="26925532" ROLLBACK="T" XML_INV_LOC="oneoffs/26925532/" ACT_INST_VER="11.2.0.4.0" INSTALL_TIME="2019.Jan.14 16:32:32 CST">
   <DESC></DESC>
   <REF_LIST>
      <REF NAME="oracle.javavm.server" VER="11.2.0.4.0" HOME_IDX="0"/>
      <REF NAME="oracle.rdbms" VER="11.2.0.4.0" HOME_IDX="0"/>
      <REF NAME="oracle.rdbms.dbscripts" VER="11.2.0.4.0" HOME_IDX="0"/>
      <REF NAME="oracle.sqlj" VER="11.2.0.4.0" HOME_IDX="0"/>
      <REF NAME="oracle.sqlj.companion" VER="11.2.0.4.0" HOME_IDX="0"/>
      <REF NAME="oracle.dbjava.jdbc" VER="11.2.0.4.0" HOME_IDX="0"/>
      <REF NAME="oracle.dbjava.ic" VER="11.2.0.4.0" HOME_IDX="0"/>
      <REF NAME="oracle.javavm.client" VER="11.2.0.4.0" HOME_IDX="0"/>
   </REF_LIST>
   <BUG_LIST>
     <BUG>18933818</BUG>
     <BUG>19176885</BUG>
     <BUG>17201047</BUG>
     <BUG>25067795</BUG>
     <BUG>14774730</BUG>
     <BUG>19153980</BUG>
     <BUG>21911849</BUG>
     <BUG>23727132</BUG>
     <BUG>18166577</BUG>
     <BUG>27000663</BUG>
     <BUG>24448240</BUG>
     <BUG>17056813</BUG>
     <BUG>21811517</BUG>
     <BUG>19909862</BUG>
     <BUG>25494379</BUG>
     <BUG>22675136</BUG>
     <BUG>24534298</BUG>
     <BUG>19895326</BUG>
     <BUG>22253904</BUG>
     <BUG>17804361</BUG>
     <BUG>19231857</BUG>
     <BUG>26023002</BUG>
     <BUG>17528315</BUG>
     <BUG>19058059</BUG>
     <BUG>19554117</BUG>
     <BUG>19007266</BUG>
     <BUG>17285560</BUG>
     <BUG>22670385</BUG>
     <BUG>18458318</BUG>
     <BUG>19187988</BUG>
     <BUG>23265914</BUG>
     <BUG>19699946</BUG>
     <BUG>19006757</BUG>
     <BUG>19374518</BUG>
     <BUG>19223010</BUG>
     <BUG>25076732</BUG>
     <BUG>22118835</BUG>
     <BUG>26637592</BUG>
     <BUG>19852360</BUG>
     <BUG>20408829</BUG>
     <BUG>21047766</BUG>
     <BUG>21566944</BUG>
   </BUG_LIST>
   <FILE_LIST/>
</ONEOFF>

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

OPatch succeeded.
[oracle@rac1 solaris11.2.0.4]$ 

执笔画情ora
关注
专栏目录
100天精通Oracle-实战系列（第18天）RMAN Duplicate 异机复制 Oracle 数据库
LuciferLiu_DBA
05-23 1394
RMAN Duplicate 是从 Oracle 10G 开始出现的功能，但是在 11G 时增加了很多功能，可以通过 Active Database Duplicate 和 Backup-based Duplicate 两种方法实现。
oracle数据库升级失败怎么办,【案例】Oracle报错ORA-00918 数据库升级后遇到SQL BUG 5368296...
weixin_32190377的博客
04-05 781
天萃荷净运维DBA反映生产数据库10.2.0.1存在BUG导致SQL无法使用，在升级到10.2.0.5后执行SQL报错ORA-00918，分析原因为BUG修复后要修改SQL语句，升级数据库到10.2.0.5遭遇ORA-00918: column ambiguously defined一个数据库从10201升级到10205之后,出现ORA-00918错误,查询mos发现在以前版本中是bug,Orac...
Oracle11g表空间4--修改和移动表空间中数据文件
VipWangJian的博客
08-04 352
[code="java"] 1.修改表空间中数据文件的自动扩展性 在创建表空间时，可以设置数据文件的自动扩展性。 在为表空间增加新的数据文件时，也可以设置新数据文件的自动扩展性。而对于已创建的表空间中的已有数据文件，则可以使用alter database语句修改其自动扩展性，语法如下： alter database datafile file_name autoextend off|o...
Oracle 12c ORA-29548 报错处理
xfhuangfu的专栏
01-25 4848
Oracle 12c ORA-29548 报错处理 一、基础环境介绍 OS：Red Hat Enterprise Linux Server release 6.6 GI：12.1.0.2 DB：12.1.0.2 PSU:12.1.0.2.180717 Opatch:12.2.0.1.14 二、处理过程 1、检查操作系统jdk版本信息 cd $ORACLE_HOME/jdk/bin ./java –...
19c启动pdb报warning ORA-29548
qq_16729455的博客
01-23 1127
概述 最近在客户环境新部署19c数据库环境，在建好实例后，启动pdb异常报错，一直没有找到故障原因，后面经排查是由于oracle自带java异常，重新编译后正常。 环境：19.6+redhat 7.8 1.pdb启动报错详情，报错详细如下 SQL> select *from PDB_PLUG_IN_VIOLATIONS; [17:59:185.1.74.33] [17:59:185.1.74.33]TIME
迁移报错处理案例（1）RAC to RAC ORA-29548 java程序调用报错
最新发布
Nuzbb的博客
01-22 590
DG迁移源端 linux 11.2.0.4 RAC 数据库集群均无补丁目标端 linux 11.2.0.4 RAC 集群无补丁，数据库、OJVM应用最新202010补丁。
sqlplus / as sysdba无法连接ORA-12547 TNS: Lost Contact
wgz7747147820的博客
04-28 1526
参考这个链接 http://www.cnblogs.com/zihanxing/articles/6278867.html 问题现象： ORA-12547 TNS: Lost Contact Getting the following error when trying to connect using Sql*Plus ERROR: $sqlplus / as sysdba SQL*Plus: ...
Oracle Database Upgrade Guide 11g Release 2 (11.2-198
06-18
《Oracle Database Upgrade Guide 11g Release 2 (11.2-198)》是一本详尽的指南，旨在帮助用户成功升级到Oracle数据库11g版本的第二个发布版（11.2）。这份文档由Oracle公司及其关联公司在2002年至2014年间编撰，...
2021年4月Oracle数据库补丁分析报告
Enmotech的博客
05-12 911
点击上方"蓝字"关注我们，享更多干货！引言编写目的编写此文档为了更好地指导Oracle补丁安装工作，细化工作任务，规范安装升级操作。背景Oracle对于其产品每个季度发行一...
Oracle RAC 11G打补丁
dhusubing的博客
01-31 1180
Oracle RAC 11G打补丁 1 GI 部分 1.1 升级GI opatch 以下在RAC所有节点进行 先备份原GI opatch [root@rac1 grid]# mv /u01/app/ grid /11.2.0/OPatch /u01/app/ grid /11.2.0/OPatchbak 将GI压缩包解压到grid用户下ORACLE_HOME [root@rac1 grid]$ unzip p6880880_112000_Linux-x86-64.zip -d <ORACLE_H
11g数据库打完ojvm psu补丁后报错ORA-29548: ORA-06512:
sqlora的专栏
10-29 1930
同事反馈报错: SQL> select dbms_java.longname('1') from dual; select dbms_java.longname('1') from dual * ERROR at line 1:ORA-29548: Java ϵͳcould not identify release specified in classes.bin ORA-06512: SYS.DBMS_JAVA", line 139 检查组件正常: SQL> select ...
Centos7.9+Oracle11.2.0.4数据库ADG主备环境搭建
sqlora的专栏
08-04 3234
Oracle11.2.0.4数据库ADG主备环境搭建 实现目标 两台X86数据库服务器实现oracle11g的主备adg环境，避免单点故障，满足数据库基本容灾备份需求。其中操作系统版本要求centos7.9，数据库版本要求oracle11.2.0.4+最新psu201020版本。 环境准备 主库 备库 主机名 prebilla prebillb 本机ip.
Oracle 11.2.0.4.5 RAC升级OJVM至11.2.0.4.160419完整步骤
lk的窝
05-11 4301
测试环境信息： [root@rac1 ~]# cat /etc/issue Red Hat Enterprise Linux Server release 6.5 (Santiago) Kernel \r on an \m SQL> select * from v$version; BANNER -------------------------------------------
ORA-01898: too many precision specifiers 分析
killvoon的专栏
09-09 8450
客户写了条sql语句在使用trunc的时候报错：ORA-01898: too many precision specifiers oracle意思就是指定的精度过多，比如trunc(sysdate,'yyyymm')，便会报这个错， 但客户的sql语句一开始执行的时候是可以执行成功的，没有报ora-01898的错误，不理解。 经过分析后明白原因，因为客户那条sql语句的执行结果是空值，tru
EXP-00008的解决
weixin_34301307的博客
09-15 1728
在做EXP时出现如下错误, EXP-00008: ORACLE 错误 1555 发生ORA-01555: snapshot too old: rollback segment number 52 with name "RBS51" too small汇出作业顺利终止, 但含有警告 网上搜到的解法均是增加回滚段的大小,可是我已经增加的很大了,仍报这个错.看来是要导出的数据量太大,分段导出试试...
ORACLE rac 11.2.0.4 for rhel7.8 upgrade to 19.11.1 报错ORA-29516处理
www_xue_xi的博客
08-22 490
近期，在ORACLE rac 11.2.0.4 for rhel7.8 upgrade to 19.11.1过程中，在dbua之前的preupgrade预检查中遇到报到错ORA-29516，相关报错的处理很简单，但是问题的原因和排查不太容易。 背景：将被升级的环境操作系统为rhel 7.8，Oracle GI版本是19.11.1，DB版本是11.2.0.4，GI和DB都应用过部分PSU补丁。但是，由于人员流动，待被升级的数据库DB的来源不太明确，就是说11.2.0.4是新装的，...
关于oracle 12c SQL语句执行结果与11g不一致的问题
killvoon的专栏
09-08 7380
将原有的系统迁移到oracle 12c上面，版本是12.1.0.2，总是有各种问题出现，不得不说，目前的版本真是个坑。 开发一条sql语句，insert .....select形式，单独执行select部分有结果，但insert。。。select的时候，显示插入结果为0，同样的数据，该语句放在10g，11gR1上都没问题，能够插入数据。只能说恭喜发财了。 语句如下： insert all w
ora-01033 报错处理
weixin_30507481的博客
03-09 73
重启DB shutdown immediate startup mount alter database open; 转载于:https://www.cnblogs.com/jack-yuan/p/6526057.html
oracle 等待的进程,Oracle 等待事件：ges generic event
weixin_36329368的博客
04-05 422
在 Oracle 12c 之后，Resource Master 进程成为了主从进程架构，一系列从属进程以 RMV 命名开头，出现在数据库中。在某些情况下，你可能在 AWR 中看到大量的 ges generic event 等待事件。ges generic event 顾名思义，就是关于 GES 的一个普通事件，属于空闲等待，无事可做的 IDLE 状态。在 ASH 报告中，可以看到类似如下的输出：这...
Oracle 11g在线补丁新特性：无需停机升级与自动内存管理
其中最显著的是“在线补丁”（Online Patches），这是11g的一项关键特性，允许用户在不中断数据库服务的情况下安装和管理一次性补丁，这对于大型企业环境中的高可用性和生产稳定性至关重要。RAC（Real Application ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值