Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RAC fail-over with an instance in MOUNT status

Re: RAC fail-over with an instance in MOUNT status

From: <vitalisman_at_gmail.com>
Date: Tue, 07 Aug 2007 07:50:31 -0700
Message-ID: <1186498231.014580.322390@k79g2000hse.googlegroups.com>


On 7 aoŻt, 13:56, tony.van.e..._at_xs4all.nl wrote:
> User defined services are exposed only after the database has been
> opened. Only then clusterware will 'add' the service to the instance
> if neccesary. The default dbname(.db_domain) servicename is not
> controlled by clusterware and should therefore be avoided as the
> servicename to use by cliŽnts.
>
> PS: Check the available service in the listener when the instance in
> mount status: lsnrctl status serv
>
> Solution: CliŽnts should use a servicename which is managed by
> clusterware. So you should explicitly create
> new services with the dbca. Give cliŽnts the new tns-entry with this
> servicename and this problem should be gone.

Thanks a lot, Tony. I guess this is the solution. The cluster database was created with DBCA when only one node was up. And DBCA did not create any basic cluster service. Could you please confirm it creates a cluster service when more than one instance are configured at the time of the database creation?

According to the doco : "DBCA creates a default service for your Oracle RAC database and this service is a special Oracle database service". Another reading would be that it creates the "standard" database service I see on this cluster. But that would mean that even with more than 1 node at database creation, the MOUNT problem can happen unless we configure a cluster service additionally. Received on Tue Aug 07 2007 - 09:50:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US