Hi all,
I have some difficulties to change language from default to ENGLISH.
Oracle registry NLS_LANG is ENGLISH,
Windows NLS_LANG variable is ENGLISH too.
login.sql script corrected accordingly: System.setProperty("user.lang","en");
All tests show en:us and [american_america.WE8ISO8859P15], but message language is still not ENGLISH, see log file below please.
If I try to change it by JAVA_TOOL_OPTIONS='-Duser.language=en -Duser.region=US' -- it is accepted, but connect is not possible: "Error Message = Locale not recognized"
Any idea?
Best regards,
Sergey
=====================================
C:\Local\DB\Tickets\180123>sql.bat
C:\Local\DB\Tickets\180123>rem set JAVA_TOOL_OPTIONS='-Duser.language=en -Duser.region=US -Dfile.encoding=UTF-8'
C:\Local\DB\Tickets\180123>rem set JAVA_TOOL_OPTIONS='-Duser.language=en -Duser.region=US -Dfile.encoding=WE8MSWIN1252'
C:\Local\DB\Tickets\180123>set JAVA_TOOL_OPTIONS='-Duser.language=en -Duser.region=US'
C:\Local\DB\Tickets\180123>C:\Progs\sqlcl\bin\sql.exe test/test@puma02:1521/DB1STA.sixt.de
Picked up JAVA_TOOL_OPTIONS: '-Duser.language=en -Duser.region=US'
SQLcl: Release 17.4.0 Production on Tue Jan 23 14:14:56 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved.
USER = test
URL = jdbc:oracle:oci8:@puma02:1521/DB1STA.sixt.de
Error Message = Incompatible version of libocijdbc[Jdbc:122010, Jdbc-OCI:121020
USER = test
URL = jdbc:oracle:thin:@puma02:1521/DB1STA.sixt.de
Error Message = Locale not recognized
Username? (RETRYING) ('test/*********@puma02:1521/DB1STA.sixt.de'?)
USER = test
URL = jdbc:oracle:oci8:@puma02:1521/DB1STA.sixt.de
Error Message = Incompatible version of libocijdbc[Jdbc:122010, Jdbc-OCI:121020
USER = test
URL = jdbc:oracle:thin:@puma02:1521/DB1STA.sixt.de
Error Message = Locale not recognized
Username? (RETRYING) ('test/*********@puma02:1521/DB1STA.sixt.de'?)
-- ==== without language settings it is connected, but wuth default system language:
C:\Local\DB\Tickets\180123>sql.bat
C:\Local\DB\Tickets\180123>C:\Progs\sqlcl\bin\sql.exe test/test@puma02:1521/DB1STA.sixt.de
SQLcl: Release 17.4.0 Production auf Di Jan 23 14:28:02 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved. Alle Rechte vorbehalten.
Last Successful login time: Di Jan 23 2018 14:28:07 +01:00
Verbunden mit:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
login.sql wurde in CWD gefunden. Der DB-Zugriff ist f++r login.sql eingeschr+ñnkt.
Passen Sie SQLPATH an, um den Pfad f++r eine umfassende Funktionalit+ñt einzuschlie+ƒen.
en
us
TEST @ puma02:1521/DB1STA.sixt.de >
TEST @ db1sta >alias ls=SELECT object_name FROM user_objects;
TEST @ db1sta >ls
Keine Zeilen gew+ñhlt
TEST @ db1sta >show java
Java Detail
-----------
java.home= C:\Program Files\Java\jre1.8.0_161
java.vendor= Oracle Corporation
java.vendor.url= http://java.oracle.com/
java.version= 1.8.0_161
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------
os.arch= amd64
os.name= Windows 10
os.version= 10.0
path.separator= ;
file.separator= \
line.separator=
user.dir= C:\Local\Scripts\SQLCL
user.home= C:\Users\S3414
user.name= S3414
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------
Classpath=
C:\Progs\sqlcl\bin\sql.exe;C:\Progs\sqlcl\bin\..\lib\.;C:\Progs\sqlcl\bin\..\lib\..;C:\Progs\sqlcl\bin\..\lib\antlr-runtime.jar;C:\Progs\sqlcl\bin\..\lib\commons-codec.jar;C:\Progs\sqlcl\bin
\..\lib\c
ommons-logging.jar;C:\Progs\sqlcl\bin\..\lib\httpclient.jar;C:\Progs\sqlcl\bin\..\lib\httpcore.jar;C:\Progs\sqlcl\bin\..\lib\httpmime.jar;C:\Progs\sqlcl\bin\..\lib\jackson-annotations.jar;C:
\Progs\sql
cl\bin\..\lib\jackson-core.jar;C:\Progs\sqlcl\bin\..\lib\jackson-databind.jar;C:\Progs\sqlcl\bin\..\lib\javax.json.jar;C:\Progs\sqlcl\bin\..\lib\jline.jar;C:\Progs\sqlcl\bin\..\lib\jsch.jar;
C:\Progs\s
qlcl\bin\..\lib\ojdbc8.jar;C:\Progs\sqlcl\bin\..\lib\oracle.dbtools-common.jar;C:\Progs\sqlcl\bin\..\lib\oracle.dbtools.http.jar;C:\Progs\sqlcl\bin\..\lib\oracle.dbtools.jdbcrest.jar;C:\Prog
s\sqlcl\bi
n\..\lib\oracle.sqldeveloper.sqlcl.jar;C:\Progs\sqlcl\bin\..\lib\oraclepki.jar;C:\Progs\sqlcl\bin\..\lib\orai18n-collation.jar;C:\Progs\sqlcl\bin\..\lib\orai18n-mapping.jar;C:\Progs\sqlcl\bi
n\..\lib\o
rai18n-servlet.jar;C:\Progs\sqlcl\bin\..\lib\orai18n-utility.jar;C:\Progs\sqlcl\bin\..\lib\orai18n.jar;C:\Progs\sqlcl\bin\..\lib\orajsoda.jar;C:\Progs\sqlcl\bin\..\lib\osdt_cert.jar;C:\Progs
\sqlcl\bin
\..\lib\osdt_core.jar;C:\Progs\sqlcl\bin\..\lib\stringtemplate.jar;C:\Progs\sqlcl\bin\..\lib\xdb6.jar;C:\Progs\sqlcl\bin\..\lib\xmlparserv2.jar;C:\Progs\sqlcl\bin\..\modules\oracle.xdk\xmlpa
rserv2.jar
;C:\Progs\sqlcl\bin\..\rdbms\jlib\xdb6.jar;C:\Progs\sqlcl\bin\..\jlib\orai18n-mapping.jar
;C:\Progs\sqlcl\bin\..\jlib\orai18n.jar;C:\Progs\sqlcl\bin\..\jdbc\lib\ojdbc6.jar;C:\Progs\sqlcl\bin\..\jdbc\lib\ojdbc7.jar;C:\Progs\sqlcl\bin\..\jdbc\lib\ojdbc8.jar;C:\Progs\sqlcl\bin\..\jl
ib\orai18
n-utility.jar
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- ==== login.sql:
set termout off
define gname=idle
column global_name new_value gname
select lower(user)||'@' ||substr(global_name,1,decode(dot,0,length(global_name),dot-1)) global_name from (select global_name, instr(global_name,'.') dot from global_name);
set sqlprompt '&gname>'
set termout on
set linesize 200
set pagesize 100
column VALUE_COL_PLUS_SHOW_PARAM format A65
column NAME_COL_PLUS_SHOW_PARAM format A40
set sqlprompt "_user '@' _connect_identifier >"
script
var System = Java.type("java.lang.System");
System.setProperty("user.lang","en");
System.setProperty("user.country","us");
System.out.println( System.getProperty("user.lang"));
System.out.println( System.getProperty("user.country"));
/
-- ====
C:\Local\DB\Tickets\180126>sql.bat
C:\Local\DB\Tickets\180126>rem to change language
C:\Local\DB\Tickets\180126>rem set JAVA_TOOL_OPTIONS='-Duser.language=en -Duser.region=US -Dfile.encoding=UTF-8'
C:\Local\DB\Tickets\180126>rem set JAVA_TOOL_OPTIONS='-Duser.language=en -Duser.region=US'
C:\Local\DB\Tickets\180126>rem set LANG=en_US.UTF-8
C:\Local\DB\Tickets\180126>rem to suppress extra empty lnes
C:\Local\DB\Tickets\180126>rem SET STD_ARGS=-Djava.awt.headless=true -Xss10M -Dfile.encoding=UTF-8
C:\Local\DB\Tickets\180126>C:\Progs\sqlcl\bin\sql.exe /nolog
SQLcl: Release 17.4.0 Production auf Fr Jan 26 12:48:11 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved. Alle Rechte vorbehalten.
en <<<<<<<<<<<<<<<<<<<<< !!!!!
us
@ >@.[%NLS_LANG%]
Fehler beim Start in Zeile: 1 in Befehl -
@.[%NLS_LANG%]
Fehlerbericht -
SP2-0310: +ûffnen von Datei nicht m+Âglich: ".[american_america.WE8ISO8859P15]"
@ >
C:\Local\DB\Tickets\180123>sql.batC:\Local\DB\Tickets\180123>rem set JAVA_TOOL_OPTIONS='-Duser.language=en -Duser.region=US -Dfile.encoding=UTF-8'C:\Local\DB\Tickets\180123>rem set JAVA_TOOL_OPTIONS='-Duser.language=en -Duser.region=US -Dfile.encoding=WE8MSWIN1252'C:\Local\DB\Tickets\180123>set JAVA_TOOL_OPTIONS='-Duser.language=en -Duser.region=US'
C:\Local\DB\Tickets\180123>C:\Progs\sqlcl\bin\sql.exe test/test@puma02:1521/DB1STA.sixt.dePicked up JAVA_TOOL_OPTIONS: '-Duser.language=en -Duser.region=US'
SQLcl: Release 17.4.0 Production on Tue Jan 23 14:14:56 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved.
USER = test URL = jdbc:oracle:oci8:@puma02:1521/DB1STA.sixt.de Error Message = Incompatible version of libocijdbc[Jdbc:122010, Jdbc-OCI:121020 USER = test URL = jdbc:oracle:thin:@puma02:1521/DB1STA.sixt.de Error Message = Locale not recognizedUsername? (RETRYING) ('test/*********@puma02:1521/DB1STA.sixt.de'?) USER = test URL = jdbc:oracle:oci8:@puma02:1521/DB1STA.sixt.de Error Message = Incompatible version of libocijdbc[Jdbc:122010, Jdbc-OCI:121020 USER = test URL = jdbc:oracle:thin:@puma02:1521/DB1STA.sixt.de Error Message = Locale not recognizedUsername? (RETRYING) ('test/*********@puma02:1521/DB1STA.sixt.de'?)
-- ==== But without language settings it is connected, but wuth default system language:
C:\Local\DB\Tickets\180123>sql.batC:\Local\DB\Tickets\180123>C:\Progs\sqlcl\bin\sql.exe test/test@puma02:1521/DB1STA.sixt.de
SQLcl: Release 17.4.0 Production auf Di Jan 23 14:28:02 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved. Alle Rechte vorbehalten.
Last Successful login time: Di Jan 23 2018 14:28:07 +01:00
Verbunden mit:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Advanced Analytics and Real Application Testing options
login.sql wurde in CWD gefunden. Der DB-Zugriff ist f++r login.sql eingeschr+ñnkt.Passen Sie SQLPATH an, um den Pfad f++r eine umfassende Funktionalit+ñt einzuschlie+ƒen.enus
TEST @ puma02:1521/DB1STA.sixt.de >
TEST @ db1sta >alias ls=SELECT object_name FROM user_objects;TEST @ db1sta >lsKeine Zeilen gew+ñhlt
TEST @ db1sta >show javaJava Detail-----------java.home= C:\Program Files\Java\jre1.8.0_161java.vendor= Oracle Corporationjava.vendor.url= http://java.oracle.com/java.version= 1.8.0_161--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------os.arch= amd64os.name= Windows 10os.version= 10.0path.separator= ;file.separator= \line.separator=
user.dir= C:\Local\Scripts\SQLCLuser.home= C:\Users\S3414user.name= S3414--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Classpath=C:\Progs\sqlcl\bin\sql.exe;C:\Progs\sqlcl\bin\..\lib\.;C:\Progs\sqlcl\bin\..\lib\..;C:\Progs\sqlcl\bin\..\lib\antlr-runtime.jar;C:\Progs\sqlcl\bin\..\lib\commons-codec.jar;C:\Progs\sqlcl\bin\..\lib\commons-logging.jar;C:\Progs\sqlcl\bin\..\lib\httpclient.jar;C:\Progs\sqlcl\bin\..\lib\httpcore.jar;C:\Progs\sqlcl\bin\..\lib\httpmime.jar;C:\Progs\sqlcl\bin\..\lib\jackson-annotations.jar;C:\Progs\sqlcl\bin\..\lib\jackson-core.jar;C:\Progs\sqlcl\bin\..\lib\jackson-databind.jar;C:\Progs\sqlcl\bin\..\lib\javax.json.jar;C:\Progs\sqlcl\bin\..\lib\jline.jar;C:\Progs\sqlcl\bin\..\lib\jsch.jar;C:\Progs\sqlcl\bin\..\lib\ojdbc8.jar;C:\Progs\sqlcl\bin\..\lib\oracle.dbtools-common.jar;C:\Progs\sqlcl\bin\..\lib\oracle.dbtools.http.jar;C:\Progs\sqlcl\bin\..\lib\oracle.dbtools.jdbcrest.jar;C:\Progs\sqlcl\bin\..\lib\oracle.sqldeveloper.sqlcl.jar;C:\Progs\sqlcl\bin\..\lib\oraclepki.jar;C:\Progs\sqlcl\bin\..\lib\orai18n-collation.jar;C:\Progs\sqlcl\bin\..\lib\orai18n-mapping.jar;C:\Progs\sqlcl\bin\..\lib\orai18n-servlet.jar;C:\Progs\sqlcl\bin\..\lib\orai18n-utility.jar;C:\Progs\sqlcl\bin\..\lib\orai18n.jar;C:\Progs\sqlcl\bin\..\lib\orajsoda.jar;C:\Progs\sqlcl\bin\..\lib\osdt_cert.jar;C:\Progs\sqlcl\bin\..\lib\osdt_core.jar;C:\Progs\sqlcl\bin\..\lib\stringtemplate.jar;C:\Progs\sqlcl\bin\..\lib\xdb6.jar;C:\Progs\sqlcl\bin\..\lib\xmlparserv2.jar;C:\Progs\sqlcl\bin\..\modules\oracle.xdk\xmlparserv2.jar;C:\Progs\sqlcl\bin\..\rdbms\jlib\xdb6.jar;C:\Progs\sqlcl\bin\..\jlib\orai18n-mapping.jar;C:\Progs\sqlcl\bin\..\jlib\orai18n.jar;C:\Progs\sqlcl\bin\..\jdbc\lib\ojdbc6.jar;C:\Progs\sqlcl\bin\..\jdbc\lib\ojdbc7.jar;C:\Progs\sqlcl\bin\..\jdbc\lib\ojdbc8.jar;C:\Progs\sqlcl\bin\..\jlib\orai18n-utility.jar----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- ==== login.sql:set termout offdefine gname=idlecolumn global_name new_value gnameselect lower(user)||'@' ||substr(global_name,1,decode(dot,0,length(global_name),dot-1)) global_name from (select global_name, instr(global_name,'.') dot from global_name);set sqlprompt '&gname>'set termout onset linesize 200set pagesize 100column VALUE_COL_PLUS_SHOW_PARAM format A65column NAME_COL_PLUS_SHOW_PARAM format A40
set sqlprompt "_user '@' _connect_identifier >"
script var System = Java.type("java.lang.System"); System.setProperty("user.lang","en"); System.setProperty("user.country","us"); System.out.println( System.getProperty("user.lang")); System.out.println( System.getProperty("user.country"));/
-- ====C:\Local\DB\Tickets\180126>sql.bat
C:\Local\DB\Tickets\180126>rem to change language
C:\Local\DB\Tickets\180126>rem set JAVA_TOOL_OPTIONS='-Duser.language=en -Duser.region=US -Dfile.encoding=UTF-8'
C:\Local\DB\Tickets\180126>rem set JAVA_TOOL_OPTIONS='-Duser.language=en -Duser.region=US'
C:\Local\DB\Tickets\180126>rem set LANG=en_US.UTF-8
C:\Local\DB\Tickets\180126>rem to suppress extra empty lnes
C:\Local\DB\Tickets\180126>rem SET STD_ARGS=-Djava.awt.headless=true -Xss10M -Dfile.encoding=UTF-8
C:\Local\DB\Tickets\180126>C:\Progs\sqlcl\bin\sql.exe /nolog
SQLcl: Release 17.4.0 Production auf Fr Jan 26 12:48:11 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved. Alle Rechte vorbehalten.
en <<<<<<<<<<<<<<<<<<<<< !!!!!us
@ >@.[%NLS_LANG%]
Fehler beim Start in Zeile: 1 in Befehl -@.[%NLS_LANG%]Fehlerbericht -SP2-0310: +ûffnen von Datei nicht m+Âglich: ".[american_america.WE8ISO8859P15]" @ >