An error ORA-29701 is reported when a 10g library is created on an ASM instance of Oracle 11.2 RAC

Source: Internet
Author: User

When creating a 10g Database on the ASM instance of Oracle11.2 RAC, an error is reported: The Cluster Manager cannot be connected, and the ASM instance cannot be located. The error message is as follows:
ORA-15077: cocould not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager

However, it is normal to create an 11 GB database on the cluster.

My goal is to migrate the 10 Gb database to the 11.2RAC environment. First, restore the 10 Gb database on 11.2RAC, and then upgrade it to the 11 gb rdbms environment.
An error is reported when the control file is restored. It indicates that you cannot connect to Cluster Manager.
/U02/rman_211 @ serv2 => servdb2 $ rman target/


Recovery Manager: Release 10.2.0.4.0-Production on Fri May 4 10:52:22 2012


Copyright (c) 1982,200 7, Oracle. All rights reserved.


Connected to target database: servdb (not mounted)


RMAN> restore controlfile from '/u02/rman_211/ctl_1un9u0a4_00001.20120501 ';


Starting restore at 04-MAY-12
Using target database control file instead of recovery catalog
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: sid = 320 devtype = DISK


Channel ORA_DISK_1: restoring control file
RMAN-00571: ========================================================== ==============================
RMAN-00569: ==================== error message stack follows ==========================
RMAN-00571: ========================================================== ==============================
RMAN-03002: failure of restore command at 10:52:49
ORA-19870: error reading backup piece/u02/rman_211/ctl_1un9u0a4_00001.20120501
ORA-19504: failed to create file "+ WEBDG/servdb/control01.ctl"
ORA-17502: ksfdre: 3 Failed to create file + WEBDG/servdb/control01.ctl
ORA-15001: diskgroup "WEBDG" does not exist or is not mounted.
ORA-15077: cocould not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager


When this error is explained in the official Oracle documentation, 11gR2 is not compatible with earlier versions of databases. The cluster configuration of 11gR2 is dynamic, and the cluster configuration must be fixed for libraries of earlier versions, such as those of Version 10.2.
The official Oracle documentation also provides a solution to pin the css resource.
Log on to the operating system as the root user and run the following command.
[Root @ serv2 bin] #./crsctl pin css-n serv1 serv2
CRS-4664: Node serv1 successfully pinned.
CRS-4664: Node serv2 successfully pinned.
[Root @ serv2 bin] #
[Root @ serv2 bin] #./olsnodes-t
Serv1 Pinned
Serv2 Pinned


Return to the RMAN interface to restore the control file.
RMAN> restore controlfile from '/u02/rman_211/ctl_1un9u0a4_00001.20120501 ';


Starting restore at 04-MAY-12
Using channel ORA_DISK_1


Channel ORA_DISK_1: restoring control file
Channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
Output filename = + WEBDG/servdb/control01.ctl
Output filename = + WEBDG/servdb/control02.ctl
Finished restore at 04-MAY-12

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.