Re: Multiple paths to Oracle DB

In article <9471g3$7ua$1_at_nnrp1.deja.com>,   srijay_at_my-deja.com wrote:
> Is it possible to create multiple paths to an oracle database?
>
> We have a database server running on a machine having two NICs. Only
> one Oracle instance.
>
> I would like to have clients to connect to this DB using either NICs.
> How can this be done using SQLnet.
>
> For Example
>
> DB server IP: 10.0.0.1
> DB server NIC 1 IP: 10.0.0.1
> DB server NIC 2 IP: 10.0.0.2
>
> Current tnsname.ora file entry:
>
> DB1 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = db1.prod)
> )
> )
>
> Thanks,
> Sri.
>
> Sent via Deja.com
> http://www.deja.com/
>

Try ...

DB1 =
  (DESCRIPTION =
    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.2)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = db1.prod)

-Brian

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 18 2001 - 17:49:20 CET