Databases
Showing results for 
Search instead for 
Do you mean 

Oracle 10.2.0.3 to 10.2.0.4 pre-upgrade tool issue

SOLVED
Go to Solution
Valued Contributor Valued Contributor

Oracle 10.2.0.3 to 10.2.0.4 pre-upgrade tool issue

Hello,
If I read the doco right I'm supposed to run the 10.2.0.4 version of the Pre-Upgrade
Information tool, in my 10.2.0.3 environment,
before applying the 10.2.0.4 patch set.

But, presumably, the updated tool
(utlu102i.sql script) only comes as part of the 10.2.0.4 patch set..

I'm curious as to how others have proceeded?
1 ACCEPTED SOLUTIONS
Honored Contributor Honored Contributor

Re: Oracle 10.2.0.3 to 10.2.0.4 pre-upgrade tool issue

Hi,

it should be attached to metalink note
884522.1 in it's most recent version.

Or you can extract it from the extracted patchset location:
Disk1/stage/Patches/oracle.rdbms.dbscripts/10.2.0.4.0/1/DataFiles/filegroup1.1.1.jar

(copy somewhere else)

with

jar -xvf filegroup1.1.1.jar utlu102i.sql

Hope this helps
Volker
2 REPLIES
Honored Contributor Honored Contributor

Re: Oracle 10.2.0.3 to 10.2.0.4 pre-upgrade tool issue

Hi,

it should be attached to metalink note
884522.1 in it's most recent version.

Or you can extract it from the extracted patchset location:
Disk1/stage/Patches/oracle.rdbms.dbscripts/10.2.0.4.0/1/DataFiles/filegroup1.1.1.jar

(copy somewhere else)

with

jar -xvf filegroup1.1.1.jar utlu102i.sql

Hope this helps
Volker
Valued Contributor Valued Contributor

Re: Oracle 10.2.0.3 to 10.2.0.4 pre-upgrade tool issue

Thanks Volker for that tip
about extracting the Pre-Upgrade-Information
tool from an unpacked Oracle patch set.