Oracle FAQ Your Portal to the Oracle Knowledge Grid

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: DA Morgan <>
Date: Tue, 07 Aug 2007 08:54:13 -0700
Message-ID: <> wrote:
> On 7 aoŻt, 13:56, 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.

You, the DBA, must create the service.

In 10g it can be done, though imperfectly through dbca and properly using the DBMS_SERVICE built-in package. In 11g it has been moved into DBCONSOLE and the dbca screen has been dropped.

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Tue Aug 07 2007 - 10:54:13 CDT

Original text of this message