新装GI的ASM无法直接restore/11g以前RDBMS无法直接访问11gASM

来源：互联网发布：java的volatile 编辑：程序博客网时间：2024/04/30 04:32

1.当新的数据库软件安装成功后，如果我们不使用DBCA进行建库而使用restore等方式往ASM里面写东西需要调整$ORACLE_HOME/bin/oracle文件权限:

# su - grid
$ cat $ORACLE_HOME/rdbms/lib/config.[sc] | grep -i SS_ASM_GRP
$ $ORACLE_HOME/bin/setasmgidwrap o=/orastg/app/oracle/product/11.2.0/db_1/bin/oracle
$ $ORACLE_HOME/bin/setasmgidwrap o=/orastg/app/oracle/product/10.2/db_1/bin/oracle

2.使用11g以前的RDBMS来访问11gASM,会因为ASM和数据库实例之间配置动态化出现如下报错:

ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '+DG_DATA/racdb/control01.ctl'
ORA-17502: ksfdcre:4 Failed to create file +DG_DATA/racdb/control01.ctl
ORA-15001: diskgroup "DG_DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup

ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/prod/spfileprod.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/prod/spfileprod.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager

参照文档:Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment (文档 ID 948456.1)
===================
1).pin住ASM配置方式(在装pre-11g软件节点执行)
===================
# /orastg/app/11.2.0/grid/bin/olsnodes -n -t
# /orastg/app/11.2.0/grid/bin/crsctl pin css -n p740a
# /orastg/app/11.2.0/grid/bin/olsnodes -n -t

==================
2).重启集群生效(停掉监听):
====================
# /orastg/app/11.2.0/grid/bin/crsctl stop crs
# /orastg/app/11.2.0/grid/bin/crsctl start crs
# /orastg/app/11.2.0/grid/bin/olsnodes -n -t

0 0