NJS-116: password verifier type 0x939 is not supported by node-oracledb in Thin mode

[venkateshkolisetty-ctl]

1. What versions are you using?

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

process.platform: win32
process.version: v18.16.0
process.arch: x64
require('oracledb').versionString: 6.0.2
require('oracledb').oracleClientVersionString:

Uncaught:
Error: NJS-089: getting the Oracle Client version is not supported by node-oracledb in Thin mode
    at throwErr (~\node_modules\oracledb\lib\errors.js:591:10)
    at Object.throwNotImplemented (~\node_modules\oracledb\lib\errors.js:600:3)
    at get oracleClientVersionString [as oracleClientVersionString] (~\node_modules\oracledb\lib\oracledb.js:1064:14) {
  code: 'NJS-089'

2. Is it an error or a hang or a crash?

Error

3. What error(s) or behavior you are seeing?

Process exited with code 1
Uncaught Error Error: NJS-116: password verifier type 0x939 is not supported by node-oracledb in Thin mode
    at throwErr (~\node_modules\oracledb\lib\errors.js:591:10)
    at encode (~\node_modules\oracledb\lib\thin\protocol\messages\auth.js:208:20)
    at _encodeMessage (~\node_modules\oracledb\lib\thin\protocol\protocol.js:105:20)
    at _processMessage (~\node_modules\oracledb\lib\thin\protocol\protocol.js:146:18)
    at connect (~\node_modules\oracledb\lib\thin\connection.js:547:28)
    at processTicksAndRejections (internal/process/task_queues:95:5)

4. Include a runnable Node.js script that shows the problem.

import * as oracledb from 'oracledb';
oracledb.createPool({
                user: 'username'
                , password: 'password'
                , connectString: 'host:port/sid'
            }).then((pool) => {
                resolve(pool);
            }).catch((err) => {
                reject(err);
            });

[cjbj]

The first one, NJS-089 is obvious: don't call that function in Thin mode. Remove the call, or change to Thick mode.

The second one, NJS-116, is answered in https://stackoverflow.com/a/76436179/4799035

[venkateshkolisetty-ctl]

I am trying to connect to Oracle 12.2.0.1.0 and the verified that the parameter sec_case_sensitive_logon is set to true.
Even though the configuration is supported by the Thin mode, I am getting error.

[cjbj]

Regenerate your password as per the steps on SO.

[venkateshkolisetty-ctl]

I tried regenerating the password but I am getting same error.
I also tried connecting to 3 different databases having same configuration and I see same error.

[sosoba]

Try to run a fresh database via docker compose:

services:
  XEPDB1:
    image:  container-registry.oracle.com/database/express:21.3.0-xe
    ports:
      - '1521:1521'
    environment:
      ORACLE_PWD: 'oracle'

and connect as:

await oracledb.getConnection({
  user: 'PDBADMIN',
  password: 'oracle',
  connectString:'localhost/XEPDB1',
});

[sharadraju]

Hi @venkateshkolisetty-ctl, It seems that the username used to connect to Oracle Database is using a less secure 10G password verifier for some reason.
Can you run the following query and see if your username is listed in the result:

SELECT USERNAME FROM DBA_USERS WHERE ( PASSWORD_VERSIONS = '10G 'OR PASSWORD_VERSIONS = '10G HTTP ')
AND USERNAME <> 'ANONYMOUS';

You might want to check the following documentation to upgrade your password verifier in Oracle Database - Resetting Oracle Database password verifiers.

[venkateshkolisetty-ctl]

@sharadraju , my username IS LISTED in the result. What is the supported version for the Thin mode to work?

[sharadraju]

Node-oracledb's Thin mode supports 11G and higher password verifiers, which are more secure.
To reset your password verifier to use more secure versions in your Oracle Database, please follow the steps listed here - Resetting Oracle Database password verifiers.

[venkateshkolisetty-ctl]

Thank you