Multiple paths to Oracle DB
From: <srijay_at_my-deja.com>
Date: Thu, 18 Jan 2001 15:18:38 GMT
Message-ID: <9471g3$7ua$1_at_nnrp1.deja.com>
Date: Thu, 18 Jan 2001 15:18:38 GMT
Message-ID: <9471g3$7ua$1_at_nnrp1.deja.com>
[Quoted] [Quoted] 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/
Received on Thu Jan 18 2001 - 16:18:38 CET