java.sql.SQLException: Wrong arguments for proxy session: Unrecognized format for PROXY_USER_NAME When Using Oracle JDBC Proxy Authentication With JDBC 19c (Doc ID 2893394.1)

Last updated on SEPTEMBER 04, 2022

Applies to:

Symptoms

After upgrading from WebLogic 12.2.1.3 to 12.2.1.4, it is found that any user with a "." (period aka dot - ascii 46) in the user name will encounter the  error

when the application attempts to use the Oracle JDBC Proxy Authentication solution using OracleConnection#openProxySession method with PROXYTYPE_USER_NAME as described in Chapter 10 of the Oracle JDBC Developer's Guide and Reference.

The upgrade of Oracle JDBC driver version from 12.2.0.1 to 19.3.0.0 was identified as the cause of this error. With JDBC 19c, the error occurs while the exact same code has no error with the 12.2.0.1 driver.
The error is not WebLogic specific; it can be reproduced on Tomcat as well. 

Cause

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