oracle创建orcl失败,prcr-1079:failed to start resource ora.orcl.db错误的解决办法

使用DBCA创建数据库，到90%多的时候就报错

prcr-1079:failed to start resource ora.orcl.db

CRS-2674:start of 'ora.orcl.db'on'goldengate1'failed

查看日志

/u01/app/oracle/cfgtoollogs/dbca/ORCL/trace.log

Failed to start resource: Name: ora.orcl.db, node: null, filter: null, msg CRS-2674: Start of 'ora.orcl.db' on 'goldengate1' failed

查看crs的状态

[grid@goldengate1 ~]$ crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora.DATA.dg    ora....up.type ONLINE    ONLINE    goldengate1

ora....ER.lsnr ora....er.type ONLINE    ONLINE    goldengate1

ora.asm        ora.asm.type   ONLINE    ONLINE    goldengate1

ora.cssd       ora.cssd.type  ONLINE    ONLINE    goldengate1

ora.diskmon    ora....on.type ONLINE    ONLINE    goldengate1

ora.orcl.db    ora....se.type ONLINE    OFFLINE

网上找到的错误可能原因

Possible causes:

1.Grid Infrastructure owner is not  part of OSDBA group for the database thats being start up.

2.Grid Infrastructure owner dosen't have write permission to database dbs($ORACLE_HOME/dbs) directory.

OSDBA group当前是DBA，dbs目录属于oinstall组，grid用户不属于oinstall

usermod -a -G oinstall grid --将用户grid添加到dba组，这里-a必须加，不然grid的原有组会清除

srvctl start database -d orcl  --重启数据库

再查看状态，问题解决

[grid@goldengate1 ~]$ crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora.DATA.dg    ora....up.type ONLINE    ONLINE    goldengate1

ora....ER.lsnr ora....er.type ONLINE    ONLINE    goldengate1

ora.asm        ora.asm.type   ONLINE    ONLINE    goldengate1

ora.cssd       ora.cssd.type  ONLINE    ONLINE    goldengate1

ora.diskmon    ora....on.type ONLINE    ONLINE    goldengate1

ora.orcl.db    ora....se.type ONLINE    ONLINE    goldengate1