RE: Oracle Best Practices for SAP

Regarding OraInventory...make sure your ORACLE_BASE parameter is set to /oracle/<SID>. Check you /var/opt/oracle/oraInst.loc file as well...  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Holland [oramail]
Sent: Thursday, February 15, 2007 11:09 AM To: 'Richard J. Goulet'; jkstill_at_gmail.com Cc: oracle-l_at_freelists.org
Subject: RE: Oracle Best Practices for SAP

Dick Goulet wrote:

> No your not that bad, worse.

I'm worse? You lost me....

> I'm in the middle of trying to straighten up the OraInventory on a
> number of servers that need patches, but since the inventory is soo
> fouled up we can't. And the folks at SAP are no help either. Their
> recommendation, buy a new server & migrate over.

How'd your inventory get fouled up? The only time I've had problems with that is with multiple installations trying to write to the same inventory file (because the /etc/ora<whatever> file wasn't set up right.... that was back in the 8.1 days though.

I've never been able to clean up fouled OraInventorys... isn't Oracle's recommendation to re-install if the inventory is hosed? You'd have some downtime, but you should be able to remove the oracle installation and re-install the software, then restore your initSID.ora file & come back up using the existing data files with a nice clean inventory -- no additional hardware required unless you need it to minimize the outage.

--
Rich Holland
Guidance Technologies, Inc.
v: (913) 645-1950
f: (913) 273-0675
e: holland_at_guidancetech.com



--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l