今天遇到一起因ASM相关信息未完全删除导致在重新部署ASM时报错,RAC无法正常部署问题。将该案例记录在此。
1.问题现象
部署安装RAC,在创建ASM实例的时候报提示如下错误:
截图信息
提示信息:“The ASM instance configured on the local node is a single-instance ASM. To manage this instance as a single-instance ASM, restart DBCA and select the Single-instance database option. To manage this instance as a RAC ASM, convert it to RAC ASM first.”
问题提示:在此节点上已经配置过ASM实例,并且是单实例的ASM,同时提到需要将其调整为RAC ASM。
在此报错下,安装无法继续进行!
2.问题分析
该问题可以从提示中“configured”(配置过)单词入手,既然在此节点中已经有此配置信息,这些配置信息会存在何处?
3.问题原因
由于这次是在删除ASM安装文件后重新部署的,因此有些信息可能没有删除完整。导致此次问题的原因是“/etc/oratab”文件,该文件中记录了上次安装的ASM信息。该文件内容如下。
[root@rac1 ~]# cat /etc/oratab
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form.:
# $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
+ASM1:/oracle/app/oracle/product/10.2.0/db_1:N
4.问题处理
仅需将“/etc/oratab”文件删除,或将其中的“+ASM1:/oracle/app/oracle/product/10.2.0/db_1:N”内容删除即可。
清理之后,重新使用DBCA创建便可。
5.小结
文中提到的问题是由于清理不全面导致的。除“/etc/oratab”中的记录会导致该问题发生外,$ORACLE_BASE/admin/+ASM目录下的信息如果未清理也有可能导致该问题的发生。
Good luck.
secooler
10.10.20
-- The End --
1.问题现象
部署安装RAC,在创建ASM实例的时候报提示如下错误:
截图信息
提示信息:“The ASM instance configured on the local node is a single-instance ASM. To manage this instance as a single-instance ASM, restart DBCA and select the Single-instance database option. To manage this instance as a RAC ASM, convert it to RAC ASM first.”
问题提示:在此节点上已经配置过ASM实例,并且是单实例的ASM,同时提到需要将其调整为RAC ASM。
在此报错下,安装无法继续进行!
2.问题分析
该问题可以从提示中“configured”(配置过)单词入手,既然在此节点中已经有此配置信息,这些配置信息会存在何处?
3.问题原因
由于这次是在删除ASM安装文件后重新部署的,因此有些信息可能没有删除完整。导致此次问题的原因是“/etc/oratab”文件,该文件中记录了上次安装的ASM信息。该文件内容如下。
[root@rac1 ~]# cat /etc/oratab
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form.:
# $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
+ASM1:/oracle/app/oracle/product/10.2.0/db_1:N
4.问题处理
仅需将“/etc/oratab”文件删除,或将其中的“+ASM1:/oracle/app/oracle/product/10.2.0/db_1:N”内容删除即可。
清理之后,重新使用DBCA创建便可。
5.小结
文中提到的问题是由于清理不全面导致的。除“/etc/oratab”中的记录会导致该问题发生外,$ORACLE_BASE/admin/+ASM目录下的信息如果未清理也有可能导致该问题的发生。
Good luck.
secooler
10.10.20
-- The End --
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/519536/viewspace-676446/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/519536/viewspace-676446/