Node-oracledb in lite mode does not support password validator type 0x939 (NJS-116)

Question

I'm trying to connect an Oracle database with node.js using javaScript.

Requirements - I am using webdriverIo to automate the UI, which uses node.js and JS. In one process, I need to connect to Oracle DB and run a query through automation to get the values. I tried everything but the reaction was the same every time. I'm trying to connect oracle db using Nodejs and JS. I'm using VScode for coding.

Answer 1

For Oracle Database 11gR2 or earlier:

• Add a call to initOracleClient() to enable node-oracledb Thick mode

• Alternatively, you can upgrade the database.

For Oracle Database 12c or later:

• To use Lite Mode: See Find and reset user passwords using the 10G password version. in conclusion:

  1. Ensure that the database initialization parameter sec_case_sensitive_logon is not FALSE. In SQL*Plus, run showparameter sec_case_sensitive_logon as SYSDBA to check the value. (Note that sec_case_sensitive_logonhas been deleted in DB 21c).

  2. If the error still occurs, regenerate the password, such as running ALTER USER x IDENTIFIED BY y if necessary.

• Alternatively, you can use thick mode.