Is ONS configuration needed For Single Instance Oracle DB? (Doc ID 3012644.1)

Last updated on MARCH 25, 2024

Applies to:

Goal

Currently, there is a RAC database for a DEV environment. The below configuration is being used on the JDBC side to connect to DB to take care of Fast Connection Failover.

db.common.url=jdbc:oracle:thin:@${dbserver}-scan.com:<port>/${dbname}
db.common.ons=nodes=${onsdbserver1}:6200,${onsdbserver2}:6200,${onsdbserver3}:6200
db.oraclepool.username=$(username}
db.oraclepool.password.encrypted=${encrypted_password}
db.oraclepool.ons=${db.common.ons}
db.oraclepool.maxIdleTime=300
db.oraclepool.inactiveConnectionTimeout=300
db.oraclepool.abandonedConnectionTimeout=0
db.oraclepool.timeToLiveConnectionTimeout=0
db.oraclepool.timeoutCheckInterval=60
db.oraclepool.connectionWaitTimeout=20
db.oraclepool.initialPoolSize=0
db.oraclepool.maxPoolSize=5
db.oraclepool.minPoolSize=0

The plan is to convert the DEV DBs to a single instance.
Can the above JDBC configuration still be used for single instance DB, or does the ONS setting need to be removed?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.