Re: How do we run one Oracle instance from two servers ?

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 03 Mar 1999 11:48:25 -0800
Message-ID: <36DD9209.4B6540B2@us.oracle.com>

In fact, there are two approaches. OPS will do it, but so will Oracle FailSafe. There is however, a dependency on clustering software which wasn't mentioned in the original post. Are you using MSCS?

HTH Pete

Johnny wrote:

> Oracle parralel server is designed to do this.
>
> Johnny Verhoeven
>
> Stephen Vear wrote:
> >
> > We have 2 NT servers with a shared disk array. We want to run the database
> > on one server and then in the case of H/W problems to be able to run the
> > database on the second server. Of course it has to then access the same
> > database files on the shared disks.
> >
> > How do I get the second server to 'know about' the database that was created
> > via an Oracle environment on a different server? This involves such things
> > as getting a Start Database service created locally.
> >
> > The 'solution' that we have thought up is rename the files, re-run the
> > database generation script on the new server, and then replace the new files
> > with the original ones. I can't help feeling that this is not the correct
> > way to do this....
> >
> > TIA
> > Stephen Vear
> > vears_at_logica.com

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Mar 03 1999 - 13:48:25 CST