Re: location of oracle home path in Enterprise Manager
From: Steve Harville <steve.harville_at_gmail.com>
Date: Mon, 15 Jun 2015 18:05:13 +0000
Message-ID: <CAGd4=DQxA7zfnGEjk3nGc0xGp2fkOzpdma-6Lm_5wuYuHe29nA_at_mail.gmail.com>
Hi Jeffery
I think this is what you want:
Date: Mon, 15 Jun 2015 18:05:13 +0000
Message-ID: <CAGd4=DQxA7zfnGEjk3nGc0xGp2fkOzpdma-6Lm_5wuYuHe29nA_at_mail.gmail.com>
Hi Jeffery
I think this is what you want:
col TARGET_NAME for a60
col HOME_LOCATION for a60
select TARGET_NAME, HOME_LOCATION from sysman.MGMT$TARGET_COMPONENTS where
home_type='ORACLE_HOME' and TARGET_TYPE='oracle_database';
On Mon, Jun 15, 2015 at 1:52 PM Jeffrey Beckstrom <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-lReceived on Mon Jun 15 2015 - 20:05:13 CEST