DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 22

Thread: clustered DB and RAC

  1. #11
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Quote Originally Posted by pando
    failsafe is only for windows
    yeah whoops - missed that - thanks
    I'm stmontgo and I approve of this message

  2. #12
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Quote Originally Posted by stmontgo
    you really need to do some reading on dataguard and rac, your questions are well, odd. What are you talking about when you say
    "How can i detach the a node from the cluster and make it
    stand alone"
    I mean, if you have a cluster of servers(nodes) with separate ORACLE_HOME in each also in a cluster. How can i make one
    of the cluster member behave like a stand alone server with
    respect to oracle clustering.

    Thanks

  3. #13
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Again, you haven't provided with a detailed setup at your shop. So let me (hmm there we go again) try to *imagine* how your SAP app is setup.
    Scenario 1:
    ------------
    DEV Box has
    1. SAPProd application server(?)
    2. ORACLE_HOMEDEV(dev and prod schema)

    PROD Box has
    1. SAPDEV application server(?)
    2. ORACLE_HOMEPROD(dev and prod schema's)

    And here the "SAPProd application server" talks to the PROD box and
    "SAPDEV application server" talks to the DEV box. Should PROD box Oracle fail, both app servers talk to the DEV box and vice versa.

    Scenario 2
    -----------

    SAP Box1
    Oracle_home2

    SAP Box 2
    Oracle_home1

    Should SAP Box 1 fail to connect to Oracle_home1(preferred db), it reverts back to oracle_home2(which is sync'ed via log shipping, I guess) and should SAP Box1 fail(app server), SAP Box 2 is woken up(it's merely a HTTP/Container) and it continues to talk to oracle_home1(preferred db).

    I hope I'm not confusing you. Go back to your HW engineer. Or you are not understanding well or the HW guy didn't really set it up himself(probably done by some external shop).

    Let us know if this helps.

    Tarry
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  4. #14
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks again Tarry,

    But i must say the people here doesnt know much of the set-up and so with Oracle clustering. The servers was intended to be (maybe a RAC) but it was not done so. Instead they have installed independent database for each server.

    Scenario 3
    -----------

    SAP Box1(dev)
    Oracle_home1
    with dev instance
    with dev database

    SAP Box 2(prod)
    Oracle_home2
    with prod instance
    with prod database

    The two nodes are clustered. and both oracle_home1 and
    oracle_home2 have same version. So in case PROD fails, the
    result would be...


    SAP BOX 1(DEV SERVER)
    Oracle_home1
    dev instance
    dev database
    prod instance
    prod database


    Im not really interested on the set-up. they can be anything u want
    to imagine. What my problem is...I can not install the patch on the
    PROD server. But i have it installed on the DEV server. Can u help
    me how pls.

    thanks

  5. #15
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    You might want to open a TAR and asking Oracle Support for possible remedies. I personally don't see why(two seperated instances) can have any issues against being patched up.

    The reason why you'd want to be interested in the setup is
    --That you're not left in quandry(problems) should a situation like this occur again (there is already a patch 9206 BTW, If I'm not mistaken).
    -- I would have(if I were you), in this time of soul and web searching, quickly setup similar scenario on an available server with a VMWare or an identical setup physically (make the damn bosses pay for some cheap servers or even pc's) and tried the whole patching scenario there.
    --All that eventually helps when (should you not succeed in solving the problem yourself) you want to relate the problem to the support staff.

    Also patching up clustered environments does indeed require a good understanding of the cluster itself. You don't have a RAC, had that been the case, your patch(correct me if I'm wrong) would have propogated among all the nodes.

    So your oracle environemnt was not cluster aware(not RAC) and that's why the cluster *resources* went out of sync which is not a problem until you really experience a fail over scenario.

    Long story short:
    --Ask Oracle Support.
    -- Please do set up a similar test environment.


    Cheers

    Tarry
    Last edited by Tarry; 08-13-2005 at 09:01 AM.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  6. #16
    Join Date
    Oct 2002
    Posts
    391
    There were many other threads from my last post. I just briefly read through. Anyway, its very possible that 2 oracle instances can have one oracle home.

    Your Query is that when PRD fails over to DEV, it will be using DEV binaries or so called home?

  7. #17
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    He wants to patch his envionment to 9205. That's *all* he wants.
    Last edited by Tarry; 08-16-2005 at 05:37 AM.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  8. #18
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    yes, ..... I tried installing a new oracle_home(test) using the base 9.2.0.1 and create "test" DB against it on the PROD server. I didnt invoke clustering during the oracle install, though it can see the DEV server cluster
    during install. Then I patched the test oracle_home(test) it worked fine.

    So my question is....If the SAP oracle_home on PROD server in clustered
    with SAP oracle_home on DEV server, on which server should i run the
    patch 9.2.0.5 installation first?

    Thanks a lot

  9. #19
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    how do you know that 'it can see the dev server cluster' be specific now, where in the OUI do you see this? and for what its worthm i always patch my rac or ops clusters 'node by node'. That way I eliminate and kludge factor with the binaries being pushed and updated across the nodes.
    I'm stmontgo and I approve of this message

  10. #20
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks stmongo, i hope Im on the right track now....I just get
    confused with this cluster set-up. Let me ask about ur rac cluster set-up. when u say ....
    "and for what its worthm i always patch my rac or ops clusters 'node by node'. That way I eliminate and kludge factor with the binaries being pushed and updated across the nodes."

    1. Is there other way of patching aside from node by node?
    2. Do u mean mean that you go to each node physically, load the,
    patchset, run OUI and install the patch?

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width