Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out concrete ORACLE_HOME via SQL?

Re: How to find out concrete ORACLE_HOME via SQL?

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 14 Aug 2006 13:43:44 -0700
Message-ID: <1155588224.7332@bubbleator.drizzle.com>


NitelyJoy wrote:
>> 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. 

That also means running without StatsPack. Not a good idea in either case.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Aug 14 2006 - 15:43:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US