OraFAQ Forum: Performance Tuning » ORA-12705: Cannot access NLS data files or invalid environment specified with jmeter test

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12705: Cannot access NLS data files or invalid environment specified with jmeter test [message #683090]

Tue, 01 December 2020 13:02

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

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

$ 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.

Code: [Select all] [Show/ hide]

$ 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

Code: [Select all] [Show/ hide]

$ ./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

Code: [Select all] [Show/ hide]

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

Report message to a moderator

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

BlackSwan
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.

HTH & YMMV

P.S. You can practice this approach by starting sqlplus to see how sqlplus tries to open glogin files from various directories.

Report message to a moderator

Previous Topic:	SQL_Text on SQL Profile
Next Topic:	TKPROF showing wrong totals for non-recursive statements

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 18:44:55 CDT 2025