Re: Faiover scripts for Oracle on HP UNIX
Date: Fri, 26 Apr 2002 12:03:44 +0200
Message-ID: <3cc92646$1_at_news.mhogaming.com>
Hi Bert,
tnsnames.ora on clients:
we have 2 Oracle servers, 1st runs under HP-UX, 2nd runs under Windows
1st 2nd
----------------------------------------------------------------------
init.ora: init.ora:
service_names = POH service_names = POH1, POH
ORA.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.132.35.25)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.132.35.32)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = POH))
)
Both databases have service names alias POH.
When client cannot connect to host 192.132.35.25, automatically connects to
192.132.35.32.
More about this you find in Net8 Administrator's Guide -> Appendix C
Configuration Parameters ->
Regards
Robert
We don't use common disk array. You have clustered machines. Try add
service_names of
1st server to service_names of 2nd server to init.ora file of 2nd server and
update tnsnames.ora
on clients.
Don't use syntax CONNECT_DATA = (SID=....) in tnsnames.ora !
Send me a short message to reich_at_poh.cz if it works properly.
Local Naming PArameters (tnsnames.ora)
"Bert" <bverhoev_at_gcc.dhl.com> píse v diskusním príspevku
news:472b6ccd.0204250613.6cbac3ae_at_posting.google.com...
> Hi
>
> We have several processing servers with a common disk array. All the
> oracle datafiles are located on this disk array. We are looking for a
> automated failover script that continues processing when one of the
> processing servers go down. So another server has to take over the
> processing.
> Anyone did something simular?
>
> Kind regards
>
> Bert
Received on Fri Apr 26 2002 - 12:03:44 CEST