Handling JDBC connection when v$session.osuser value is more than 30 chars

Question

I am installing a third party application and it set the value of v$session.osuser to the user name when connecting to oracle 12.1. Unfortunately the username of my linux account is 34 chars long and because of this installation is not able to complete.

I can't change the linux account username and also can't edit connection properties programmatically as I don't have access to the application source.

Below are my attempts so far (that didn't work):

1. Updated .bash_profile to trim the value of linux USER property to 29 chars
2. Added two command line argruments, -Doracle.jdbc.v$session.osuser={USER:0:29} and -Duser.name={USER:0:29}

Any other way options that would work?

Answer 1

Try:

java -Doracle.jdbc.v\$session.osuser="my_user" ...

Answer 2

I had the same issue and managed to fix it by setting the user.name value in the JVM. So, add:

-Duser.name=<shorter-name>

... as an option when starting the JVM.