By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

Help!! Any non-RAC high-availability experiences with Oracle9 ??

P: n/a
Hi - we are upgrading our old Oracle7.3.4 environment to Oracle9. Our
current HACMP environment consists of two AIX4.3.3 servers (64-bit)
configured as primary and secondary. We have the Oracle 7.3.4
products (binaries) and database files (dbf's, control files, redo
logs) on shared twin-tailed non-concurrent disk.

When the primary node fails the HACMP software fires up the secondary
node, and mounts the filesystems, starts the database which in turn
does its crash recovery redo log thing if required. This
configuration has worked well for the last 7 years or so. We want to
duplicate this configuration with Oracle9.

Does anyone else have experience configuration a similiar
standby-failover environment with Oracle9? And do you know if Oracle
supports this approach? We haven't had much luck finding any specific
documentation from Oracle on this (yes we've RTFM'ed...a few times!).
So any links to docs muchly appreciated.

thanks
Jul 19 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
bw*******@shaw.ca (Bruce) wrote in message news:<22**************************@posting.google. com>...

When the primary node fails the HACMP software fires up the secondary
node, and mounts the filesystems, starts the database which in turn
does its crash recovery redo log thing if required. This
configuration has worked well for the last 7 years or so. We want to
duplicate this configuration with Oracle9.
There should be no reason whatsoever why not. What is the
problem in telling HACMP to do this with one version
of Oracle or another? The whole thing is controlled
by shell scrips, the only thing you may have to change
is that now you start Oracle via SQL*Plus instead of
via Server Manager. Talk to IBM, they should be able
to tell you how to make the change to the scripts.
And do you know if Oracle
supports this approach?
It's not an issue if Oracle "supports" it or not.
HACMP is an IBM product and that's where you should be
looking. Not into Oracle.

We haven't had much luck finding any specific
documentation from Oracle on this (yes we've RTFM'ed...a few times!).
Not surprised. You expect to see HACMP documented by
Oracle? ;)
So any links to docs muchly appreciated.


I'd start by giving IBM a call?

Cheers
Nuno Souto
wi*******@yahoo.com.au.nospam
Jul 19 '05 #2

P: n/a
bw*******@shaw.ca (Bruce) wrote in message news:<22**************************@posting.google. com>...

When the primary node fails the HACMP software fires up the secondary
node, and mounts the filesystems, starts the database which in turn
does its crash recovery redo log thing if required. This
configuration has worked well for the last 7 years or so. We want to
duplicate this configuration with Oracle9.
There should be no reason whatsoever why not. What is the
problem in telling HACMP to do this with one version
of Oracle or another? The whole thing is controlled
by shell scrips, the only thing you may have to change
is that now you start Oracle via SQL*Plus instead of
via Server Manager. Talk to IBM, they should be able
to tell you how to make the change to the scripts.
And do you know if Oracle
supports this approach?
It's not an issue if Oracle "supports" it or not.
HACMP is an IBM product and that's where you should be
looking. Not into Oracle.

We haven't had much luck finding any specific
documentation from Oracle on this (yes we've RTFM'ed...a few times!).
Not surprised. You expect to see HACMP documented by
Oracle? ;)
So any links to docs muchly appreciated.


I'd start by giving IBM a call?

Cheers
Nuno Souto
wi*******@yahoo.com.au.nospam
Jul 19 '05 #3

P: n/a
bw*******@shaw.ca (Bruce) wrote in message news:<22**************************@posting.google. com>...

When the primary node fails the HACMP software fires up the secondary
node, and mounts the filesystems, starts the database which in turn
does its crash recovery redo log thing if required. This
configuration has worked well for the last 7 years or so. We want to
duplicate this configuration with Oracle9.
There should be no reason whatsoever why not. What is the
problem in telling HACMP to do this with one version
of Oracle or another? The whole thing is controlled
by shell scrips, the only thing you may have to change
is that now you start Oracle via SQL*Plus instead of
via Server Manager. Talk to IBM, they should be able
to tell you how to make the change to the scripts.
And do you know if Oracle
supports this approach?
It's not an issue if Oracle "supports" it or not.
HACMP is an IBM product and that's where you should be
looking. Not into Oracle.

We haven't had much luck finding any specific
documentation from Oracle on this (yes we've RTFM'ed...a few times!).
Not surprised. You expect to see HACMP documented by
Oracle? ;)
So any links to docs muchly appreciated.


I'd start by giving IBM a call?

Cheers
Nuno Souto
wi*******@yahoo.com.au.nospam
Jul 19 '05 #4

P: n/a
bw*******@shaw.ca (Bruce) wrote in message news:<22**************************@posting.google. com>...

When the primary node fails the HACMP software fires up the secondary
node, and mounts the filesystems, starts the database which in turn
does its crash recovery redo log thing if required. This
configuration has worked well for the last 7 years or so. We want to
duplicate this configuration with Oracle9.
There should be no reason whatsoever why not. What is the
problem in telling HACMP to do this with one version
of Oracle or another? The whole thing is controlled
by shell scrips, the only thing you may have to change
is that now you start Oracle via SQL*Plus instead of
via Server Manager. Talk to IBM, they should be able
to tell you how to make the change to the scripts.
And do you know if Oracle
supports this approach?
It's not an issue if Oracle "supports" it or not.
HACMP is an IBM product and that's where you should be
looking. Not into Oracle.

We haven't had much luck finding any specific
documentation from Oracle on this (yes we've RTFM'ed...a few times!).
Not surprised. You expect to see HACMP documented by
Oracle? ;)
So any links to docs muchly appreciated.


I'd start by giving IBM a call?

Cheers
Nuno Souto
wi*******@yahoo.com.au.nospam
Jul 19 '05 #5

P: n/a
wi*******@yahoo.com.au (Nuno Souto) wrote in message news:<73**************************@posting.google. com>...

<groan>
freakin gogle first doesn't respond then
sends the same message 5 times...

Apologies to everyone for the silly thing,
but it's outside of my control!

Cheers
Nuno Souto
wi*******@yahoo.com.au.nospam
Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.