Invalid SSL Certificate
dbuckOct 16 2012 — edited Oct 18 2012Let me start by laying out some system info:
Windows 2008
OEM 11.1.0.1
Oracle DB 11.2.0.2
I have recently been unable to log in to my previously functioning Enterprise Manager due to an "Invalid Certificate" error message in the browser (I have tried both IE and Chrome and had other users verify this is not a local browser issue).
I started by verifying that my OMS and Agent were good with the below commands:
D:\oracle\Middleware\oms11g\BIN>emctl status oms -details
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :
Console Server Host : server.host.com
HTTP Console Port : 7788
HTTPS Console Port : 7799
HTTP Upload Port : 4889
HTTPS Upload Port : 1159
OMS is not configured with SLB or virtual hostname
Agent Upload is unlocked.
OMS Console is unlocked.
Active CA ID: 1
D:\oracle\Middleware\oms11g\BIN>emctl status oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle Management Server is Up
D:\oracle\Middleware\oms11g\BIN>cd ../../agent11g/bin
D:\oracle\Middleware\agent11g\BIN>emctl status agent -detail
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 11.1.0.1.0
OMS Version : 11.1.0.1.0
Protocol Version : 11.1.0.0.0
Agent Home : D:\Oracle\Middleware\agent11g
Agent binaries : D:\Oracle\Middleware\agent11g
Agent Process ID : 8604
Agent URL : https://server.host.com:3872/emd/main/
Repository URL : https://server.host.com:1159/em/upload
Started at : 2012-10-15 14:46:51
Started by user : SYSTEM
Last Reload : 2012-10-15 14:46:51
Last successful upload : 2012-10-16 08:11:18
Total Megabytes of XML files uploaded so far : 100.93
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 22.68%
Last successful heartbeat to OMS : 2012-10-16 08:22:06
---------------------------------------------------------------
Agent is Running and Ready
I then checked the status of the dbconsole:
D:\oracle\product\11.2.0\dbhome_1\BIN>emctl status dbconsole
OC4J Configuration issue. D:\oracle\product\11.2.0\dbhome_1/oc4j/j2ee/OC4J_DBConsole_server.host.com_SID not found.
I should also tell you that the ORACLE_HOME and ORACLE_UNQNAME variables are set to the appropriate values.
Since receiving this error I have been searching for a fix and have only been able to come up with recreate the repository, which leads me to my actual questions...
What are the repercussions of recreating the repository for an existing OEM database? Will I have to recreate all the jobs that currently exist in my unreachable OEM instance? Is there a "better" way for me to resolve this issue?