Re: an OPS question - tnsnames

Andrey,

This can be done in several ways. I would configure 2 listener ports and keep the first listener for only OPS1 and the second for OPS2.

You can start listener2 when you want to connect to OPS2. Otherwise shutdown listener2, so that users connect to only to OPS1.

Rama

Andrey Bronfin wrote:

> Dear list !
> I've got an OPS database named OPS with 2 instances OPS1 and OPS2 .
> I want the clients to connect to the instance OPS1 and , if OPS1 becomes
> unavailable , to connect to OPS2 .
> The Oracle version is 8.0.5
> I put the following lines in clients' tnsnames.ora file :
>
> OPS.world = (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526))
> (CONNECT_DATA = (SID = OPS1))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526))
> (CONNECT_DATA = (SID = OPS2))
> )
> )
>
> The problem is that when both the instances are up and running , it looks
> like clients connect to one of the instances randomly .
> How can i ensure that they will try to connect to OPS1 first , and only if
> it is unavailable , they'll connect to OPS2.
>
> Thanks a lot in advance .
>
> DBAndrey
> mailto:andreyb_at_elrontelesoft.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Andrey Bronfin
> INET: andreyb_at_elrontelesoft.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rama Malladi
  INET: rama_at_toyota.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).