Re: opatch fails do i need to reinstall the entire software?

"Teresa" <tpreto7_at_sapo.pt> wrote in news:1170896613.569314.194120 @v33g2000cwv.googlegroups.com:

> I had oracle 8i installed on a solaries 5.8 server, then a fresh
> install of 10GR2 was done, about 2 months later the 8i install was
> removed including the O/S old ORACLE_HOME & ORACLE_BASE, now I need to
> install patch 4689959_10202_SOLARIS64 and of course fails with "OPatch
> failed with error code 72".
>
> Meanwhile a restore has been done from the orginal 8i home and base,
> and I will be changing the oraInst.loc which is pointing to the 8i
> home to point to the 10g. And then I will be doing a "./runInstaller -
> silent -attachHome -invPtrLoc /var/opt/oracle/oraInst.loc" if this
> does not work and if I have to reinstall oracle again which I really
> hope not, do I have to create the database and tablespaces? Or just
> the libs install? I really would like to avoid a total install of
> everything
> Many thanks
> Teresa
>
>

T,
Do not try to run an Oracle81 patch with oraInst.loc pointing to the 10g.

You do not need to recreate the database if you reinstall the software.

I think you are looking at the right place. The file oraInst.loc points to the inventory which contains all of the information about what is installed. It is not needed at run time, only during installs or patches. Usually it points to $ORACLE_BASE/oraInventory. Oracle recommende that you do not mix the inventories of Oracle8i and Oracle10g. You can do this at install time by editing oraInst.loc to point to a new directory, maybe $ORACLE_BASE/oracle8i/oraInventory.

If your Oracle8i and Oracle10g inventory directories are mixed up and you can't restore the old one, go to http://MetaLink.oracle.com and ask them. They gave me instructions on how to apply the patch manually when OPatch did not work.

HTH
Andy Young Received on Thu Feb 08 2007 - 06:33:29 CST