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
Messages: 5
Registered: October 2011
Junior Member

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;
In my client (linux machine) I have this variables

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

$ env |grep ORA
$ set |grep LIB
$ echo $PATH
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



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
Messages: 26766
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.


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 May 22 09:53:42 CDT 2024