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).
