Oracle 10.2.0.5 emca配置报错-ssl Open wallet failed, ret = 28750

Oracle 10.2.0.5 emca配置报错-ssl Open wallet failed, ret = 28750 ssl: nmehlenv_openWallet failed http: 5: Unable to initialize ssl connection with server, aborting connection......

emca 配置过程中日志如下：

[oracle@rac2 dbs]$ emca -config dbcontrol db -repos create

STARTED EMCA at Nov 26, 2012 8:47:34 PM
EM Configuration Assistant, Version 10.2.0.5.0 Production
Copyright (c) 2003, 2009, Oracle.  All rights reserved.

Enter the following information:
Database SID: RACDB2
Listener port number: 1521
Password for SYS user:  H
Password for DBSNMP user: 
Nov 26, 2012 8:47:59 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
WARNING: ORA-28000: the account is locked

Password for SYSMAN user: 
Password for SYSMAN user: Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /opt/ora10g/product/10.2.0/db_1 ]:
ASM SID [ +ASM ]: +ASM2 
ASM port [ 1521 ]:
ASM user role [ SYSDBA ]:
ASM username [ SYS ]:
ASM user password: 
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /opt/ora10g/product/10.2.0/db_1

Local hostname ................ rac2
Listener port number ................ 1521
Database SID ................ RACDB2
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ /opt/ora10g/product/10.2.0/db_1
ASM SID ................ +ASM2
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ SYS

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 26, 2012 8:49:40 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/ora10g/product/10.2.0/db_1/cfgtoollogs/emca/RACDB/emca_2012-11-26_08-47-34-PM.log.
Nov 26, 2012 8:49:45 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 26, 2012 8:56:56 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 26, 2012 8:58:09 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Nov 26, 2012 8:59:40 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Nov 26, 2012 8:59:40 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Nov 26, 2012 9:10:30 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /opt/ora10g/product/10.2.0/db_1/bin/emctl start dbconsole
Nov 26, 2012 9:10:30 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at /opt/ora10g/product/10.2.0/db_1/cfgtoollogs/emca/RACDB/emca_2012-11-26_08-47-34-PM.log for more details.
Could not complete the configuration. Refer to the log file at /opt/ora10g/product/10.2.0/db_1/cfgtoollogs/emca/RACDB/emca_2012-11-26_08-47-34-PM.log for more details.

根据上述查看日志 /opt/ora10g/product/10.2.0/db_1/cfgtoollogs/emca/RACDB/emca_2012-11-26_08-47-34-PM.log：

......

https://rac2:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control .....................................................................
........................ failed.
------------------------------------------------------------------
Logs are generated in directory /opt/ora10g/product/10.2.0/db_1/rac2_RACDB2/sysman/log

Nov 26, 2012 9:10:30 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /opt/ora10g/product/10.2.0/db_1/bin/emctl start dbconsole
Nov 26, 2012 9:10:30 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control

......

根据上述提示的日志路径 /opt/ora10g/product/10.2.0/db_1/rac2_RACDB2/sysman/log

进入该目录查看日志列表：

[oracle@rac2 ~]$ cd /opt/ora10g/product/10.2.0/db_1/rac2_RACDB2/sysman/log
[oracle@rac2 log]$ ls -ltrh
total 676K
-rw-r----- 1 oracle oinstall    0 Nov 26 20:59 emdctl.log
-rw-r----- 1 oracle oinstall 4.4K Nov 26 20:59 secure.log
-rw-r----- 1 oracle oinstall 2.5K Nov 26 21:01 emdb.nohup.lr
-rw-r----- 1 oracle oinstall  184 Nov 26 21:01 emagent.log
-rw-r----- 1 oracle oinstall    0 Nov 26 21:01 emagentfetchlet.trc
-rw-r----- 1 oracle oinstall    0 Nov 26 21:01 emagentfetchlet.log
drwxrwx--- 2 oracle dba      4.0K Nov 26 21:04 nmcRACDB21521
-rw-r----- 1 oracle oinstall  17K Nov 26 23:58 emdb.nohup
-rw-r----- 1 oracle oinstall  31K Nov 27 00:11 emoms.trc
-rw-r----- 1 oracle oinstall  31K Nov 27 00:11 emoms.log
-rw-r----- 1 oracle oinstall  98K Nov 27 00:13 emdctl.trc
-rw-r----- 1 oracle oinstall 464K Nov 27 00:13 emagent.trc

查看最后修改时间的两个trc文件，获取错误日志信息：

......

2012-11-27 00:14:39 Thread-3061201104 ERROR ssl: Open wallet failed, ret = 28750
2012-11-27 00:14:39 Thread-3061201104 ERROR ssl: nmehlenv_openWallet failed
2012-11-27 00:14:39 Thread-3061201104 ERROR http: 5: Unable to initialize ssl connection with server, aborting connection att
empt
2012-11-27 00:15:09 Thread-3061176528 ERROR ssl: Open wallet failed, ret = 28750
2012-11-27 00:15:09 Thread-3061176528 ERROR ssl: nmehlenv_openWallet failed
2012-11-27 00:15:09 Thread-3061176528 ERROR http: 5: Unable to initialize ssl connection with server, aborting connection att
empt

......

在metalink上查询上面异常信息，得知bug， 通过Patch 8350262来解决

n 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 impacted 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.

Note the following:

• The issue impacts configuration of Database Control with Oracle Database 10.2.0.4 and 10.2.0.5 only. It does not impact database creation or upgrade.
• The issue does not impact existing Database Control configurations.
• Application of Patch 8350262 does not require any database downtime

Note: If you apply Patch 8350262 to your Oracle Home installations before you configure Database Control, you will not need to follow the recovery steps outlined in this document.

 

 

下载、解压补丁p8350262_10205_Generic.zip

unzip p8350262_10205_Generic.zip

 

注意PATH变量中包括OPatch路径

停止oracle相关服务

cd 8350262/

opatch apply

......

 

emca重新配置

[oracle@rac2 ~]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Nov 27, 2012 1:31:57 PM
EM Configuration Assistant, Version 10.2.0.5.0 Production
Copyright (c) 2003, 2009, Oracle.  All rights reserved.

Enter the following information:
Database SID: RACDB2  
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
Nov 27, 2012 1:32:15 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/ora10g/product/10.2.0/db_1/cfgtoollogs/emca/RACDB/emca_2012-11-27_01-31-57-PM.log.
Nov 27, 2012 1:32:19 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Nov 27, 2012 1:32:42 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Nov 27, 2012 1:32:42 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Nov 27, 2012 1:39:38 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 27, 2012 1:39:39 PM

 

 

[oracle@rac2 ~]$ emca -config dbcontrol db -repos create

STARTED EMCA at Nov 27, 2012 1:46:25 PM
EM Configuration Assistant, Version 10.2.0.5.0 Production
Copyright (c) 2003, 2009, Oracle.  All rights reserved.

Enter the following information:
Database SID: RACDB2
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):
ASM ORACLE_HOME [ /opt/ora10g/product/10.2.0/db_1 ]:
ASM SID [ +ASM ]: +ASM2
ASM port [ 1521 ]:
ASM user role [ SYSDBA ]:
ASM username [ SYS ]:
ASM user password: 
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /opt/ora10g/product/10.2.0/db_1

Local hostname ................ rac2
Listener port number ................ 1521
Database SID ................ RACDB2
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ /opt/ora10g/product/10.2.0/db_1
ASM SID ................ +ASM2
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ SYS

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 27, 2012 1:47:00 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/ora10g/product/10.2.0/db_1/cfgtoollogs/emca/RACDB/emca_2012-11-27_01-46-25-PM.log.
Nov 27, 2012 1:47:06 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 27, 2012 1:56:12 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 27, 2012 1:57:04 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Nov 27, 2012 1:58:54 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Nov 27, 2012 1:58:54 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Nov 27, 2012 2:02:36 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Nov 27, 2012 2:02:37 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://rac2:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 27, 2012 2:02:37 PM

 

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

转载于:http://blog.itpub.net/17252115/viewspace-750029/