Oracle RAC conneciton Issue
Hi Sir,
Problem Description: Always I am not able to connect to oracle rac database. some times I am able to connect and sometimes I am not able to.
Its two node rac databse, and jdbc connection that development team is using
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = <numeric ipaddress1>)(PORT = 1800))(ADDRESS = (PROTOCOL = TCP)(HOST = <numeric ipaddress2>))(PORT = 1800))(LOAD_BALANCE = yes)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ABC)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))
Error message : The Network Adapter could not establish the connection
Every time I am ablet connect when put the following entries in /etc/hosts file.
<numberic ipaddress1> <hostname1>
<numberic ipaddress2> <hostname2>
Database version: oracle 10g enterprise endition 10.2.0.4.0 64 bit
I find that...If the DNS is not 100% reliable then this can be done by ensuring the hosts files contain the name resolution information.
But...my application is a desktop (java swings) application...I have to ask all users to set the host details in /etc/hosts file. I am thinking which is not fesible solution..Please help is there any setting that I can do in server side.