RE: location of oracle home path in Enterprise Manager

From: Courtney Llamas <courtney.llamas_at_oracle.com>
Date: Mon, 15 Jun 2015 12:17:44 -0700 (PDT)
Message-ID: <d336495c-6874-417d-8647-b476548c4143_at_default>

Here’s the query that’s used from the Oracle Database Software Summary report (IP).

 

select inst.external_name || ' ' || REGEXP_SUBSTR(inst.version , '^[[:digit:]]+\.[[:digit:]]+' )  as "DB_INSTALLATION_LBL",

                targs.target_name as "TARGET_LBL",

                targs.host_target_name as "HC_TARGET_NAME",

                targs.home_location as "ORACLE_HOME_LBL",

                inst.version as "VERSION_LBL"

        from MGMT$ORACLE_SW_ENT_TARGETS targs,

                MGMT$ORACLE_SW_ENT_INSTALL inst

        where

                targs.home_location = inst.container_location

               and targs.target_type='oracle_database'

                and targs.host_target_name = inst.host_name

        order by inst.external_name || ' ' || REGEXP_SUBSTR(inst.version , '^[[:digit:]]+\.[[:digit:]]+' ) 

 

From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: Monday, June 15, 2015 2:02 PM
To: JBECKSTROM_at_gcrta.org
Cc: ORACLE-L; oracle-db-l
Subject: Re: location of oracle home path in Enterprise Manager

 

Am I especially awkward to ask why you ask?

On 15 Jun 2015 18:52, "Jeffrey Beckstrom" <HYPERLINK "mailto:JBECKSTROM_at_gcrta.org"JBECKSTROM_at_gcrta.org> wrote:

In what table does Enterprise Manager store the Oracle Home Path for each database?

 

Jeffrey Beckstrom
Lead Database Administrator

Information Technology Department

Greater Cleveland Regional Transit Authority

1240 W. 6th Street
Cleveland, Ohio 44113

 
 
.

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

Received on Mon Jun 15 2015 - 21:17:44 CEST