| shahul |
Posted: Jan 29, 2008 08:06:12 AM |
Total Post: 17
Joined: Sep, 2007
|
hi all,
i have oracle 10.2.0.1.0 in windows , now i want to upgrade this to 10.2.0.3.0. I have searched in Metalink and goole but didnt find any useful information.
Can anybody help me to upgrade my oracle.
Which patch should i download and step by step procedure to upgrade
Please.................
|
|
|
 Mohammed Taj |
| Posted: Jan 29, 2008 10:53:55 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
http://dbataj.blogspot.com/2008/01/database-patch-set-upgrade.html
|
|
|
|
|
| shahul |
| Posted: Jan 29, 2008 11:21:11 AM | |
|
Total Post: 17
Joined: Sep, 2007
|
Hi Taj,
I dont Find any Useful information for my requirement.
Actually My DB Version is 10.2.0.1.0 in windows
And i need to upgrade to 10.2.0.3.0... in the same server
Can you please help me
|
|
|
|
|
| Vishal |
| Posted: Jan 29, 2008 05:36:04 PM | |
|
Total Post: 37
Joined: Mar, 2006
|
apply a 10.2.0.3 patch on your version. Find it in metalink patches section.
Then run the catupgrd.sql script after starting the database in startup upgrade mode.
Regards,
Vishal
|
|
|
|
|
| Vinod |
| Posted: Jan 31, 2008 07:39:01 AM | |
|
Total Post: 54
Joined: Oct, 2007
|
Hi,
The patch number for 10.2.0.3 is 5337014 ,check the readme file and apply the patch .
Vinod
|
|
|
|
|
| Mohammed Taj |
| Posted: Jan 31, 2008 10:03:45 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
http://babudba.blogspot.com/2007/11/upgrade-oracle-10202-to-10203.html
i want to point this link in my previous reply it is not exactly based on 10.2.0.1 but you will get good overview.
|
|
|
|
|
| Paul P |
| Posted: Jan 31, 2008 11:20:37 AM | |
|
Total Post: 2
Joined: Jan, 2008
|
Taj,
I did upgrade as per you document by now ,when i try to connect to database I'm getting the following error message .
SQL*Plus: Release 10.2.0.3.0 - Production on Fri Feb 1 00:15:55 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Call me right now
+44 89700 31231
Cheers
Paul
|
|
|
|
|
| Mohammed Taj |
| Posted: Jan 31, 2008 11:31:15 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
I don't know how you follow each and every steps.
I don't know about your database type,size etc.
for below error you have to search on net "ORA-12560". becuase basically it is happen when oracle services is not started.
but in your case also check "services" after that search on metalink and google.
ORA-12560: TNS:protocol adapter error
Don't put your number in forms it is public forms.
if you face problem in production database then you have to ask your sr. dba or it is always required to test anything on test database before going for production.
|
|
|
|
|
| Paul P |
| Posted: Jan 31, 2008 03:54:04 PM | |
|
Total Post: 2
Joined: Jan, 2008
|
Thanks , I informed one of our Sr.Oracle DBA .It's fine now .
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
