Re: RAC Service

  • From: "Shivaswamy Raghunath" <shivaswamykr@xxxxxxxxx>
  • To: "D'Hooge Freek" <Freek.D'Hooge@xxxxxxxxx>
  • Date: Thu, 31 Jan 2008 11:51:51 -0500

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@xxxxxxxxx> 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@xxxxxxxxx
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer
>
>
> ________________________________________
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> 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
>

Other related posts: