How to configure TNSNAMES.ORA to look at multiple IP Addresses for one service

I have a Win2000 laptop running Ora 8.1.6. On the road I will use the builtin ethernet port (fixed IP *.*.*.150), in the office the port in the docking station (fixed IP *.*.*.151). When a second machine is trying to connect to the db I would like it to try 150 first then 151 (or at least to try both in some order). In reading the documentation I can find it would seem something like this should work

oradb1 =
 (DESCRIPTION =
   (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.150)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.151)(PORT = 1521))
   )
   (CONNECT_DATA =
(SID = oradb1)

   )
 )

but when I try it it only attempts the first entry and timesout if it is not available.

I have also tried

oradb1 =
 (DESCRIPTION =
   (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.150)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.151)(PORT = 1521))
   )
   (SOURCE_ROUTE = yes)
   (CONNECT_DATA =
(SID = oradb1)

   )
)

With no luck.

Is this configuration possible? Any suggestions?

Thanks Received on Fri Aug 16 2002 - 13:14:01 CDT