ops and tns config

Hi Friends,

OS=AIX 4.3.2
DB=ORA 8.1.5 OPS

We have 2 nodes(server)/instances of oracle OPS config.
The design was intended for high availability set-up.
That is, when one node(1)(server)/instance(1) is down, the other
node(2) and instance(2) will take over.

My question is or I am just confused about this set-up.
Does OPS support an Instance level failure? Like ,
If intance(1) is down but the server(1) is ok (or running), can
I automate it so that it will connect to instance(2) on node2 ?
It is possible on OPS or just a configuration in TNS and Listener.

Please help me friends,

Thank you all

it's just a config of the tns.

You would have the tnsnames.ora look something like:

TRAP.oracle.com =
(description =
(LOAD_BALANCE=off)
(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xx1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xx2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xx3)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = )
)
)

You could subsequently turn on load balancing if you want in this as well. Essentially it tries to connect to the first address and if it cannot then it tries the second address. There are a lot of other options as well. Check out:

http://download-east.oracle.com/docs...cfg.htm#473298

you can also configure for select failover so that if a node A dies
any queries executed on that node can be transferred to a surviving node so that the query completes (with a slight delay) and the death of node A is transparent to the user . This is referred to as transparanet application failover (TAF) and can be useful for selects. It does not work with dml or pl/sql

steve

Thank you all my helpful friends :)


Can I test or do it one server only? a none ops set-up?

Say I have one server and install two identical databases
with two diff instance names ORA1 and ORA2. Can I
set up tns net8 for failover on ORA1/ORA2?

Thanks again friends