9.2.0.1 RDBMS Upgrade - OUI

[deulyd]

Hi all,

I am trying to updgrade our 9.2.0.1 Oracle Database to 9.2.0.7 on a Windows Server 2003 OS.

I downloaded the Patch "p4163445_92070_WINNT" from Metalink.

When I read the readme.html it says that I need to use "Oracle Universal Installer 10.1.0.4" that is included in the package. It is NOT! and I only have version 2.2 installed. And on metalink I cannot find the OUI 10.1.0.4 for windows...

Am I just too stupid or Oracle installation and upgrades really su.ks? ;P

Deulyd

 

[SantaMufasa]

Deulyd,

It's been awhile since I had to perform a 9.2.0.7 patch, but unless I'm mistaken, that (and other 9.2.0.x) patches include, as one of the two installation options, the 10.1.0.x installer (where the new 10.1.0.x installer is the first radio-box option, and the 9.2.0.x patch is the second option from one of the installation screen). You must install the new 10.1.0.x OUI first, prior to attempting the 9.2.0.7 patch.

Then, if/when all goes well with the patch, be sure to re-run all of the Oracle Data-Dictionary-creation scripts (e.g., "catalog.sql", "catproc.sql", "catexp.sql", et cetera).

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[deulyd]

Hi Mufasa,

thanks for the quick answer...

In the readme file its written :

"Start Oracle Universal Installer release 10.1.0.4 located in the unzipped area of the patch set. For example, Oracle_patch\setup.exe."

There is absolutely no exe file in the unzipped 238Mb zip file downloaded.

I have the same issue with either 9.2.0.6 or 9.2.0.8 upgrade! :/

Deulyd

 

[SantaMufasa]

Deulyd,

Do you have access to a valid Metalink customer service identifier, under which you can log a service request with Oracle to confirm with them what you should do? If the 10.1.0.4 OUI patch did not come as advertised, then Oracle should be both aware of that and they should point you to the link where you can download as a separate item.

Let us know the outcome.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[karluk]

I just downloaded p4163445_92070_WINNT from Metalink, unzipped it, and navigated to {download directory}\p4163445_92070_WINNT\Disk1\install and clicked the "setup.exe" executable. This brought up OUI version 10.1.0.4.0. I could not proceed any further because my Oracle home has already been patched, but it seems everything is working for me as expected. Perhaps your download session got interrupted and you didn't get the entire zip file. Otherwise I don't know what could have happened.

 

[deulyd]

Thanks all,

I found what was the problem. Windows program for unzip. It was a new server and winrar wasn't installed yet.

Cant believe that, windows unzipper filters the exe files!!!!

Deulyd