Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to configure TNSNAMES.ORA to look at multiple IP Addresses for one service
i couldn understand your problem completly (sorry)
(had a brainwash last night :) )
but maybe you could try
<tnsnames>
..
..
(failover=yes)
..
..
(check net8 manual for complete syntx)
hth.
s.kapitza
Me_at_here.net wrote in message news:<3d5d3fe8.2801999_at_news-server.kc.rr.com>...
> 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 Sat Aug 17 2002 - 03:23:45 CDT