在用DBCA创建数据库的时候,遇到了不少问题,下来来分析一下解决的过程:
先是到59%,以及往后,都会报一些错误,如RPCR-1071,PRCR-1066,CRS-2566 等,点“ok”确认会自动跳过,直到完成。但是最后加载数据库资源的时候还是会报错,先是提示ora.asm11g.db资源不存在,用srvctl手动添加数据库资源到CRS时,又报无法添加数据库资源,以及CRS-2566:Oracle用户没有权限去创建ora.one资源
用Oracle用户添加不上数据库的资源,停止has提示权限不足
查看dbca的安装过程日志:
[oracle@zlm ~]$ tail -3000f /u01/app/oracle/cfgtoollogs/dbca/asm11g/trace.log|grep PRCR
[Thread-168] [ 2015-01-06 17:45:07.740 CST ] [HASIDBRegistrationStep.executeImpl:253] Exception while registering with HAS PRCR-1006 : Failed to add resource ora.asm11g.db for asm11g
PRCR-1071 : Failed to register or update resource ora.asm11g.db
PRCR-1001 : Resource ora.asm11g.db does not exist
也都是报资源不存在,添加和注册数据库资源失败,用grid用户重启一下has
[grid@zlm bin]$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'zlm'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'zlm'
CRS-2677: Stop of 'ora.DATA.dg' on 'zlm' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'zlm'
CRS-2677: Stop of 'ora.asm' on 'zlm' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'zlm'
CRS-2677: Stop of 'ora.cssd' on 'zlm' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'zlm'
CRS-2677: Stop of 'ora.evmd' on 'zlm' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'zlm' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[grid@zlm bin]$ crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[grid@zlm bin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE zlm
ora.asm ora.asm.type ONLINE ONLINE zlm
ora.cssd ora.cssd.type ONLINE ONLINE zlm
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE zlm
ora.ons ora.ons.type OFFLINE OFFLINE
[oracle@zlm asm11g]$ srvctl add database -d asm11g -o $ORACLE_HOME--没有报错,资源添加上了
[oracle@zlm asm11g]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE zlm
ora.asm ora.asm.type ONLINE ONLINE zlm
ora.asm11g.db ora....se.type OFFLINE OFFLINE
ora.cssd ora.cssd.type ONLINE ONLINE zlm
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE zlm
ora.ons ora.ons.type OFFLINE OFFLINE
[oracle@zlm asm11g]$ srvctl start database -d asm11g
PRCR-1079 : Failed to start resource ora.asm11g.db
ORA-12547: TNS:lost contact
CRS-5017: The resource action "ora.asm11g.db start" encountered the following error:
ORA-12547: TNS:lost contact
. For details refer to "(:CLSN00107:)" in "/g01/app/11.2.0/grid/log/zlm/agent/ohasd/oraagent_grid/oraagent_grid.log".
CRS-2674: Start of 'ora.asm11g.db' on 'zlm' failed
ORA-12547: TNS:lost contact
[oracle@zlm asm11g]$