Andrey, The Oracle failover stuff is documented in the
net8 guide and I believe there are some examples as
well. The TNS syntax you are using is not failover but
more or less a load leveling across the listeners. If
you want to do TAF you will need to use this syntax.
ALIAS1.WORLD =
(DESCRIPTIO
Hi Claudio !
Thanks a lot for your reply.
Another question ,please : How can i define SERVICE_NAME = OPS ?
I have 2 instances named OPS1 & OPS2 , so , for example , in listener.ora on
DB2 i have :
LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT =
1526)))
SID_LIST_LISTEN
Hi Claudio !
Thanks a lot for your reply.
Another question ,please : How can i define SERVICE_NAME = OPS ?
I have 2 instances named OPS1 & OPS2 , so , for example , in listener.ora on
DB2 i have :
LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT =
1526)))
SID_LIST_LISTEN
Look at Transparent Application Failover as a Net8 option. You'll need to
determine Oracle Client compatibility / requirements with such!
Ed Haskins
Oracle DBA
Verizon Wireless
-Original Message-
Sent: Wednesday, August 29, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L
Dear
try with:
OPS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526))
(ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526))
)
(CONNECT_DATA = (SERVICE_NAME = OPS))
)
- Original Message -
To: Multiple recipients of list ORACL
Dear list !
I've got an OPS database named OPS with 2 instances OPS1 and OPS2 .
I want the users to connect to OPS1 and ONLY if it is down , to connect to
OPS2.
It's Oracle 8.0.5.1 on NT4.
I put the following lines in clients' tnsnames.ora file :
OPS.world = (DESCRIPTION_LIST =
(DESCRIPT