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

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 07 Aug 2007 08:54:13 -0700
Message-ID: <1186502051.922802@bubbleator.drizzle.com>

vitalisman_at_gmail.com wrote:
> 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.

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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Aug 07 2007 - 10:54:13 CDT