11gR2 RAC环境DBCA创建数据库报错ORA-15055 ORA-15001
问题现象:
在11gR2 Grid Infrastructure和Database软件安装完成之后,执行DBCA创建数据库到30%的时候报如下错误,点击OK后提示忽略并停止安装。
问题分析:
从上面的问题我们不难看出是因为无法访问ASM磁盘组导致,但是要解决该问题就得进入到ASM中去探个究竟,为什么刚装好的集群,建库就出现问题。
随即我们先通过grid用户登录到asm实例执行如下查询操作,我们发现磁盘组均为mount状态,说明磁盘组状态没有明显的问题。
- SQL> select name,state,type from v$asm_diskgroup;
-
- NAME STATE TYPE
- ------------------------------ ----------- ------
- OCR_VOTE MOUNTED HIGH
- DATA001 MOUNTED EXTERN
- FRA001 MOUNTED EXTERN
- BAK001 MOUNTED EXTERN
- 接下来我们通过amcmd登录到asm磁盘管理中进入到卷组+DATA001,这个时候我们同样看见了dbca创建数据库所生成的数据文件。
-
- [grid@db01 ~]$ asmcmd
- ASMCMD> cd DATA001
- ASMCMD> ls
- XMMAN/
- ASMCMD> cd XMMAN/
- ASMCMD> LS
- ASMCMD> ls
- DATAFILE/
- ASMCMD> cd DATAFILE/
- ASMCMD> ls
- SYSAUX.258.859553539
- SYSTEM.259.859553539
- UNDOTBS1.257.859553539
- USERS.256.859553539
- ASMCMD>
看到如上信息我们基本可以排除ASM的问题了,接来下可能考虑到是权限问题,尝试重新执行root.sh脚本。
问题解决:
重新执行如下脚本
- [root@db01 DBSoft]# /DBSoft/oracle/product/11.2.4/dbhome_1/root.sh
- Performing root user operation for Oracle 11g
-
- The following environment variables are set as:
- ORACLE_OWNER= oracle
- ORACLE_HOME= /DBSoft/oracle/product/11.2.4/dbhome_1
-
- Enter the full pathname of the local bin directory: [/usr/local/bin]:
- The contents of \"dbhome\" have not changed. No need to overwrite.
- The contents of \"oraenv\" have not changed. No need to overwrite.
- The contents of \"coraenv\" have not changed. No need to overwrite.
-
- Entries will be added to the /etc/oratab file as needed by
- Database Configuration Assistant when a database is created
- Finished running generic part of root script.
- Now product-specific root actions will be performed.
- Finished product-specific root actions.
- [root@db01 DBSoft]# pwd
- /DBSoft
再重新运行dbca建库,问题排除
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20674423/viewspace-1285969/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20674423/viewspace-1285969/