RE: location of oracle home path in Enterprise Manager

From: Courtney Llamas <>
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


                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 [] Sent: Monday, June 15, 2015 2:02 PM
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 ""> 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


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

Original text of this message