patch_oim_wls.sh 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:

Symptoms

The patch_oim_wls.sh 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.host}:${mdsDB.port}/${mdsDB.serviceName}
    [exec] EWBUG28698057: fetchConnection() getDriverInfo: OracleDriver: buildDate=Tue_Dec_13_06:08:31_PST_2016,driverVersion=12.2.0.1.0,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.host}:${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(UCPErrorHandler.java:456)

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

Cause

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