Re: Multiple paths to Oracle DB

> 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)
> )
> )
>

One way would be to create a second ALIAS in TNSNAMES.ORA using the second network address.

Daniel A. Morgan Received on Sun Jan 21 2001 - 09:40:55 CET