Oracle 10.2.0.5 emca配置報錯-ssl Open wallet failed, ret = 28750

rongshiyuan發表於2012-11-26
OracleAI
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章