connectString in oracledb node module

Question

I am using oracledb in my Node server for connecting to a TNS Connection Alias. This is my code:

const oracledb = require('oracledb');

    oracledb.getConnection(
        {
            user: "test",
            password: "test",
            connectString: "ADMISSIONS"
        },
        function (err, connection) {
            if (err) {
                logger.error("Error is: " + err.message);
                callback(null, err);
                return;
            } else {
                logger.loud("Connection successful!");
            }
});
}

However, I am getting this error:

TNS:could not resolve the connect identifier specified

I am sure my connectString is wrong. Can anyone please help with what should be the value of connectString if I want to connect to a TNS Connection Alias called Admissions ? Please note this is NOT a localhost/XE connection.

Are you able to connect using this TNS connection alias using other applications, say sqlplus ? This error usually occurs when your entry in TNS entry is wrong/ not consistent with your network. — Malice
– Malice, Commented Aug 15, 2017 at 5:04
This is a TNS related error rather than a 'oracledb' error — Malice
– Malice, Commented Aug 15, 2017 at 5:05
I am able to connect to "Admissions" alias successfully through SQL Developer upon defining "Connecting type" as TNS — HelmBurger
– HelmBurger, Commented Aug 15, 2017 at 5:06
ADMISSIONS or Admissions ? And in which file have you defined the alias. — Malice
– Malice, Commented Aug 15, 2017 at 5:09
"ADMISSIONS". The alias is defined by our organisation and I dont have access to the file (or system) where it is defined. It just appears in the drop down menu of TNS Connection type in SQL Developer — HelmBurger
– HelmBurger, Commented Aug 15, 2017 at 5:13

HelmBurger · Accepted Answer · 2017-08-15 05:38:48Z

0

The issue was outdated tnsnames.ora file. I copied the latest version of tnsnames.ora file into my /etc directory and the connection is successful. Thanks to @Malice

answered Aug 15, 2017 at 5:38

HelmBurger

1,3086 gold badges19 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

connectString in oracledb node module

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related