Error to connect through node-oracledb ORA-12170: TNS: Connect timeout

Trying to run a simple query using node-oracledb for nodejs. But i am always getting: 2016-09-06T16:25:40.665Z, [request,info] data: ORA-12170: TNS: Connect timeout occurred

  let queryUserId = 'SELECT'
              + ' USER_ID '
              + 'FROM'
              + ' USERS '
              + 'WHERE'
              + ' USER_LOGIN = (:email) ';


  oracledb.getConnection({user: config.User,password: config.Password,connectString: "gcu12304.server.domain.com:1526/BMI"}, function(err, connection) {
    if (err){
      req.log(['info'], err.message);
      res(JSON.stringify({ "name":"Error", "value": err.message }));
      return;
    }

    connection.execute( queryUserId,{ email: req.params.email },function(err, result){
      if (err){
        req.log(['info'], err.message);
        doRelease(connection);
        return;
      }

      req.log(['info'], "Row Count: "+result.rows.length);
      result.rows.length;
      if (result.rows.length>0){
        result.rows.forEach(function(row,index) {
          let rowDB  = {};

          rowDB.user_id = row[0];
          array.push(rowDB);
        });
        doRelease(connection);
        res(JSON.stringify({ "name":"Success", "value": array }));
      }
      else{
        let rowDB  = {};
        rowDB.user_id=0;
        arrayBPMs.push(rowDB);
        res(JSON.stringify({ "name":"Error", "value": array}));
      }
    });
  });

I can connect to the oracle remote server by using telnet and ping command is working successfully from the application server, but the above code is always throwing error: ORA-12170: TNS: Connect timeout occurred, this is the output command from code and telnet.

[user@serverTest]$ node app.js
Error: Error: ORA-12170: TNS:Connect timeout occurred
{"name":"Error","value":"ORA-12170: TNS:Connect timeout occurred\n"}
[user@server Test]$
[user@server Test]$ telnet gcu12304.server.domain.com 1526
Trying xx.xxx.xx.xxx...
Connected to gcu12304.server.domain.com.
Escape character is '^]'.
exit
Connection closed by foreign host.
[user@server Test]$

I have installed the following oracle-client version
oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64
oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64

My node version is v5.7.0 and my Linux is RHEL6

Could you please help me to understand what could be wrong??
Thank you node-oracledb team

[cjbj]

The error isn't node-oracledb specific so you can look for generic advice on this message. There are a lot of Google hits: have you checked out recommendations?

Have you tried using SQL*Plus on the same machine node-oracledb is installed on?

Does 'always' mean 'always' or 'frequently but not always'?

Hi @cjbj. Yep, Whenever i run this tiny application i always get "ORA-12170: TNS: Connect timeout". First i thought it was related to a Firewall issue, but i was able to connect Oracle remote server using telnet.

[cjbj]

Closing due to lack of activity.

For the record, telnet isn't sufficient to check for a usable network to Oracle DB. Use tnsping or sqlplus.

[smalon]

i got the same problem with juve.
have you fixed your problem? Is it a network issue? but i could connect to the database directly on Windows.(navicat for oracle)

[rb442e]

same issue with me too. I am able to connect from SQL developer from my laptop. But while connecting through node-oracledb I am getting below error

ORA-12170: TNS:Connect timeout occurred

[rb442e]

it's working for me now. thanks

[doctypecode]

How it worked?? Can you tell me.

[cjbj]

@doctypecode This is really old issue and the scenario may be very different to yours. Please open a new issue and answer the issue template. Thank you!

[doctypecode]

No need now. I was putting incomplete details in getConnection, my bad. Now I got it right. Below is the correct way of defining connection details.

var con = oracledb.getConnection({
connectString: "HOST:PORT/SID",
user: "username",
password: "password"
},
function(err, Connection){
if(err){
console.log('Error connecting to Db',err);
return;
}
console.log('Connection established');});

[cjbj]

Technically it is "HOST:PORT/SERVICE_NAME". You can't use a SID with that "easy connect" syntax. Service names replaced SIDs many Oracle versions OK.