Ojdbc8.jar To Connect To Oracle 12.1 And 12.2 Reports "Invalid Oracle URL Specified" (Doc ID 2552029.1)

Last updated on MAY 25, 2023

Applies to:

Symptoms

When connecting to Oracle database versions 12.1 and 12.2 using 12.2 ojdbc8.jar file with "(" character as part of the password, the connection fails with following exception :

java.sql.SQLException: Invalid Oracle URL specified 
        at oracle.jdbc.driver.PhysicalConnection.parseUrl(PhysicalConnection.java:1311) 
        at oracle.jdbc.driver.PhysicalConnection.readConnectionProperties(PhysicalConnect ion.java:1046) 
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:693) 
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:447) 
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:38 ) 
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691) 
        at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:390) 
        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:279) 
        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:202) 

It works fine when using standard characters in the password. No issues with either database version while using 12.1.0.2 ojdbc7.jar.

Changes

Cause

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