-
Originally Posted by pando
failsafe is only for windows
yeah whoops - missed that - thanks
I'm stmontgo and I approve of this message
-
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
-
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)
--- Everything was meant to be---
-
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
-
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)
--- Everything was meant to be---
-
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?
-
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)
--- Everything was meant to be---
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|