em管理器的BUG

最新推荐文章于 2024-05-19 20:09:45 发布

coolfire1977

最新推荐文章于 2024-05-19 20:09:45 发布

阅读量251

点赞数

文章标签：数据库操作系统

背景环境：

操作系统：suse linux 11 sp1

数据库：oracle 10.2.0.5

问题：不能使用em管理器，但是10.2.0.1是可以用的，打了补丁就不行了。

[@more@]

问题解决办法：

此为oracle数据库在该版本的BUG， Oracle专门发布了补丁8350262来解决这一问题。此bug在1222603.1有详细描述。也就意味着以后升级到10204或10205版本，如果要使用em，补丁8350262成为了必打之补丁。

oracle官方的描述如下：

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

If you plan to configure Database Control with either of these Oracle Database releases, Oracle strongly recommends that you apply Patch 8350262 to your Oracle Home installations before you configure Database Control. Configuration of Database Control is typically done when you create or upgrade Oracle Database, or if you run Enterprise Manager Configuration Assistant (EMCA) in standalone mode.

大致意思是用于em通信的ssl由于在2010-12-31日00:00之后失效，导致之后的em安装将会报如下错误：

引用

2011-01-09 09:36:56 Thread-51125136 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://myhost:1158/em/upload/: retStatus=-1
2011-01-09 09:36:56 Thread-51125136 ERROR ssl: Open wallet failed, ret = 28750
2011-01-09 09:36:56 Thread-51125136 ERROR ssl: nmehlenv_openWallet failed
2011-01-09 09:36:56 Thread-51125136 ERROR http: 15: Unable to initialize ssl connection with server, aborting connection attempt

p8350262_10204_Generic.ziphttp://dl.iteye.com/topics/download/cad88a9d-bb88-3b9b-8acd-daa3c5054f2e

p8350262_10205_Generic.ziphttp://dl.iteye.com/topics/download/c9e40628-cd05-33ef-b1df-ad5420a6d9f4

问题解决过程：

1、查看OPatch所在路径：

ebdbpro:/soft> env | grep ORA

ORA_CRS_HOME=/eb_db/oracle/product/10.2/crs

ORA_ASM_HOME=/eb_db/oracle/product/10.2/asm

ORA_NLS10=/eb_db/oracle/product/10.2/db/nls/data

ORACLE_SID=ebai

ORACLE_BASE=/opt/oracle

ORACLE_HOME=/eb_db/oracle/product/10.2/db

ebdbpro:/soft> cd $ORACLE_HOME/OPatch

ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> ls

crs docs emdpatch.pl jlib ocm opatch opatch.ini opatch.pl opatchprereqs

ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> pwd

/eb_db/oracle/product/10.2/db/OPatch

ebdbpro:/eb_db/oracle/product/10.2/db/OPatch>

可执行文件opatch就再这个目录下面。

2、上传文件并进行解压：

ebdbpro:/soft> ls

10201_database_linux_x86_64.cpio Disk1 README.htm

8350262 orarun-1.9-172.20.21.54.x86_64.rpm suse11_HA_64

8350262.bak p8202632_10205_Linux-x86-64.zip

database p8350262_10205_Generic.zip

ebdbpro:/soft>unzip p8350262_10205_Generic.zip

3、切换用户进行操作。opatch至允许oracle用户来进行操作。

ebdbpro:/soft/8350262 # su - oracle

ebdbpro:~> cd /soft

ebdbpro:/soft> ls

10201_database_linux_x86_64.cpio

8350262

8350262.bak

database

Disk1

orarun-1.9-172.20.21.54.x86_64.rpm

p8202632_10205_Linux-x86-64.zip

p8350262_10205_Generic.zip

README.htm

suse11_HA_64

ebdbpro:/soft> cd 8350262

ebdbpro:/soft/8350262> ls

etc files killDBConsole killDBConsole.pl README.txt

4、执行opatch小补丁安装操作：

ebdbpro:/soft/8350262> /eb_db/oracle/product/10.2/db/OPatch/opatch apply

Invoking OPatch 10.2.0.4.9

Oracle Interim Patch Installer version 10.2.0.4.9

Oracle Home : /eb_db/oracle/product/10.2/db

Central Inventory : /eb_db/oracle/oraInventory

from : /etc/oraInst.loc

OPatch version : 10.2.0.4.9

OUI version : 10.2.0.5.0

OUI location : /eb_db/oracle/product/10.2/db/oui

Log file location : /eb_db/oracle/product/10.2/db/cfgtoollogs/opatch/opatch2012-05-20_17-14-44PM.log

Patch history file: /eb_db/oracle/product/10.2/db/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '8350262' to OH '/eb_db/oracle/product/10.2/db'

Running prerequisite checks...

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

Backing up files and inventory (not for auto-rollback) for the Oracle Home

Backing up files affected by the patch '8350262' for restore. This might take a while...

Backing up files affected by the patch '8350262' for rollback. This might take a while...

Patching component oracle.sysman.agent.core, 10.2.0.5.0a...

Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"

Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"

Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/RootCert.class"

Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/SecConstants.class"

Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"

Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"

Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/util/RootCert.class"

Updating jar file "/eb_db/oracle/product/10.2/db/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 inventory with proper meta-data.

Files check OK: Files from Patch ID 8350262 are present in Oracle Home.

OPatch succeeded.

ebdbpro:/soft/8350262>

成功结束！

:) :) :)

5、删除之前安装过程中的无效em：

ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Sun May 20 17:34:27 2012

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> DROP public synonym SETEMVIEWUSERCONTEXT;

Synonym dropped.

SQL> SQL> DROP PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;

Synonym dropped.

SQL> SQL> drop role MGMT_USER;

Role dropped.

SQL> SQL> DROP USER MGMT_VIEW CASCADE;

User dropped.

SQL> SQL> DROP USER SYSMAN CASCADE;

User dropped.

SQL> SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> emca -deconfig dbcontrol db -repos drop

STARTED EMCA at May 20, 2012 5:35:17 PM

EM Configuration Assistant, Version 10.2.0.5.0 Production

Enter the following information:

Database SID: ebai

Database SID: Listener port number: 1521

Password for SYS user:

Password for SYSMAN user:

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

WARNING : While repository is dropped the database will be put in quiesce mode.

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

Do you wish to continue? [yes(Y)/no(N)]: Y

May 20, 2012 5:35:30 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /eb_db/oracle/product/10.2/db/cfgtoollogs/emca/ebai/emca_2012-05-20_05-35-17-PM.log.

May 20, 2012 5:35:30 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine

WARNING: ORA-01017: invalid username/password; logon denied

May 20, 2012 5:35:30 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl

WARNING: Error initializing SQL connection. SQL operations cannot be performed

May 20, 2012 5:35:30 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration

WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:

1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME= and re-run EMCA script

2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script

May 20, 2012 5:35:31 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Dropping the EM repository (this may take a while) ...

May 20, 2012 5:35:31 PM oracle.sysman.emcp.EMReposConfig dropRepository

INFO: Dropping the EM repository (this may take a while) ...

May 20, 2012 5:35:31 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully dropped

Enterprise Manager configuration completed successfully

FINISHED EMCA at May 20, 2012 5:35:31 PM

6、重新创建em：

ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> emca -config dbcontrol db -repos create

STARTED EMCA at May 20, 2012 5:35:42 PM

EM Configuration Assistant, Version 10.2.0.5.0 Production

Enter the following information:

Database SID: ebai

Database SID: Listener port number: 1521

Password for SYS user:

Password for DBSNMP user:

Password for SYSMAN user:

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional):

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

You have specified the following settings

Database ORACLE_HOME ................ /eb_db/oracle/product/10.2/db

Local hostname ................ ebdbpro

Listener port number ................ 1521

Database SID ................ ebai

Email address for notifications ...............

Outgoing Mail (SMTP) server for notifications ...............

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

Do you wish to continue? [yes(Y)/no(N)]: Y

May 20, 2012 5:36:00 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /eb_db/oracle/product/10.2/db/cfgtoollogs/emca/ebai/emca_2012-05-20_05-35-42-PM.log.

May 20, 2012 5:36:01 PM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) ...

May 20, 2012 5:36:50 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully created

May 20, 2012 5:36:53 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Securing Database Control (this may take a while) ...

May 20, 2012 5:37:31 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Database Control secured successfully.

May 20, 2012 5:37:31 PM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) ...

May 20, 2012 5:39:09 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

May 20, 2012 5:39:09 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is https://ebdbpro:1158/em <<<<<<<<<<<

Enterprise Manager configuration completed successfully

FINISHED EMCA at May 20, 2012 5:39:09 PM

ebdbpro:/eb_db/oracle/product/10.2/db/OPatch>

7、启动管理器：

ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> emctl start dbconsole

TZ set to Asia/Shanghai

Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0

https://ebdbpro:1158/em/console/aboutApplication

- An instance of Oracle Enterprise Manager 10g Database Control is already running.

ebdbpro:/eb_db/oracle/product/10.2/db/OPatch>

##################################

中途的其他误操作过程，留下来参考，免得下次再犯：

ebdbpro:/eb_db/oracle/product/10.2/db/OPatch>

ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> /eb_db/oracle/product/10.2/db/OPatch/opatch 8350262 apply

Invoking OPatch 10.2.0.4.9

Oracle Interim Patch Installer version 10.2.0.4.9

Syntax Error... Unrecognized Command or Option (8350262): 1st argument must be one of the following:

apply

napply

rollback

nrollback

lsinventory

lsinv

query

util

prereq

version

-help

-h

Please use the option 'opatch -help' to get correct syntax

OPatch failed with error code 14

ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> /eb_db/oracle/product/10.2/db/OPatch/opatch 8350262

Invoking OPatch 10.2.0.4.9

Oracle Interim Patch Installer version 10.2.0.4.9

Syntax Error... Unrecognized Command or Option (8350262): 1st argument must be one of the following:

apply

napply

rollback

nrollback

lsinventory

lsinv

query

util

prereq

version

-help

-h

Please use the option 'opatch -help' to get correct syntax

OPatch failed with error code 14

##################################

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26006637/viewspace-1059945/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26006637/viewspace-1059945/

coolfire1977

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
em管理器的BUG

背景环境：操作系统：suse linux 11 sp1数据库：oracle 10.2.0.5问题：不能使用em管理器，但是10.2.0.1是可以用的，打了补丁就不行了。[@more@]问题解决办法：此为oracle数据库在该版本...
复制链接

扫一扫