Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: service name, sid ..

RE: service name, sid ..

From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
Date: Wed, 02 Jul 2003 12:48:49 -0700
Message-ID: <F001.005C149C.20030702123127@fatcity.com>

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)
> 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))
> (ADDRESS=(PROTOCOL=TCP)(Host=123.123.22.47)(Port=1527))
> (CONNECT_DATA=
> (SERVICE_NAME=XXTP.WORLD)
> (FAILOVER_MODE=
> (BACKUP=XXTP_QUOTE2.WORLD)
> (TYPE=SESSION)
> (METHOD=BASIC)
> (RETRIES=180)
> (DELAY=1)
> )
> )
> )
>
> XXTP_QUOTE2.WORLD =
> (DESCRIPTION=
> (LOAD_BALANCE=OFF)
> (FAILOVER=ON)
> (ADDRESS=(PROTOCOL=TCP)(Host=123.123.22.47)(Port=1527))
> (ADDRESS=(PROTOCOL=TCP)(Host=123.123.22.48)(Port=1527))
> (CONNECT_DATA=
> (SERVICE_NAME=XXTP.WORLD)
> (FAILOVER_MODE=
> (BACKUP=XXTP_QUOTE.WORLD)
> (TYPE=SESSION)
> (METHOD=BASIC)
> (RETRIES=50)
> (DELAY=1)
> )
> )
> )
>
> XXTP_SHOP.WORLD =
> (DESCRIPTION=
> (LOAD_BALANCE=ON)
> (FAILOVER=ON)
> (ADDRESS=(PROTOCOL=TCP)(Host=123.123.22.48)(Port=1526))
> (ADDRESS=(PROTOCOL=TCP)(Host=123.123.22.47)(Port=1526))
> (CONNECT_DATA=
> (SERVICE_NAME=XXTP.WORLD)
> (FAILOVER_MODE=
> (BACKUP=XXTP_SHOP2.WORLD)
> (TYPE=SESSION)
> (METHOD=BASIC)
> (RETRIES=180)
> (DELAY=1)
> )
> )
> )
>
> XXTP_SHOP2.WORLD =
> (DESCRIPTION=
> (LOAD_BALANCE=ON)
> (FAILOVER=ON)
> (ADDRESS=(PROTOCOL=TCP)(Host=123.123.22.48)(Port=1526))
> (ADDRESS=(PROTOCOL=TCP)(Host=123.123.22.47)(Port=1526))
> (CONNECT_DATA=
> (SERVICE_NAME=XXTP.WORLD)
> (FAILOVER_MODE=
> (BACKUP=XXTP_SHOP.WORLD)
> (TYPE=SESSION)
> (METHOD=BASIC)
> (RETRIES=50)
> (DELAY=1)
> )
> )
> )
>
> XXTP_UPDATE.WORLD =
> (DESCRIPTION=
> (ADDRESS=(PROTOCOL=TCP)(Host=123.123.22.48)(Port=1527))
> (CONNECT_DATA=
> (SERVICE_NAME=XXTP.WORLD)
> (SERVER=DEDICATED)
> (FAILOVER_MODE=
> (TYPE=NONE)
> )
> )
> )
>
> In the init.ora for one database ...
>
> db_domain = world
> instance_name = XXTP1
> service_names = XXTP
>
> In the init.ora for the other database ....
>
> db_domain = world
> instance_name = XXTP2
> service_names = XXTP
>
>
> -----Original Message-----
> why service name is not same as db name . Earlier service
> name and sid used
> to be same thing .. isn't it ( ? ) .
>
> Can some one clarify with some examples .
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Lee
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Wed Jul 02 2003 - 14:48:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US