DBCA创建数据库出现RPCR

在用DBCA创建数据库的时候,遇到了不少问题,下来来分析一下解决的过程:

先是到59%,以及往后,都会报一些错误,如RPCR-1071,PRCR-1066,CRS-2566 等,点“ok”确认会自动跳过,直到完成。但是最后加载数据库资源的时候还是会报错,先是提示ora.asm11g.db资源不存在,用srvctl手动添加数据库资源到CRS时,又报无法添加数据库资源,以及CRS-2566:Oracle用户没有权限去创建ora.one资源

 

DBCA创建数据库出现RPCR


 

DBCA创建数据库出现RPCR


 

DBCA创建数据库出现RPCR


 

DBCA创建数据库出现RPCR


 

 

DBCA创建数据库出现RPCR


 

Oracle用户添加不上数据库的资源,停止has提示权限不足

 

DBCA创建数据库出现RPCR

 

查看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]$ 

 

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/9e7e3fb9a4800b1dcf451ad609452120.html