Home » RDBMS Server » Server Administration » Migrating to 10.2.0.3 (10gR2, 10.2.0.1.0, Windows server 2003 32-bit)
icon14.gif  Migrating to 10.2.0.3 [message #345642] Thu, 04 September 2008 06:23 Go to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Hello,

This is my first time on this forums and from what I've seen/read so far, I can say am gonna enjoy being here.

My issue is that I am ordered to migrate our database to version 10.2.0.3 but this is an operation I have never done. We're runing 10.2.0.1.0 on Windows server 2003 32-bit. I have a metalink account. Can someone please tell me how do I proceed? What information do I enter on the fields "release" (the release am working on now, or the release I want to migrate to), "patch type" and "classification"?

Thank you in advance.
Re: Migrating to 10.2.0.3 [message #345658 is a reply to message #345642] Thu, 04 September 2008 06:52 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Go to the "Patches and Updates" tab.

And then "Quick Links to the Latest Patchsets, Mini Packs, and Maintenance Packs"

And then navigate to the product / OS / version you want to upgrade to.
Re: Migrating to 10.2.0.3 [message #345696 is a reply to message #345658] Thu, 04 September 2008 09:16 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member

Thank you. Am gonna try that out now!
Re: Migrating to 10.2.0.3 [message #345703 is a reply to message #345696] Thu, 04 September 2008 09:36 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
I believe it is patch number 5337014 for windows 32 bit

regards

Alan

[Updated on: Thu, 04 September 2008 09:37]

Report message to a moderator

Re: Migrating to 10.2.0.3 [message #345708 is a reply to message #345703] Thu, 04 September 2008 10:17 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member

Exactely, that's the patch number. Thanks again.Downloading now!
Re: Migrating to 10.2.0.3 [message #345890 is a reply to message #345708] Fri, 05 September 2008 03:59 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
The download in done and I went though the read me. It's required to download the patch num 5601428...I did. and in it, one should apply the script utltzuv2.sql. I did notice that, that script does exist in the directory 'files' of the patch 5601428, but it also exists in my current oracle_home.

Which one of those do I execute? The one in the patch???

I also went through the script utltzuv2.sql, and it is said to get the latest version of the timezdif.csv file before running utltzuv2.sql.

Can I find that file on metalink?

Thanks in advance.

[Updated on: Fri, 05 September 2008 04:10]

Report message to a moderator

Re: Migrating to 10.2.0.3 [message #346096 is a reply to message #345890] Fri, 05 September 2008 23:34 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

If you want to upgrade then apply 10.2.0.4.0 patchset instead of 10.2.0.3.0.

The procedure is same for both patchset.

NOTE: Read README.txt file.
Re: Migrating to 10.2.0.3 [message #346105 is a reply to message #345890] Sat, 06 September 2008 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can I find that file on metalink?

Yes.

Regards
Michel
Re: Migrating to 10.2.0.3 [message #346114 is a reply to message #346105] Sat, 06 September 2008 01:56 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

http://babudba.blogspot.com/2007/11/upgrade-oracle-10202-to-10203.html

Babu

[Updated on: Sat, 06 September 2008 03:25]

Report message to a moderator

Re: Migrating to 10.2.0.3 [message #346155 is a reply to message #346114] Sat, 06 September 2008 11:54 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Hello,

Thank you all for your contributions. I think am well armed now though...well, when I was reading the post installation taks associated with the migration, I noticed in the read me that for an upgrade using the assistant, one should set ORACLE_HOME,ORACLE_SID and PATH variable. I know what ORACLE_HOME and ORACLE_SID refer to, but I don't know what PATH variable is. Anyone knows? If yes, can you please explain to me how to set it?. I would like to perform the upgrade using the assistant on this one.

Just to exercise myself, I think am gonna try the manual upgrade on another machine. Thanks anyway Babu, for the link.

I got the timetz.csv file. I made the suggestion Taj, but my managers don't want to hear about a version other than .0.4. Can't afford to lose my job for that. Smile

Thanks in advance.

[Updated on: Sat, 06 September 2008 12:00]

Report message to a moderator

Re: Migrating to 10.2.0.3 [message #346158 is a reply to message #346155] Sat, 06 September 2008 12:18 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Hello,

Quote:
We're runing 10.2.0.1.0 on Windows server 2003


Your doing to install 10.2.0.3.0 patch in your database.

Quote:
I would like to perform the upgrade using the assistant on this one.


I don't know why you need to use Upgrade Assistant? This is no need pls read README.txt or try to follow the above link

Babu
Re: Migrating to 10.2.0.3 [message #346176 is a reply to message #346158] Sun, 07 September 2008 00:39 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Babu,

There is two choice 1. DBUA(Database Upgrade Assistant) 2. Manually. then we can be use DBUA.
Re: Migrating to 10.2.0.3 [message #346220 is a reply to message #346176] Sun, 07 September 2008 09:40 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Mr. Taj,

Sorry for my understanding...

Babu
Re: Migrating to 10.2.0.3 [message #346375 is a reply to message #346220] Mon, 08 September 2008 06:43 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member

Well Babu as Taj already said, there are two ways of doing that, and I did it both ways as I said. On my PC, I did it manually following the instructions on the read me and those on your link.(They were all the same though), and this morning, I did it on the server itself using the assistant, and it worked. Thank you again. However, there is a step I didn't follow when I was doing the manual upgrade. Your link Babu, instructed to make sure the SYSTEM tablespace has at least 50M of free space. I skipped that but I would like to know how we check that? I queried the dba_tablespaces data dico table but I couldn't figure out which fields to use to determine the space of the system tablespace. Can someone help?

Thanks in advance.
Re: Migrating to 10.2.0.3 [message #346397 is a reply to message #346375] Mon, 08 September 2008 07:49 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Find Total space of System Tablespace:

select sum(bytes)/1024/1024/1024 from dba_data_files where tablespace_name='SYSTEM'


Find Free space of System tablespace:

select sum(bytes)/1024/1024/1024 from dba_free_space where tablespace_name='SYSTEM'


Babu

[Updated on: Mon, 08 September 2008 07:49]

Report message to a moderator

Re: Migrating to 10.2.0.3 [message #346433 is a reply to message #346397] Mon, 08 September 2008 10:06 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Thank you Babu. Didn't know about the dba_free_space data dico table before. Tell me though, dividing thrice by 1024 gives the result in gigabytes doesn't it?
Re: Migrating to 10.2.0.3 [message #346499 is a reply to message #346433] Mon, 08 September 2008 13:53 Go to previous message
varunvir
Messages: 363
Registered: November 2007
Senior Member
yes it will give the result in gb
Previous Topic: database hang + page file
Next Topic: Application not coming up
Goto Forum:
  


Current Time: Sun Dec 04 23:06:29 CST 2016

Total time taken to generate the page: 0.13661 seconds