ops and tns config
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:
(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))
(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:
You want to do what? When? Where?!
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
I'm stmontgo and I approve of this message
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
Click Here to Expand Forum to Full Width