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

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