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_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = OPS2)))
How can i tranlate that "(SID_DESC = (SID_NAME = OPS2))" into "SERVICE_NAME
= OPS" ?
Thanks a lot !
DBAndrey
* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]
-----Original Message-----
Sent: Wednesday, August 29, 2001 6:36 PM
To: Multiple recipients of list ORACLE-L
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 ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 5:15 PM
> 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 =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526))
> (CONNECT_DATA = (SID = OPS1))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526))
> (CONNECT_DATA = (SID = OPS2))
> )
> )
>
> This works perfectly fine except for the case when OPS1 instance is down ,
> but the listener is up.
> Then clients try to connect to OPS1 and fail - "Oracle not available" .
> When i bring the listener on OPS1 host down - everybody perfectly connect
to
> OPS2.
>
> Is there a solution ?
> Thanks a lot in advance !
>
>
> DBAndrey
>
> * 03-9254520
> * 053-464562
> * mailto:[EMAIL PROTECTED]
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Andrey Bronfin
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: claudio cutelli
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Andrey Bronfin
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
