ops and tns config
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ops and tns config

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    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

  2. #2
    Join Date
    Mar 2001
    Posts
    144
    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 want to do what? When? Where?!
    Oy vay!

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width