Operating System - HP-UX
1751924 Members
4810 Online
108783 Solutions
New Discussion юеВ

Oracle 10.2.0.3 to 10.2.0.4 pre-upgrade tool issue

 
SOLVED
Go to solution
David Nixon
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?
2 REPLIES 2
Volker Borowski
Honored Contributor
Solution

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
David Nixon
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.