Re: Unable to install patchset 8.1.7.4

"Dave" <x_at_x.com> wrote in message
news:pIhDd.4704$GG1.2378_at_text.news.blueyonder.co.uk...
>
> "Matthias Hoys" <idmwarpzone_NOSPAM__at_yahoo.com> wrote in message
> news:41dda0cf$0$2445$ba620e4c_at_news.skynet.be...
>> Hi all,
>>
>> I'm trying to upgrade a 8.1.7.2 db running on AIX 4.3.3 to version
>> 8.1.7.4 (don't laugh ;-) ).
>> The problem is that the OUI doesn't "detect" the installed software and
>> always gives me the message "there are no patches that need to be
>> applied" ...
>> I already did some research :
>> - the environment params (ORACLE_HOME, ORACLE_BASE, ...) of the Oracle
>> owner : OK
>> - /etc/oraInst.loc : OK
>> - the binary file OracleHomesList.ser under oraInventory/Contents : NOT
>> OK => this doesn't hold a reference to the correct ORACLE_HOME folder !
>>
>> I have no idea how the software was installed, but I have the impression
>> that it was copied from another server ... So is there any way to add the
>> correct ORACLE_HOME dir to the OracleHomesList.ser file ?
>> I believe my only other option is to reinstall the Oracle software from
>> scratch, but can I do this without having to restore my whole db ?
>>
>> Thanks,
>> Matthias
>
>
> I don't know how to fix the inventory, but you can reinstall all of oracle
> wthout recovering the db, just shut it down, backup your init.ora,
> listener.ora, password file and tnsnames.ora file and any other files
> database files which live under oracle home (hopefully none)
>
> then wipe out the software and reinstall, plus the 8.1.7.4 patchset
>

One of the problems is : how do I remove the software cleanly if the OUI doesn't detect any ...

> then startup the database in migrate upgrade or restrict mode (cann ever
> remmeber which one - it will be in the patch release notes) then run
> catpatch.sql and away ya go
>

Does STARTUP MIGRATE work for Oracle 8i ? I believe it was introduced in Oracle 9i. Received on Thu Jan 06 2005 - 15:26:40 CST