My Oracle Support Banner Fails With Error "IO Error: Invalid connection string format, a valid format is: "host:port:sid" (Doc ID 2508308.1)

Last updated on AUGUST 11, 2021

Applies to:

Identity Manager - Version and later
Information in this document applies to any platform.


The fails with error "IO Error: Invalid connection string format, a valid format is: "host:port:sid". The detailed error trace is shown below.

[exec] EWBUG28698057: fetchConnection() getDriverInfo: userName=<MDS_SCHEMA_USER>,jdbcURL=jdbc:oracle:thin:@${}:${mdsDB.port}/${mdsDB.serviceName}
    [exec] EWBUG28698057: fetchConnection() getDriverInfo: OracleDriver: buildDate=Tue_Dec_13_06:08:31_PST_2016,driverVersion=,jdbcVersion=JDBC 4.2
    [exec] upgradeutil logger: java.util.logging.Logger@60438a68
    [exec] m_loggerjava.util.logging.Logger@60438a68
    [exec] Jan 09, 2019 11:28:49 AM oracle.mds.internal.persistence.db.JDBCConnectionManagerImpl fetchConnection()
    [exec] ERROR: MDS-90031: The JDBC resource of metadata db repository "userName=<MDS_SCHEMA_USER>,jdbcURL=jdbc:oracle:thin:@${}:${mdsDB.port}/${mdsDB.serviceName}" cannot be found.
    [exec] java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Invalid connection string format, a valid format is: "host:port:sid" 
    [exec] at oracle.ucp.util.UCPErrorHandler.newSQLException(

Run script to apply any OIM 12c bundle patch by following instructions in patch README.html file.


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

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