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