Skip to Main Content
Forums

Programming Languages & Frameworks

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

TLS connection to Oracle DB using node-oracledb with PEM file

ckantzerApr 25 2024 — edited Apr 25 2024

Hello,

I'm trying to connect to Oracle 19c using node-oracledb in thin mode using a PEM file. However, the PEM file my DBA's provided does not have a password associated with it.

My config is below:

config = {
            connectString,
            user,
            password,
            configDir,
            walletLocation,
            walletPassword
        };

where connectString is the tnsnames.ora alias, configDir is the location of the tnsnames.ora file and walletLocation is the location of the PEM file.

No matter what I put for walletPassword ("", “ ”, “NONE” or removing the walletPassword param altogether) I get the following error when executing a query

[Oracle executeQuery] Error: NJS-505: unable to initiate TLS connection. Please check if wallet credentials are valid

From the logs it looks like creating the pool is successful.

If I update the tnsnames.ora to use the standard non TLS port I'm able to connect and execute a query.

Does node-oracledb in thin mode support TLS connections with a PEM that does not have a password? Is this an issue with my config or a setup issue with Oracle 19c?

node-oracledb version:

"oracledb": "^6.0",

Thanks!
This post has been answered by ckantzer on May 16 2024
Jump to Answer

Comments

Post Details

Added on Apr 25 2024
#javascript, #node-js
3 comments
1,236 views
1 mention