# How to use tnsnames.ora in oracle node
**URL:** https://discourse.nodered.org/t/how-to-use-tnsnames-ora-in-oracle-node/21499
**Category:** General
**Created:** [10 February 2020 13:40 UTC](https://discourse.nodered.org/t/how-to-use-tnsnames-ora-in-oracle-node/21499 "2020-02-10T13:40:40Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@mhechthz](https://discourse.nodered.org/u/mhechthz)
#### Post date: [10 February 2020 13:40 UTC](https://discourse.nodered.org/t/how-to-use-tnsnames-ora-in-oracle-node/21499/1 "2020-02-10T13:40:40Z")
Hi,
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:
```auto
"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.
---
### Author:  [@mhechthz](https://discourse.nodered.org/u/mhechthz)
#### Post date: [10 February 2020 15:09 UTC](https://discourse.nodered.org/t/how-to-use-tnsnames-ora-in-oracle-node/21499/2 "2020-02-10T15:09:22Z")
Meanwhile I made some tests.
With node.js I can use the full Oracle connection string i.e.
(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = myDBserver)(PORT = 1554))(CONNECT\_DATA =(SID = P54)))
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.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [10 April 2020 15:09 UTC](https://discourse.nodered.org/t/how-to-use-tnsnames-ora-in-oracle-node/21499/3 "2020-04-10T15:09:28Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.