OIF 11g: Managed Server Down - database issue (Doc ID 1172773.1)

Last updated on AUGUST 03, 2016

Applies to:

Oracle Identity Federation - Version 11.1.1.1 and later
Information in this document applies to any platform.
The Enterprise Manager console shows EM 11g with Fusion Middleware wls_oif1 down in red? How do I troubleshoot this issue?


Symptoms

After running the remote Diagnostic Agent to gather operation logs, expand the resulting archive and browse to
oif2rda__index.htm (or simiar index file) and peruse the logs at the time period of the incident.
As per:
Running RDA Against Oracle Fusion Middleware 11g (Note.853437.1)
Browse to Logs then:
               + $DOMAIN_HOME/servers/wls_oif1/logs
                     # access.log
                     # wls_oif1-diagnostic.log
Checking this log -->           # wls_oif1.log 
It is observed that JDBC connection is failing? 
####<Jul 29, 2010 5:49:53 AM EDT> <Info> <JDBC> <server.host.com> <wls_oif1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1280396993214> <BEA-001128> <Connection for pool "someDatasource2" closed.>
####<Jul 29, 2010 5:51:40 AM EDT> <Error> <Health> <server.host.com> <wls_oif1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1280397100821> <BEA-310001> <Subsystem JDBC has failed. Setting server state to Failed.>
####<Jul 29, 2010 5:51:40 AM EDT> <Critical> <WebLogicServer> <server.host.com> <wls_oif1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1280397100823> <BEA-000385> <Server health failed. Reason: health of critical service 'JDBC' failed>
####<Jul 29, 2010 5:51:40 AM EDT> <Notice> <WebLogicServer> <server.host.com> <wls_oif1> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1280397100825> <BEA-000365> <Server state changed to FAILED>
It worked before, so health checking with RDBMS team indicates that indeed there was an issue on the database side.

Changes

Database issue.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms