Home >Database >Mysql Tutorial >Oracle 11.2 RAC的ASM实例上创建10g库报错ORA-29701

Oracle 11.2 RAC的ASM实例上创建10g库报错ORA-29701

WBOY
WBOYOriginal
2016-06-07 16:46:281333browse

在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

linux

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn