Home » RDBMS Server » Server Administration » CPU patch
CPU patch [message #240707] Fri, 25 May 2007 09:53 Go to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi all,

I am going to apply the CPU patch on a windows 2000 test server. The oracle version is 9.2.0.1 on the server.I have to test the CPU patch for 9.2.0.7. So I am thinking of applying the patch for 9.2.0.7. My question is do I have to upgrade the database from 9.2.0.1 to 9.2.0.7 to apply the CPU patch for 9.2.0.7 or I can just apply the patch 9.2.0.7 on the server and apply the CPU patch. I am very confused. Please help.
Re: CPU patch [message #240708 is a reply to message #240707] Fri, 25 May 2007 09:57 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
What does the README file that comes with 9.2.0.7 patchset say?
Re: CPU patch [message #240717 is a reply to message #240707] Fri, 25 May 2007 10:05 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Well, it says apply the patch to an oracle database release 9.2.0.7. So I believe, I have to upgrade the database as well after applying the patch 9.2.0.7.
Re: CPU patch [message #240719 is a reply to message #240707] Fri, 25 May 2007 10:09 Go to previous messageGo to next message
krblr
Messages: 24
Registered: April 2007
Location: MD
Junior Member

Full upgrade or patch upgrade, that depends on the patch, does it come with a complete install (like a full Oracle Home) or not.

1) Sometimes, you install a new Oracle home, and run an upgrade from there (for example, I did this when moving from 10.1.0.3 on Linux to 10.2.0.2)
2) Sometimes, it is as simple as running "opatch apply" after cd to the patch folder

But nn a patch upgrade, you usually work with the same Oracle Home. Usually the patch documentation readme's, help etc. from Oracle metalink keeps you moving around in circles, without giving a straight answer. So I suggest stick with the patch readme, and do what it says.

So make a backup of your entire Oracle_Home before you start. Doesn't hurt to backup your Registry, and of course your "C:\Program Files\Oracle" (the Oracle inventory).
Re: CPU patch [message #240740 is a reply to message #240707] Fri, 25 May 2007 10:55 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Thanks for your response. In my case I cannot do the testing in the new oracle_home becuase there is no disk space available on the server and moreover I have been asked to apply the patch 9.2.0.7 on the 9.2.0.1 database and then do the testing.

On the CPU patch 9.2.0.7 README file, it says apply the patch on an oracle database release 9.2.0.7. I am still confused if I have to upgrade the database from 9.2.0.1 to 9.2.0.7(do I have to follow the upgradation process of the database) or just apply the patch 9.2.0.7 in the Oracle_home. Because in the readme of 9.2.0.7 patch, I just have to go cd and opatch apply. THe upgrade of the database will be a seperate document and a seperate process. Do I have to upgrade the database inorder to apply the CPU patch 9.2.0.7?

OS is windows 2003 32bit and oracle 9.2.0.1.

THanks very much
Re: CPU patch [message #240750 is a reply to message #240740] Fri, 25 May 2007 11:26 Go to previous messageGo to next message
krblr
Messages: 24
Registered: April 2007
Location: MD
Junior Member

Yes, of course, upgrade first.
Re: CPU patch [message #241188 is a reply to message #240707] Mon, 28 May 2007 13:19 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
ok..I checked on the oracle site for the documentation to upgrade to 9.2.0.7 on windows, I am not able to find the right one. Could somebody give me a few links for the upgrade of 9.2.0.1 database on windows? Help very much appreciated.. I will also keep looking for the doc on my own in the mean time..Thanks.
Re: CPU patch [message #241189 is a reply to message #240707] Mon, 28 May 2007 13:40 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
The README file is bundled with patch software from http://metalink.oracle.com
Re: CPU patch [message #241378 is a reply to message #240707] Tue, 29 May 2007 07:20 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Yes.. The readme for the patch is with the patch bundle.. But it only has the steps to apply the patch like (cd ..) (opatch apply).

I am not able to find the document for the upgrade of 9.2.0.1 to 9.2.0.7 on windows... I have the patch and the readme on how to apply the patch.

Please help
Thanks much!
Re: CPU patch [message #241381 is a reply to message #241378] Tue, 29 May 2007 07:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think it is said in the readme file that you have to execute "opatch apply".

Regards
Michel
Re: CPU patch [message #241384 is a reply to message #241378] Tue, 29 May 2007 07:35 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
I am not able to find the document for the upgrade of 9.2.0.1 to 9.2.0.7 on windows...


base release is : 9.2.0.1 and 9.2.0.7 is PATCH SET with come READ ME file .... this is give instructions how apply patchset 9.2.0.7.

hope you understand.
regards
Taj
Re: CPU patch [message #241386 is a reply to message #240707] Tue, 29 May 2007 07:39 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Yes,Michel. I know I have to execute 'opatch apply' for applying the patch 9.2.0.7. I think it will upgrade the oracle software alone and not the database. The database will still be 9.2.0.1.
So I have to upgrade the database to 9.2.0.7 after applying the patch 9.2.0.7. I couldnt find the document to upgrade the database to 9.2.0.7.

I will have to test the CPU patch on a 9.2.0.7 database.

Please correct me if I am wrong.

Please if somebody have the link of the document to upgrade the database from 9.2.0.1 to 9.2.0.7 on windows 2003 please help..
Thanks.
Re: CPU patch [message #241393 is a reply to message #241386] Tue, 29 May 2007 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is explained in the readme file.

Regards
Michel
Re: CPU patch [message #241413 is a reply to message #241386] Tue, 29 May 2007 09:05 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Can you give us your PATCH NUMBER.

regards
Taj
Re: CPU patch [message #241437 is a reply to message #240707] Tue, 29 May 2007 10:09 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
9.2.0.7 patch number-4163445
CPU patch- 5907274
Re: CPU patch [message #241734 is a reply to message #241437] Wed, 30 May 2007 09:15 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
i am go through your mention patch number.

9.2.0.7 patch number-4163445
CPU patch- 5907274

your database base release is 9.2.0.1
first you have to apply patch number : 4163445.

how can apply ??? please read "readme.txt" file come with patch.

after you apply/upgrade successfully apply CPU PATCH : 5907274

regards
Taj

PS: let us know result.
Re: CPU patch [message #241741 is a reply to message #241437] Wed, 30 May 2007 09:28 Go to previous messageGo to next message
krblr
Messages: 24
Registered: April 2007
Location: MD
Junior Member

Heres what you do,
-- Upgrade to 9.2.0.7 first: Read Note: 161549.1, read the table (matrix) will lead you to "Patch: 4163445", apply this patch. I also see a note from Taj as I write, saying the same thing.
-- And then apply that other patch that you want to apply
Re: CPU patch [message #241827 is a reply to message #240707] Wed, 30 May 2007 12:20 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi,

I first applied patch 4163445 for 9.2.0.7 and then upgraded the database to 9.2.0.7 manually. Then applied the CPU patch 5907274.
There were no errors and everything went fine.
Thanks for your support.
Re: CPU patch [message #241913 is a reply to message #241827] Thu, 31 May 2007 00:54 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

happy ending Smile
Previous Topic: pl/sql package using UTL_FILE
Next Topic: Application File system for dba1 (New Test instance)
Goto Forum:
  


Current Time: Thu Dec 08 18:29:19 CST 2016

Total time taken to generate the page: 0.08787 seconds