 Migrating to 10.2.0.3 [message #345642] |
Thu, 04 September 2008 06:23  |
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  |
ThomasG
Messages: 3212
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 #345890 is a reply to message #345708] |
Fri, 05 September 2008 03:59 |
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 #346155 is a reply to message #346114] |
Sat, 06 September 2008 11:54 |
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. 
Thanks in advance.
[Updated on: Sat, 06 September 2008 12:00] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Migrating to 10.2.0.3 [message #346375 is a reply to message #346220] |
Mon, 08 September 2008 06:43 |
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 |
babuknb
Messages: 1736
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 |
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
