Re: service name, sid ..

2003-07-07 Thread AK
Poder To: Multiple recipients of list ORACLE-L Sent: Thursday, July 03, 2003 10:49 AM Subject: Re: service name, sid .. Hi! There's actually more: db_name - identifies database name, has to be the same what is stated in controlfile (using create database or create

RE: service name, sid ..

2003-07-07 Thread Goulet, Dick
]Sent: Monday, July 07, 2003 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: Re: service name, sid .. Tanel, Thanks for elaborate information , I really liked it . Still why do u need to provide db name in tnsnames, all one should know is which instance to connect . Instance know

RE: service name, sid ..

2003-07-07 Thread Stephane Paquette
-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Monday, July 07, 2003 4:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: service name, sid . AK, You can make it as simple or complicated as you want. Personally I prefer the KISS principle

RE: service name, sid ..

2003-07-07 Thread Luis deUrioste
The laughof the day . the fecal matter hits the rotary oscillator. -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED]Sent: Monday, July 07, 2003 2:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: service name, sid .. AK, You can make

Re: service name, sid ..

2003-07-07 Thread Tanel Poder
You're welcome. You don't have to provide db_name in tnsnames, it's instance (init.ora) parameter. Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Monday, July 07, 2003 10:34 PM Subject: Re: service name, sid .. Tanel

RE: service name, sid ..

2003-07-07 Thread Goulet, Dick
-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Monday, July 07, 2003 4:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: service name, sid . AK, You can make it as simple or complicated as you want. Personally I prefer the KISS principle

Re: service name, sid ..

2003-07-03 Thread Tanel Poder
Hi! There's actually more: db_name - identifies database name, has to be the same what is stated in controlfile (using create database or create controlfile). You can have several databases with same db_name in one server, there is no restriction. SID - When we actually want to open and

RE: service name, sid ..

2003-07-02 Thread Goulet, Dick
AK, Let me put it this way, from our own configurations: Specs.world is an alias(servicename) for database(instance name/db name) BART3 which resides on host BART in SID 03. Does that help?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: AK

RE: service name, sid ..

2003-07-02 Thread Stephen Lee
Example using Transparent Application Failover (TAF) If I didn't forget something, here's what it looks like: XXTP_QUOTE.WORLD = (DESCRIPTION= (LOAD_BALANCE=OFF) (FAILOVER=ON) (ADDRESS=(PROTOCOL=TCP)(Host=123.123.22.48)(Port=1527))

RE: service name, sid ..

2003-07-02 Thread Stephen Lee
I forgot to say: the first listing is the tnsnames.ora on the client(s). -Original Message- From: Stephen Lee Sent: Wednesday, July 02, 2003 3:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: service name, sid .. Example using Transparent Application Failover (TAF