Target Database shows Down from OMS - Database Enabled with SSL
For Oracle Database in Enterprise Manager, the status shows as Down. But Its really up in reality.
Connection from OMS is successful.
We did import the Wallet to OMS as well as on agent side
emctl setproperty agent -name connectionTrustStoreType -value PKCS12
emctl setproperty agent -name connectionTrustStoreLocation -value /XYZ/ewallet.p12
emctl setproperty agent -name connectionTrustStorePassword -value ABC
Same applies to Key Store
Did bounce the agent, Did the clearstate agent, Did the secure agent
./emctl getmetric agent XYZ,oracle_database,Response shows
Status,State,oraerr,Archiver,DatabaseStatus,ActiveState
0,UNKNOWN,Failed to connect: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection,UNKNOWN,UNKNOWN,UNKNOWN