Re: Faiover scripts for Oracle on HP UNIX

"Robert Reich" <reich_at_poh.cz> pí¹e v diskusním pøíspìvku news:3cc92646$1_at_news.mhogaming.com...
> Hi Bert,
> 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
>
>
> tnsnames.ora on clients:
> 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.
> 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.
>
> More about this you find in Net8 Administrator's Guide -> Appendix C
> Configuration Parameters ->
> Local Naming PArameters (tnsnames.ora)
>
> Regards
>
> Robert
>

PS: THIS SYNTAX WORKS FROM ORACLE 8I (8.1.*) !!!!        Robert

> "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:10:02 CEST