Sunday, January 9, 2011

10.2.0.4/10.2.0.5 DB Console certification expiry on 31-Dec-2010

After 31-Dec-2010, you will not be able to use this feature properly, unless you have installed patch 8350262, which will create a new SSL certificate with 10 year validaty.


Possible Symptoms:


2011-01-07 09:08:36 Thread-71 ERROR upload: Error in uploadXMLFiles. Trying aga
in in 300.00 seconds.
2011-01-07 09:08:58 Thread-76 ERROR ssl: Open wallet failed, ret = 28750
2011-01-07 09:08:58 Thread-76 ERROR ssl: nmehlenv_openWallet failed
2011-01-07 09:08:58 Thread-76 ERROR http: 13: Unable to initialize ssl connectio
n with server, aborting connection attempt
2011-01-07 09:08:58 Thread-76 ERROR pingManager: nmepm_pingReposURL: Cannot conn
ect to https://hostname1:5500/em/upload/: retStatus=-1
2011-01-07 09:08:58 Thread-76 ERROR ssl: Open wallet failed, ret = 28750
2011-01-07 09:08:58 Thread-76 ERROR ssl: nmehlenv_openWallet failed
2011-01-07 09:08:58 Thread-76 ERROR http: 13: Unable to initialize ssl connectio
n with server, aborting connection attempt
2011-01-07 09:08:58 Thread-76 ERROR pingManager: nmepm_pingReposURL: Cannot conn
ect to https://hostname1:5500/em/upload/: retStatus=-1
2011-01-07 09:09:03 Thread-77 ERROR upload: Error in uploadXMLFiles. Trying aga
in in 300.00 seconds.






Jan 7, 2011 9:09:11 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/app/oracle/product/10.2.0/db_1/bin/emctl start dbconsole
Jan 7, 2011 9:09:11 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/DB1/emca_2011-01-07_08-58-51-AM.log for more details.
Jan 7, 2011 9:09:11 AM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error starting Database Control
at oracle.sysman.emcp.EMDBPostConfig.performConfiguration(EMDBPostConfig.java:646)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:224)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:193)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:184)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)



Solution:
Follow MOS note "Enterprise Manager Database Control Configuration - Recovering From Errors Due to CA Expiry on Oracle Database 10.2.0.4 or 10.2.0.5 [Video] [ID 1222603.1]" to fix it.