Re: How to find out concrete ORACLE_HOME via SQL?

> I don't think this is about different people having different ideas of
> their job. It is just a fact of life that there are a lot of installs
> where internal rules, or bad DBAs, or outside vendors, move stuff all
> over the place.

Absolutely right: Badly skilled DBAs and outside vendors, whose developers never got in touch with oracle books or documentation! Welcome in reality... :-((

> SQL> set linesize 131
> SQL> set pagesize 20
> SQL> col host_name format a30
> SQL> col home_name format a20
> SQL> col home_location format a50
> SQL> SELECT *
> 2 FROM sysman.mgmt$software_homes;

I'm afraid, there are oracle installations running without the sysman user. Received on Mon Aug 14 2006 - 14:25:32 CDT