Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Issue with sqlcl connecting to database due to long user name

dherzhauNov 9 2021

Hi,
we are on the way to move to a new linux box and we are experience problems with new, very long usernames on the linux box.
If I try to connect to an existing oracle box with sqlcl
I get the following error:
SQLcl: Release 21.1 Production on Tue Nov 09 10:14:20 2021
Copyright (c) 1982, 2021, Oracle. All rights reserved.
USER = TEST01
URL = jdbc:oracle:thin:@desamp01db:1521/ETEST01
Error Message = Connection property: format error: Property is 'v$session.osuser' and value is 'e_mustermann_extern_ohne_vollmac'
Username? (RETRYING) ('TEST01/*********@dtest01db:1521/ETEST01'?)
Version:
Version sql -v
SQLcl: Release 21.1.1.0 Production Build: 21.1.1.113.1704
Environment LINUX 64 bit
I tried to shorten the username, but somehow it dit not work.
$JAVA -Doracle.jdbc.v\$session.osuser={USER:0:29} -Duser.name={USER:0:29} $CUSTOM_JDBC $CYGWIN "${APP_VM_OPTS[@]}" -client $SQLCL_DEBUG -cp "$CPLIST" oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli "$@"
Any ideas appreciated.
Thanks
Dirk

Comments
Post Details
Added on Nov 9 2021
4 comments
1,053 views