v$session osuser/program issue when sqldeveloper and oracle client installed

In v$session osuser, program are not set when oracle client is used when SQLDeveloper and oracle client are installed on the same machine. This issue doesn’t occur when oracle client software ( is not installed with SQLDeveloper, a workaround the issue is to update the following JDBC jars in $ORACLE_HOME. The jar files can be downloaded from the following URL http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html.

Following jars were replaced in oracle client directory (Note: you may want to backup the original jars before overwriting them):
ojdbc14.jar – $ORACLE_HOME/jdbc/lib
ojdbc14_g.jar – $ORACLE_HOME/jdbc/lib
ojdbc14dms.jar – $ORACLE_HOME/jdbc/lib
ojdbc14dms_g.jar – $ORACLE_HOME/jdbc/lib
orai18n.jar – $ORACLE_HOME/jlib

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.