Error getting connection from pooljava.sql.SQLException: Invalid Oracle URL specified Error Attempting to Start Infrastructure Server (Doc ID 1504133.1)

Last updated on MAY 24, 2023

Applies to:

Symptoms

On OFSAAI 7.2.7, after creating a new migrated instance via clone, when attempting to start the Infrastructure Server, the server does not start properly, and the following error occurs in the SMService.log:

ERROR
UMMLOG] Nov 5,12 10:05:24 : [CONNECTIONPOOL]No connections in free pool. Creating new connection.
[UMMLOG] Nov 5,12 10:05:25 : [DACCONNECTIONPROVIDER]Error getting connection from pooljava.sql.SQLException: Invalid Oracle URL specified
[UMMLOG] Nov 5,12 10:05:25 : [DACCONNECTIONPROVIDER]
java.sql.SQLException: Invalid Oracle URL specified
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:383)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)

The issue can be reproduced at will with the following steps:

1. Follow the steps in How to Perform Full Migration / Cloning of OFSAA Solution from Server to Another.
2. Attempt to start Infrastructure server: ./reveleusstartup.sh

Cause

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