oracle11创建实例报错,【数据库】Oracle 11.2 RAC的ASM实例上创建10g库报错ORA-29701

在Oracle11.2 RAC 的ASM 实例上创建10g 数据库时，报错说：不能连接到Cluster Manager ，不能定位到ASM 实例。具体错误信息如下：

在Oracle11.2 RAC 的ASM 实例上创建10g 数据库时，报错说：不能连接到Cluster Manager ，不能定位到ASM 实例。具体错误信息如下：

ORA-15077: could not locate ASM instance serving a required diskgroup

ORA-29701: unable to connect to Cluster Manager

但在该集群上，创建11g 的数据库时是正常的。

我的目标是将10g 数据库迁移升级到11.2RAC 的环境中。首先是在11.2RAC 上恢复好10g 的数据库，再到11g 的RDBMS 环境中去升级。

在恢复控制文件时，就报错。显示不能连接到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, 2007, Oracle. All rights reserved.

connected to target database: servdb (not mounted)

RMAN> restore controlfile from '/u02/rman_211/ctl_1un9u0a4_1_1.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 05/04/2012 10:52:49

ORA-19870: error reading backup piece /u02/rman_211/ctl_1un9u0a4_1_1.20120501

ORA-19504: failed to create file "+WEBDG/servdb/control01.ctl"

ORA-17502: ksfdcre:3 Failed to create file +WEBDG/servdb/control01.ctl

ORA-15001: diskgroup "WEBDG" does not exist or is not mounted

ORA-15077: could not locate ASM instance serving a required diskgroup

ORA-29701: unable to connect to Cluster Manager

Oracle 官方文档对此错误的解释时11gR2 不兼容老版本的数据库。11gR2 的集群配置是动态的，，而老版本的库如10.2 版本的库要求集群配置是固定的。

Oracle 官方文档同时也给出了解决方法，即是将css 资源pin 住。

使用root 用户登录操作系统，执行下列命令。

[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

再回到RMAN 界面去恢复控制文件，正常了。

RMAN> restore controlfile from '/u02/rman_211/ctl_1un9u0a4_1_1.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

更多Oracle相关信息见Oracle 专题页面 ?tid=12