11gR2RAC环境DBCA创建一个数据库错误ORA-15055 ORA-15001

时间:2023-01-15 12:38:18

11gR2RAC环境DBCA创建一个数据库错误ORA-15055 ORA-15001

象:

在11gR2 GridInfrastructure和Database软件安装完毕之后,运行DBCA创建数据库到30%的时候报例如以下错误,点击OK后提示忽略并停止安装。

11gR2RAC环境DBCA创建一个数据库错误ORA-15055 ORA-1500111gR2RAC环境DBCA创建一个数据库错误ORA-15055 ORA-15001

watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvd3V3ZWlsb25n/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">

问题分析:

     从上面的问题我们不难看出是由于无法訪问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建库,故障排除