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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Bruce
    #1

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

    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
    Tags: None
    • Nuno Souto
      #2
      Re: Help!! Any non-RAC high-availability experiences with Oracle9 ??

      bwilliams@shaw. ca (Bruce) wrote in message news:<22f0a793. 0307121311.7731 782d@posting.go ogle.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
      wizofoz2k@yahoo .com.au.nospam

        Comment

        • Nuno Souto
          #3
          Re: Help!! Any non-RAC high-availability experiences with Oracle9 ??

          bwilliams@shaw. ca (Bruce) wrote in message news:<22f0a793. 0307121311.7731 782d@posting.go ogle.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
          wizofoz2k@yahoo .com.au.nospam

            Comment

            • Nuno Souto
              #4
              Re: Help!! Any non-RAC high-availability experiences with Oracle9 ??

              bwilliams@shaw. ca (Bruce) wrote in message news:<22f0a793. 0307121311.7731 782d@posting.go ogle.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
              wizofoz2k@yahoo .com.au.nospam

                Comment

                • Nuno Souto
                  #5
                  Re: Help!! Any non-RAC high-availability experiences with Oracle9 ??

                  bwilliams@shaw. ca (Bruce) wrote in message news:<22f0a793. 0307121311.7731 782d@posting.go ogle.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
                  wizofoz2k@yahoo .com.au.nospam

                    Comment

                    • Nuno Souto
                      #6
                      Re: Help!! Any non-RAC high-availability experiences with Oracle9 ??

                      wizofoz2k@yahoo .com.au (Nuno Souto) wrote in message news:<73e20c6c. 0307130137.112c d7f6@posting.go ogle.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
                      wizofoz2k@yahoo .com.au.nospam

                        Comment

                        Previous template Next
                        Working...