Re: RAC Service

From: Shivaswamy Raghunath <shivaswamykr_at_gmail.com>
Date: Thu, 31 Jan 2008 11:51:51 -0500
Message-ID: <1e52ad820801310851u691107adv73a9ce8227461af2@mail.gmail.com>


Thank you.. But I needed to know when the service was *created.*

On Jan 31, 2008 11:37 AM, D'Hooge Freek <Freek.D'Hooge_at_uptime.be> wrote:

> Do you mean the service_names ?
>
> SQL> descr v$services
> Name Null? Type
> ----------------------------------------- --------
> ----------------------------
> SERVICE_ID NUMBER
> NAME VARCHAR2(64)
> NAME_HASH NUMBER
> NETWORK_NAME VARCHAR2(512)
> CREATION_DATE DATE
> CREATION_DATE_HASH NUMBER
> GOAL VARCHAR2(12)
> DTP VARCHAR2(1)
> AQ_HA_NOTIFICATION VARCHAR2(3)
> CLB_GOAL VARCHAR2(5)
>
> Regards,
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge_at_uptime.be
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer
>
>
> ________________________________________
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Shivaswamy Raghunath
> Sent: donderdag 31 januari 2008 17:25
> To: Oracle-L
> Subject: RAC Service
>
> Hello.
> I am doing some trouble shooting. Is there a way to identify when a
> service is created? I deduce it has to be at cluster level. But, so far it
> has been futile effort my end.
> Just as we know when an objected is created in the database, is there not
> something which stores the info - this reource is created on such and such a
> time?
> TIA,
> Shiva
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 31 2008 - 10:51:51 CST

Original text of this message