hammerDB crashes with only 2 virtual users using Oracle on Linux

[arizona-1995]

hi,
Trying to run performance tests using hammerDB installed on my Windows 11 laptop against an Oracle 19c database running on Linux and it keeps crashing even with only 2 virtual users. Here's more specifics regarding my specs

Client server
OS: Windows 11
Memory: 32 GB
CPU: 14 cores

Database server
OS: Linux
Version: Oracle 19c

Does anyone have any suggestions? Thanks

[sm-shaw]

check the release notes page 1of the documentation https://www.hammerdb.com/docs/ch01s01.html#d0e58

1.5. Known Third-Party Driver Issues

HammerDB has a dependency on 3rd party driver libraries to connect to the target databases. The following are known issues with some of the 3rd party drivers that HammerDB uses.
1.5.1. Oracle on Windows: Oracle Bug 12733000 OCIStmtRelease crashes or hangs if called after freeing the service context handle

If you are running HammerDB against Oracle on Windows there is long established bug in Oracle that can cause application crashes for multi-threaded applications on Windows.This bug can be investigated on the My Oracle Support website with the following reference. Bug 12733000 OCIStmtRelease crashes or hangs if called after freeing the service context handle. To resolve this Oracle issue add the following entry to the SQLNET.ORA file on your HammerDB client.

SQLNET.AUTHENTICATION_SERVICES = (NTS)
DIAG_ADR_ENABLED=OFF 
DIAG_SIGHANDLER_ENABLED=FALSE
DIAG_DDE_ENABLED=FALSE

[sm-shaw]

Note its the Oracle windows client code that is the issue here and not the Linux server. Also note the Linux server client does not have this issue even though on the HammerDB side the client interface code is identical so this is a very long standing Oracle bug.

[arizona-1995]

hi, @sm-shaw thanks for the reply and suggestion. I'm aware of the suggested solution. However, I didn't think it applied to me because it mentions "Oracle on Windows" and my database is running on Linux. Nevertheless, I just tried to create 100 warehouses using 10 virtual users using the suggested solution and it crashed almost immediately. I even restarted the client machine after saving the sqlnet.ora file. Any other suggestions? Could it be possible that the Oracle instance/server needs to be restarted too? Thanks again.

[sm-shaw]

The bug is in the Oracle client on Windows, the database being tested can be on any platform and does not need to be restarted. To troubleshoot, run the build with 1 virtual user and then run it with 2. If it crashes with 2 it is very likely to be this issue. Please double check your configuration on the HammerDB Windows client and make sure your sqlnet.ora file includes the entries above and is in the correct location. A common error is not having the sqlnet.ora in the correct TNS_ADMIN location.

This issue crops up from time to time and is noted on page 1 of the release notes. We have not as yet had another Oracle client crashing on Windows issue reported (in over 1/2 million downloads from GitHub alone) apart from this specific bug that is in the Oracle Windows client and is Oracle's responsibility and not HammerDB so please double check your configuration.

[arizona-1995]

@sm-shaw Ok I think I updated the wrong sqlnet.ora file. Turns out that TNS_ADMIN points to a network location which I don't appear to have access to. I'll have to wait till Monday to submit a request to have this file changed. Will keep you posted. Thanks.

[arizona-1995]

@sm-shaw I was able to get to the correct sqlnet.ora file and update as requested. It fixed the problem!