How to use tnsnames.ora in oracle node


I found finally the only oracle node that seems to work on windows 7: node-red-contrib-oracledb-mod

But now I fail to connect to the data base because the tnsnames.ora is not found (I think so). I get following error:

"Oracle-server error connection to myDBserver:1554/P54: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"

PATH-variables for TNS_HOME and TNS_ADMIN are set properly and tnsnames.ora is in the admin directory.

Has anyone any idea of how to solve this? Getting Oracle work is a really hard task.

Thanks in advance.

Meanwhile I made some tests.

With node.js I can use the full Oracle connection string i.e.


via the dbconfig.js but in node-red I have to specifiy server, port and database, i.e. I cannot hand over the full configuration.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.