Home » RDBMS Server » Performance Tuning » ORA-12705: Cannot access NLS data files or invalid environment specified with jmeter test (Oracle Database 19.7, jmeter 5.3)
ORA-12705: Cannot access NLS data files or invalid environment specified with jmeter test [message #683090] Tue, 01 December 2020 13:02 Go to next message
estonolose
Messages: 5
Registered: October 2011
Junior Member
Hello,

I have trying to execute a simple test with jmeter in Oracle 19.7 database. This is my lang configuration in database

SQL> select * from nls_database_parameters;
...
NLS_NCHAR_CHARACTERSET  AL16UTF16
NLS_CHARACTERSET    AL32UTF8
NLS_TERRITORY   AMERICA
NLS_LANGUAGE    AMERICAN
In my client (linux machine) I have this variables

$ export LANG=en_us
$ echo $LANG
en_us
$ echo $NLS_LANG
American_America.UTF8
I have configured instant client and I used sqldeveloper launch from here without problems.

$ env |grep ORA
ORACLE_HOME=/usr/lib/oracle/19.3/client64
$ set |grep LIB
LD_LIBRARY_PATH=/usr/lib/oracle/19.3/client64/lib
$ echo $PATH
...:/usr/lib/oracle/19.3/client64/bin
and I execute this test

$ ./jmeter -n -t ../prueba_select_jdbc.jmx -l /tmp/resultado -e -o /tmp/prueba_jmeter -Jthreads=10 -Jloop=5 -Duser.country=US -Duser.language=en
Creating summariser <summary>
Created the tree successfully using ../prueba_select_jdbc.jmx
Starting standalone test @ Tue Dec 01 19:57:57 CET 2020 (1606849077184)
Waiting for possible Shutdown/StopTestNow/HeapDump/ThreadDump message on port 4445
summary +      3 in 00:00:04 =    0.7/s Avg:    89 Min:    70 Max:   129 Err:     3 (100.00%) Active: 1 Started: 3 Finished: 2
summary +      2 in 00:00:04 =    0.5/s Avg:    83 Min:    82 Max:    84 Err:     2 (100.00%) Active: 0 Started: 5 Finished: 5
summary =      5 in 00:00:08 =    0.6/s Avg:    87 Min:    70 Max:   129 Err:     5 (100.00%)
Tidying up ...    @ Tue Dec 01 19:58:05 CET 2020 (1606849085631)
... end of run
and the error that i allways get is

null 0/java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1\nORA-12705: Cannot access NLS data files or invalid environment specified\n)
I have copied the ojdbc8.jar into the jmeter/lib directory. Into the JDBC Driver class I have oracle.jdbc.OracleDriver and the database URL is

jdbc:oracle:thin:@server-cluster-scan:1521/serv_todo


Regards




Re: ORA-12705: Cannot access NLS data files or invalid environment specified with jmeter test [message #683091 is a reply to message #683090] Tue, 01 December 2020 21:27 Go to previous message
BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal
Senior Member
I know of a way to collect MORE details that should allow you to determine why the error gets thrown.
Prior to issuing the jmeter command, issue the commands below
script > /tmp/collect_trace.txt
strace ./jmeter -n -t ../prueba_select_jdbc.jmx -l /tmp/resultado -e -o /tmp/prueba_jmeter -Jthreads=10 -Jloop=5 -Duser.country=US -Duser.language=en

Doing as above will produce a LARGE, Large, large amount of debugging details
You terminate the script command & close out /tmp/collect_trace.txt file by issuing CTRL-D
/tmp/collect_trace.txt file will show EVERY file OPEN command that was issued.
Near the end of this file should be OPEN statements showing the directory & filenames jmeter is looking for.
To stop the error you need to place the correct file where jmeter can find it & has OS permission to open it.

HTH & YMMV

P.S. You can practice this approach by starting sqlplus to see how sqlplus tries to open glogin files from various directories.
Previous Topic: SQL_Text on SQL Profile
Next Topic: TKPROF showing wrong totals for non-recursive statements
Goto Forum:
  


Current Time: Wed Feb 24 14:59:13 CST 2021