Am trying to use ADB Agent with Oracle RAC 10.2.0.4
odbc.ini configuration is as follows:
Description=DataDirect 5.2 Oracle Wire Protocol
& tnsnames.ora is configured as follows
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = db_service_name)
In normal situation, adb agent is working fine, as expected. But if one of the DB instance to which adb agent is connected goes down, adb agent is crashing. If I restart adb agent again, it gets connected to the other DB instance and then it continues to work fine.
May I know, why it is not automatically connecting to the other DB instance, please ?
If I have to make any changes to the configuration, please let me know.