TNSNAMES.ORA Entry

Hi All,

We have 3 instances. 1,2 and 3. We have directed one process to run only on NODE3. But, if suppose it fails, it should try Instance # 2. We don't want LOAD BALANCE. What will the tnsnames.ora file should look like ? Do I need to use PRECONNECT ?

PROD_EOD.world =

     (DESCRIPTION =

          (FAILOVER = ON)

               (ADDRESS = (PROTOCOL = TCP)(HOST = Instance3)(PORT = XXXX))

               (ADDRESS = (PROTOCOL = TCP)(HOST = Instance2)(PORT = XXXX))

     (CONNECT_DATA =

           (SERVER = DEDICATED)

           (SERVICE_NAME = SVC_ONE)

                (FAILOVER_MODE = 

                (TYPE = select) 

                (METHOD = basic)

                (RETRIES = 180)

                (DELAY = 5)

                )

           )

     )

With PRECONNECT

PROD_EOD.world =

     (DESCRIPTION =

          (FAILOVER = ON)

               (ADDRESS = (PROTOCOL = TCP)(HOST = Instance3)(PORT = XXXX))

               (ADDRESS = (PROTOCOL = TCP)(HOST = Instance2)(PORT = XXXX))