| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: An OPS & tnsnames question
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
-----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))
)
> 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 connectto
> OPS2. > > Is there a solution ? > Thanks a lot in advance ! > > > DBAndrey > > * 03-9254520 > * 053-464562 > * 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: claudio cutelli INET: c_cutelli_at_hotmail.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: 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).Received on Wed Aug 29 2001 - 12:30:33 CDT
 |
 |