数据库连接到ASM实例权限不足
2010-07-01 23:37:39
原创作品,允许转载,转载时请务必以超链接形式标明文章
原始出处 、作者信息和本声明。否则将追究法律责任。
http://guojuanjun.blog.51cto.com/277646/342534
今天启动数据库到MOUNT时,报
ORA-00205: error in identifying control file, check alert log for more info
打开ALERT.Log:
ALTER DATABASE MOUNT
Thu Jul 01 23:01:22 2010
Starting background process ASMB
ASMB started with pid=16, OS id=3644
Thu Jul 01 23:01:23 2010
ORA-00202: control file: '+DGGROUP/study/controlfile/current.257.722711849'
ORA-17503: ksfdopn:2 Failed to open file +DGGROUP/study/controlfile/current.257.722711849
ORA-15001: diskgroup "DGGROUP" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges
Thu Jul 01 23:01:22 2010
Starting background process ASMB
ASMB started with pid=16, OS id=3644
Thu Jul 01 23:01:23 2010
ORA-00202: control file: '+DGGROUP/study/controlfile/current.257.722711849'
ORA-17503: ksfdopn:2 Failed to open file +DGGROUP/study/controlfile/current.257.722711849
ORA-15001: diskgroup "DGGROUP" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges
Thu Jul 01 23:01:23 2010
ORA-205 signalled during: ALTER DATABASE MOUNT...
ORA-205 signalled during: ALTER DATABASE MOUNT...
试用ASMCMD,报ORA-01031。
解决方法:
在WINDOWS上,SQLNET.AUTHENTICATION_SERVICES 必须设定为NTS 才能连接上ASM。ASMCMD同样成功。
本文出自 “天下无贼” 博客,请务必保留此出处http://guojuanjun.blog.51cto.com/277646/342534