Search code examples
node.jsoracle-databaseexpressloopbackjsnode-oracledb

Oracle DB active/passive setup with Node.js


I want to understand how the Oracle db active passive connection works with Node js. Currently my project is using loopback Oracle connector node module. What configuration I have to do in db or app or env level to complete the setup.


Solution

  • Asuming you connect through a connection pool you don’t need to do anything since the connection pool should take care of failed connections, as long as one succeeds.

    This ofcourse assumes a correct sqlnet configuration in the connection pool, that by itself should be prefixed by a vip.