\ **Category:** General\ **Created:** [2 November 2020 11:58 UTC](https://discourse.nodered.org/t/connect-to-multiple-oracle-dbs/35204 "2020-11-02T11:58:54Z")\ **Posts on this page:** 5\ **Page:** 1

**Author:** ![rey](https://avatars.discourse-cdn.com/v4/letter/r/b77776/32.png) [@rey](https://discourse.nodered.org/u/rey)\ **Post date:** [2 November 2020 11:58 UTC](https://discourse.nodered.org/t/connect-to-multiple-oracle-dbs/35204/1 "2020-11-02T11:58:55Z")

Hi, I make use of the node-red-contrib-oracledb-mod plugin. I can connect to an oracle DB and run queries. However I have no idea how to access another oracle DB within the same flow, or even in a different flow in the same nodered instance. Whenener I change the connection prtoperties of one instance of the oracledb - node, the connection properties of all other oracledb nodes are overwritten as well. So my questions is: How can I retrieve data from 2 different oracle databases within the same flow ? Thanks best regards rey ---

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\ **Post date:** [2 November 2020 12:26 UTC](https://discourse.nodered.org/t/connect-to-multiple-oracle-dbs/35204/2 "2020-11-02T12:26:46Z")

I don't know that node, but I would expect that when you configure it you have to setup a config to point to the database. If so then to add another one don't edit the existing one but instead look for an Add New in the dropdown list of databases. For instance in the mysql node I can select ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/b/cb0caa4b7ead893e9f293ec111c21cec9a810a1f.png) ---

**Author:** ![rey](https://avatars.discourse-cdn.com/v4/letter/r/b77776/32.png) [@rey](https://discourse.nodered.org/u/rey)\ **Post date:** [2 November 2020 14:32 UTC](https://discourse.nodered.org/t/connect-to-multiple-oracle-dbs/35204/3 "2020-11-02T14:32:58Z")

thanks - that worked. I feel a bit stupid now ☹ ---

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\ **Post date:** [2 November 2020 14:58 UTC](https://discourse.nodered.org/t/connect-to-multiple-oracle-dbs/35204/4 "2020-11-02T14:58:15Z")

Don't worry, most things are simple once you know how 🙂 ---

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\ **Post date:** [16 November 2020 14:58 UTC](https://discourse.nodered.org/t/connect-to-multiple-oracle-dbs/35204/5 "2020-11-16T14:58:18Z")

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