| vikhardba |
Posted: Dec 11, 2007 03:38:16 AM |
Total Post: 86
Joined: Apr, 2007
|
How do i know currently which patch i have in my database? Once i know this, how do i apply latest patches and where from we will get patches? Also, currently i am using Oracle 10.2.0.1.0 version So, how can i change the version to 10.2.0.3?
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
Anticipating your response at the earliest!!!
|
|
|
 Murtuja |
| Posted: Dec 11, 2007 07:08:14 AM |  |
|
Total Post: 816
Joined: Jan, 2006
|
From metalink you can download Patchset.Readme file comes with the Patch.You need to follow steps in readme file.
Metalink--> "Patches & Updates".You have to specify OS details here
If you have mentioned your OS then I can suggest you Patch number directly.
|
|
|
|
|
| vikhardba |
| Posted: Dec 11, 2007 02:08:22 PM | |
|
Total Post: 86
Joined: Apr, 2007
|
Thanks for your speedy response.
Currently i am using Windows 2000 professional. Could you please give complete steps on applying patches.
|
|
|
|
|
| Babu |
| Posted: Dec 12, 2007 01:13:55 AM | |
|
Total Post: 94
Joined: Oct, 2007
|
http://babudba.blogspot.com/2007/11/upgrade-oracle-10202-to-10203.html
|
|
|
|
|
| Murtuja |
| Posted: Dec 12, 2007 01:35:26 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
Hi Babu,
Really nice article.Thanks for sharing.
|
|
|
|
|
| Babu |
| Posted: Dec 12, 2007 01:38:43 AM | |
|
Total Post: 94
Joined: Oct, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
