TNS: no listener error when running knex bookshelf oracledb

Kapil Kapani

Hi,

I am trying to get the combination of KNEX, BOOKSHELF and Oracle Database work in my environment. Could you please help with the installation.

Here is what I have done

1. Installed oracledb via npm

2. Downloaded the Client Library

3. Set the environment paths

4. Knex connection string

The error that I get when migrating the latest tables after this setup is: TNS: NO Listener

My database is running fine as I can connect via sql developer at the same time.

Christopher Jones-Oracle

The installation of node-oracledb is fine; the error you are getting is from the database itself, meaning node-oracledb is running OK and trying to connect to a database.   Try running one of the node-oracledb samples https://github.com/oracle/node-oracledb/tree/master/examples (i.e. without Knex) so you can work out the correct connect string (see https://github.com/oracle/node-oracledb/blob/master/examples/dbconfig.js).  Once you have this working, then you can see what parameter values Knex needs.

Kapil Kapani

Hi cj,

Thanks a lot for your reply.

The problem is fixed now. Looks like for some reason I was able to access via sqldeveloper but not node. I just restarted all my database services and it was fine after that