Connectivity with load balancer names in Oracle
Connection string in Oracle Server Active Passive setup
In active Passive OS cluster setup, we use load balancer names for connecting the databases on active hosts.
For example, we have AIX /HP OS clustering is there on two nodes. DB will be running on any one node , the other (second node) node will be acted as passive.
In this kind of setup OS/NW level load balancer configuration is required.
Advantages of Active/Passive OS Configuration:
- High Availability: By using this setup, uninterrupted service for your customers is achievable even during planned or unplanned outages.
- Fault Tolerance: The ability to deal with service failures ensures minimal impact on your business revenue and reputation.
Verification when we have connectivity issue.
| $sqlplus /nolog
SQL>connect DB_MON@ORA-QA.ajara.com:1521/ORCLT enter password: SQL> |
Here are the details
- DB_MON — username in the database
- ORA-QA.ajara.com — Load balancer name
- 1521 — Default Port #
- ORCLT — Database name
See also
- Unable to connect with EZconnect using sqlplus
- Connection issue in between DB Nodes and Cell Nodes
- How to connect the Database as sysdba in windows
- support.oracle.com
- oracle.com