Oracle 10.2.0.4中 OEM bug 8350262-mysql教程-PHP中文網

首頁

資料庫

mysql教程

Oracle 10.2.0.4中 OEM bug 8350262

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 05:05 PM

今天在OEL 4环境，从10.2.0.1升级至10.2.0.4，然后dbca建库，进度在91%的时候就不动了一直卡在那等了很久，最后报出来下面的错误

1、发现问题

今天在OEL 4环境，从10.2.0.1升级至10.2.0.4，然后dbca建库，进度在91%的时候就不动了一直卡在那等了很久，，最后报出来下面的错误~让我们来瞧瞧！

通过google搜索了下原来这是Oracle在10.2.0.4和10.2.0.5的BUG,运气这么好，被我给碰上了~

根据提示打开emConfig.log日志文件

Vi/u01/app/oracle/product/10.2/db/cfgtoollogs/dbca/prod/emConfig.log

Aug 17,2011 10:12:30 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc

CONFIG:Setting oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/oui

Aug 17,2011 10:12:30 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc

CONFIG:Setting oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/oui

Aug 17,2011 10:12:33 AM oracle.sysman.emcp.util.CentralAgentUtilgetCentralAgentHomeAndURL

CONFIG:Central Agent home and URL: {}

Aug 17,2011 10:12:33 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

CONFIG:Restoring oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/oui

Aug 17,2011 11:45:57 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: LOG_FILE value:/u01/app/oracle/product/10.2/db/cfgtoollogs/dbca/prod/emConfig.log

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: HOST value: oel1

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: PORT value: 1521

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: SID value: prod

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: LISTENER value: LISTENER

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: LISTENER_OH value: /u01/app/oracle/product/10.2/db

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlag

CONFIG:Flag '-config' set to true

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlag

CONFIG:Flag 'db' set to true

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: EM_HOME value: /u01/app/oracle/product/10.2/db

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: DB_UNIQUE_NAME value: prod

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: SERVICE_NAME value: prod

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

Aug 17,2011 10:12:30 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc

CONFIG:Setting oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/oui

Aug 17,2011 10:12:30 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc

CONFIG:Setting oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/oui

Aug 17,2011 10:12:33 AM oracle.sysman.emcp.util.CentralAgentUtilgetCentralAgentHomeAndURL

CONFIG:Central Agent home and URL: {}

Aug 17,2011 10:12:33 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

CONFIG:Restoring oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/oui

Aug 17,2011 11:45:57 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: LOG_FILE value:/u01/app/oracle/product/10.2/db/cfgtoollogs/dbca/prod/emConfig.log

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: HOST value: oel1

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: PORT value: 1521

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: SID value: prod

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: LISTENER value: LISTENER

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: LISTENER_OH value: /u01/app/oracle/product/10.2/db

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlag

CONFIG:Flag '-config' set to true

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlag

CONFIG:Flag 'db' set to true

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: EM_HOME value: /u01/app/oracle/product/10.2/db

Aug 17, 201111:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: DB_UNIQUE_NAME value: prod

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: SERVICE_NAME value: prod

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: ORACLE_HOME value: /u01/app/oracle/product/10.2/db

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlag

CONFIG:Flag '-cluster' set to true

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive

CONFIG:Alive node cache contents: []

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive

CONFIG:oel1 not found in alive node cache

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive

CONFIG:oel2 not found in alive node cache

Aug 17,2011 11:46:29 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive

CONFIG:Node: oel1 is accessible.

Aug 17,2011 11:46:29 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive

CONFIG:Node: oel2 is accessible.

Aug 17,2011 11:46:29 AM oracle.sysman.emcp.ParamsManager getInaccessibleNodeList

CONFIG:All nodes are up. Nodes: [oel1, oel2]

Aug 17,2011 11:46:29 AM oracle.sysman.emcp.ParamsManager getInaccessibleSidList

CONFIG:All nodes are up. Nodes: [oel1, oel2] Sids: [prod1, prod2]

2、Oracle 对这个bug原因的说明：

In Enterprise Manager DatabaseControl with Oracle Database 10.2.0.4 and 10.2.0.5, the root certificate used to securecommunications via the Secure Socket Layer (SSL) protocol will expire on31-Dec-2010 00:00:00. Thecertificate expiration will cause errors if you attempt to configure DatabaseControl on or after 31-Dec-2010. Existing Database Controlconfigurations are not impacted by this issue.

If you plan to configure Database Control with either of theseOracle Database releases, Oraclestrongly recommends that you apply to your Oracle Homeinstallations before you configure Database Control. Configuration of Database Control istypically done when you create or upgrade Oracle Database, or if you runEnterprise Manager Configuration Assistant (EMCA) in standalone mode.

Note the following:

（1）The issue impacts configuration ofDatabase Control with Oracle Database 10.2.0.4 and 10.2.0.5 only. It does notimpact database creation or upgrade.

（2）The issue does not impact existingDatabase Control configurations.

（3）Application of Patch 8350262 does not require any databasedowntime

3、解决问题

ORACLE 给出的建议操作步骤如下：

Recovering from Configuration Errors on a Single InstanceDatabase

单实例

Recovering from Configuration Errors on a Single InstanceDatabase
1. Ignore any errors and continue with the installation or upgrade. Thedatabase will be created without errors.

2. Apply Patch 8350262 to your Oracle Home installation usingOPatch.

opatch apply

Invoking OPatch 10.2.0.4.2

Oracle Home : /myhost
Central Inventory : /scratch/pchebrol/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /myhost/oui
Log file location : /myhost/cfgtoollogs/opatch/opatch2011-01-02_11-00-00AM.log

ApplySession applying interim patch '8350262' to OH '/myhost'

Running prerequisite checks...

OPatch detected non-cluster Oracle Home from the inventory andwill patch the local system only.

Backing up files and inventory (not for auto-rollback) for theOracle Home
Backing up files affected by the patch '8350262' for restore. This might take awhile...
Backing up files affected by the patch '8350262' for rollback. This might takea while...

Patching component oracle.sysman.agent.core, 10.2.0.4.0a...
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/SecConstants.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with"/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with"/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with"/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with"/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/util/SecConstants.class"
ApplySession adding interim patch '8350262' to inventory

Verifying the update...
Inventory check OK: Patch ID 8350262 is registered in Oracle Home inventorywith proper meta-data.
Files check OK: Files from Patch ID 8350262 are present in Oracle Home.

OPatch succeeded.

linux

陳述

本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn

MySQL：初學者的基本技能Apr 18, 2025 am 12:24 AM

MySQL適合初學者學習數據庫技能。 1.安裝MySQL服務器和客戶端工具。 2.理解基本SQL查詢，如SELECT。 3.掌握數據操作：創建表、插入、更新、刪除數據。 4.學習高級技巧：子查詢和窗口函數。 5.調試和優化：檢查語法、使用索引、避免SELECT*，並使用LIMIT。

MySQL：結構化數據和關係數據庫Apr 18, 2025 am 12:22 AM

MySQL通過表結構和SQL查詢高效管理結構化數據，並通過外鍵實現表間關係。 1.創建表時定義數據格式和類型。 2.使用外鍵建立表間關係。 3.通過索引和查詢優化提高性能。 4.定期備份和監控數據庫確保數據安全和性能優化。

MySQL：解釋的關鍵功能和功能Apr 18, 2025 am 12:17 AM

MySQL是一個開源的關係型數據庫管理系統，廣泛應用於Web開發。它的關鍵特性包括：1.支持多種存儲引擎，如InnoDB和MyISAM，適用於不同場景；2.提供主從復制功能，利於負載均衡和數據備份；3.通過查詢優化和索引使用提高查詢效率。

SQL的目的：與MySQL數據庫進行交互Apr 18, 2025 am 12:12 AM

SQL用於與MySQL數據庫交互，實現數據的增、刪、改、查及數據庫設計。 1）SQL通過SELECT、INSERT、UPDATE、DELETE語句進行數據操作；2）使用CREATE、ALTER、DROP語句進行數據庫設計和管理；3）複雜查詢和數據分析通過SQL實現，提升業務決策效率。

初學者的MySQL：開始數據庫管理Apr 18, 2025 am 12:10 AM

MySQL的基本操作包括創建數據庫、表格，及使用SQL進行數據的CRUD操作。 1.創建數據庫：CREATEDATABASEmy_first_db;2.創建表格：CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY,titleVARCHAR(100)NOTNULL,authorVARCHAR(100)NOTNULL,published_yearINT);3.插入數據：INSERTINTObooks(title,author,published_year)VA

MySQL的角色：Web應用程序中的數據庫Apr 17, 2025 am 12:23 AM

MySQL在Web應用中的主要作用是存儲和管理數據。 1.MySQL高效處理用戶信息、產品目錄和交易記錄等數據。 2.通過SQL查詢，開發者能從數據庫提取信息生成動態內容。 3.MySQL基於客戶端-服務器模型工作，確保查詢速度可接受。

mysql：構建您的第一個數據庫Apr 17, 2025 am 12:22 AM

構建MySQL數據庫的步驟包括：1.創建數據庫和表，2.插入數據，3.進行查詢。首先，使用CREATEDATABASE和CREATETABLE語句創建數據庫和表，然後用INSERTINTO語句插入數據，最後用SELECT語句查詢數據。

MySQL：一種對數據存儲的初學者友好方法Apr 17, 2025 am 12:21 AM

MySQL適合初學者，因為它易用且功能強大。 1.MySQL是關係型數據庫，使用SQL進行CRUD操作。 2.安裝簡單，需配置root用戶密碼。 3.使用INSERT、UPDATE、DELETE、SELECT進行數據操作。 4.複雜查詢可使用ORDERBY、WHERE和JOIN。 5.調試需檢查語法，使用EXPLAIN分析查詢。 6.優化建議包括使用索引、選擇合適數據類型和良好編程習慣。

See all articles