Home » Server Options » RAC & Failsafe » Patching in RAC
Patching in RAC [message #304432] Wed, 05 March 2008 03:20 Go to next message
harshkumar
Messages: 34
Registered: February 2008
Location: Delhi
Member
Hi,

I have to apply a bugfix patch in RAC environment. I go through readme file and according to my understanding i have to follow the below steps:

1. Shutdown instance on both nodes

2. upload the p5606847_10203_Solaris86-64.zip file on server and unzip

3. cd 5606847 

4. opatch apply 

I have the below queries:

1. Do i need to stop all the oracle services on both nodes ? or shutdown instances is enogh.

2. Whether the patch will automatically apply on both nodes or we need to patch individually all the nodes ? if yes, then any difference in the above steps.

Please provide your inputs.

Thanks
Harsh
Re: Patching in RAC [message #304678 is a reply to message #304432] Thu, 06 March 2008 01:46 Go to previous messageGo to next message
harshkumar
Messages: 34
Registered: February 2008
Location: Delhi
Member
Hi Michel,

Can you please confirm that whether the steps i have mentioned are correct or not.

I got the answers of my questions. Please confirm, if wrong:

We need to stop the all the services except cluster daemon. it will patch both the nodes.

Thanks
Harsh
Re: Patching in RAC [message #304680 is a reply to message #304678] Thu, 06 March 2008 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know what are the steps.
I just read what is inside readme file and follow it.

Regards
Michel
Re: Patching in RAC [message #304711 is a reply to message #304432] Thu, 06 March 2008 05:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It actually depends on the options you choose (like rolling upgrades). As Michell already said, just look into readme file and do as it says.
Re: Patching in RAC [message #304915 is a reply to message #304711] Fri, 07 March 2008 02:53 Go to previous messageGo to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
I think these guys also dont know wht to do........better open a tar........
Re: Patching in RAC [message #304948 is a reply to message #304915] Fri, 07 March 2008 05:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> better open a tar...
For what? How to read the readme file?
Re: Patching in RAC [message #305100 is a reply to message #304432] Sat, 08 March 2008 08:25 Go to previous messageGo to next message
harshkumar
Messages: 34
Registered: February 2008
Location: Delhi
Member
Thank you all for the support ans suggestions.

Actually i have posted the query after reading the README file. But in this file they did not mentioned that whether we need to stop all the oracle services.

I have followed the same steps as i have mentioned in my earlier post and it patched the successfully.

Thanks
Harsh
Re: Patching in RAC [message #305106 is a reply to message #305100] Sat, 08 March 2008 09:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All what is needed to be stopped is mentioned in the readme files. If something is not mentioned then it is not mandatory to stop it.

Regards
Michel

[Updated on: Sat, 08 March 2008 09:10]

Report message to a moderator

Re: Patching in RAC [message #306377 is a reply to message #305106] Fri, 14 March 2008 00:00 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Can u tell me a better book for the Oracle Real application Clustering, that book should contain all the need for installation and configuration of RAC in 10g and below mentioned topic should also covered

RHEL AS 4 Installation
Oracle 10g Installation with ASM & CRS (Automatic Storage Management, Cluster Ready Service)
Create Database Instance
Create a Physical Database
Create Datafiles and Tablespace
Installation of DB Scripts in the Physical database
Performance reports in single node
Additional Node Installation (Linux & Oracle 10g)
Creation of Database Instance in Additional Node
Adding the additional node to physical database
Adding of tablespace and data files in additional node
Reinstallation of DB Scripts in the Physical database
Performance reports in two nodes

Thanks,

Re: Patching in RAC [message #306392 is a reply to message #306377] Fri, 14 March 2008 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't hijack a topic with a subject that doesn't have any relation with the previous question, create your own one.
Documentation is on http://tahiti.oracle.com

Regards
Michel
Re: Patching in RAC [message #309956 is a reply to message #304948] Sun, 30 March 2008 10:18 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Mahesh,
too good.
...For what? How to read the readme file?...
Smile
Re: Patching in RAC [message #310223 is a reply to message #304432] Mon, 31 March 2008 10:58 Go to previous messageGo to next message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
I will recommend u stop all oracle processes in both nodes before applying the patch.
Also make sure ssh is properly configured to assure propee communication b/w all nodes before patching.
However, do not stop the crs...

Take care...

divroro12
Re: Patching in RAC [message #310269 is a reply to message #310223] Mon, 31 March 2008 15:44 Go to previous messageGo to next message
harshkumar
Messages: 34
Registered: February 2008
Location: Delhi
Member
Hi divroro12,

Thanks for your input.
I followed the same steps that you have suggested and patched successfully.

Thanks
Harsh
Re: Patching in RAC [message #337412 is a reply to message #310269] Wed, 30 July 2008 17:26 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
when we apply patch we are touching the binaries of oracle.

Readme doc which is been provided by oracle have all the steps, every patch has its own step but while CPU patch,

use the correct opatch utility
set the opatch path if required.
.

Stop listener
stop instance
stop agent

put the db instance in blackout if you using grid, so that no alert should be generated

Take proper down time for applying patch.

It means Before doing opatch apply

Note :- By which command we have to give for applying patch is there in readme.txt

once patch is applied successfully please run the catcpu.sql if u applying cpu patch... and also ultrp.sql after starting the DB than start the listener.

We can apply patch simultaneously on both the node on rac but its always good to apply patch on one node so that if any error comes our one instance is up and running, business will not be impacted.



[Updated on: Wed, 30 July 2008 17:27]

Report message to a moderator

Previous Topic: Configure ASM Disk Group
Next Topic: ORA-12505: TNS : Listener does not currently know of SID given in connect descripter
Goto Forum:
  


Current Time: Fri Mar 29 10:13:19 CDT 2024