Oracle 10.2.0.4中 OEM bug 8350262-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

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

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How do you alter a table in MySQL using the ALTER TABLE statement?Mar 19, 2025 pm 03:51 PM

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

How do I configure SSL/TLS encryption for MySQL connections?Mar 18, 2025 pm 12:01 PM

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

How do you handle large datasets in MySQL?Mar 21, 2025 pm 12:15 PM

Article discusses strategies for handling large datasets in MySQL, including partitioning, sharding, indexing, and query optimization.

What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?Mar 21, 2025 pm 06:28 PM

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

How do you drop a table in MySQL using the DROP TABLE statement?Mar 19, 2025 pm 03:52 PM

The article discusses dropping tables in MySQL using the DROP TABLE statement, emphasizing precautions and risks. It highlights that the action is irreversible without backups, detailing recovery methods and potential production environment hazards.

How do you represent relationships using foreign keys?Mar 19, 2025 pm 03:48 PM

Article discusses using foreign keys to represent relationships in databases, focusing on best practices, data integrity, and common pitfalls to avoid.

How do you create indexes on JSON columns?Mar 21, 2025 pm 12:13 PM

The article discusses creating indexes on JSON columns in various databases like PostgreSQL, MySQL, and MongoDB to enhance query performance. It explains the syntax and benefits of indexing specific JSON paths, and lists supported database systems.

How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?Mar 18, 2025 pm 12:00 PM

Article discusses securing MySQL against SQL injection and brute-force attacks using prepared statements, input validation, and strong password policies.(159 characters)

See all articles

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)

2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hello Kitty Island Adventure: How To Get Giant Seeds

1 months agoBy尊渡假赌尊渡假赌尊渡假赌

How Long Does It Take To Beat Split Fiction?

4 weeks agoByDDD

R.E.P.O. Save File Location: Where Is It & How to Protect It?

4 weeks agoByDDD

Two Point Museum: All Exhibits And Where To Find Them

1 months agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

WebStorm Mac version

Useful JavaScript development tools

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software