My Oracle Support Banner

WebLogic Admin Server Fails to Start with java.sql.SQLRecoverableException After Moving Metadata Database Repository to a New Server (Doc ID 2208143.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Fusion Middleware - Version 12.1.3.0.0 and later
Oracle WebLogic Server - Version 12.1.3.0.0 and later
Oracle Platform Security for Java - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

The Repository Creation Utility (RCU) successfully installed all required schemas for the Fusion Middleware (FMW) Infrastructure (and other FMW products). Everything has been working.

After moving this Metadata Repository database to a new server,  WebLogic Admin Server is failing to start in an Oracle Fusion Middleware Infrastructure environment with the following error:

org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
Error Code: 17002


Full error stack below:

Caused By: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
Error Code: 17002
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326)
at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:204)
Truncated. see log file for complete stacktrace
Caused By: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:800)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:614)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
Truncated. see log file for complete stacktrace
Caused By: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:475)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:569)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:620)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:239)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1606)
Truncated. see log file for complete stacktrace
Caused By: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
Truncated. see log file for complete stacktrace
>
<Nov 16, 2016 11:24:31 AM EST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED.>
<Nov 16, 2016 11:24:31 AM EST> <Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself down.>
<Nov 16, 2016 11:24:31 AM EST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN.>
Stopping Derby server...
Derby server stopped.

 

Changes

Following the Oracle Documentation to perform steps to move an FMW Repository Database:

Administering Oracle Fusion Middleware (12.1.3)
15.2 Changing the Network Configuration of a Database

Administering Oracle Fusion Middleware (12.2.1.2)
15.2 Changing the Network Configuration of a Database

Administering Oracle Fusion Middleware (12.2.1.3)
15.1 About Changing the Network Configuration

-- Used RMAN to copy an RCU database to another physical server -- the database (including the database name, schema names, and passwords) is an exact copy of the existing RCU database.

-- Related to this error - Confirmed that "Task 6 Change the System Data Source" step has been performed.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.