报错提示：ORA-15018 ORA-15017 ORA-15003

原创已于 2022-07-12 17:03:26 修改 · 875 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

于 2022-07-12 17:02:18 首次发布

RAC 专栏收录该内容

1 篇文章

订阅专栏

这篇博客主要介绍了如何解决Oracle数据库报错ORA-15018, ORA-15017, ORA-15003的问题。通过在racmhq-11gR2-N1和racmhq-11gR2-N2节点上执行$ORACLE_HOME/crs/install下的rootcrs.pl脚本进行卸载配置，强制关闭相关资源，最终成功停止并移除Oracle High Availability Services。" 128330216,5551545,Go语言入门：Mac平台安装与环境配置,"['golang', '学习', '编程', '开发环境', 'Mac']

报错提示：ORA-15018 ORA-15017 ORA-15003

解决方法：

[root@racmhq-11gR2-N1 opt]# cd $ORACLE_HOME/crs/install

[root@racmhq-11gR2-N1 install]# pwd

/u01/app/11.2.0/grid/crs/install

[root@racmhq-11gR2-N1 install]# ls rootcrs.pl

rootcrs.pl

[root@racmhq-11gR2-N1 install]# ./rootcrs.pl -deconfig -force

Using configuration parameter file: ./crsconfig_params

PRCR-1119 : Failed to look up CRS resources of ora.cluster_vip_net1.type type

PRCR-1068 : Failed to query resources

Cannot communicate with crsd

PRCR-1070 : Failed to check if resource ora.gsd is registered

Cannot communicate with crsd

PRCR-1070 : Failed to check if resource ora.ons is registered

Cannot communicate with crsd

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'racmhq-11gr2-n1'

CRS-2673: Attempting to stop 'ora.ctssd' on 'racmhq-11gr2-n1'

CRS-2673: Attempting to stop 'ora.asm' on 'racmhq-11gr2-n1'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'racmhq-11gr2-n1'

CRS-2677: Stop of 'ora.mdnsd' on 'racmhq-11gr2-n1' succeeded

CRS-2677: Stop of 'ora.asm' on 'racmhq-11gr2-n1' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'racmhq-11gr2-n1'

CRS-2677: Stop of 'ora.ctssd' on 'racmhq-11gr2-n1' succeeded

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'racmhq-11gr2-n1' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'racmhq-11gr2-n1'

CRS-2677: Stop of 'ora.cssd' on 'racmhq-11gr2-n1' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'racmhq-11gr2-n1'

CRS-2677: Stop of 'ora.gipcd' on 'racmhq-11gr2-n1' succeeded

CRS-2673: Attempting to stop 'ora.gpnpd' on 'racmhq-11gr2-n1'

CRS-2677: Stop of 'ora.gpnpd' on 'racmhq-11gr2-n1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'racmhq-11gr2-n1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

Successfully deconfigured Oracle clusterware stack on this node

[root@racmhq-11gR2-N2 install]# ./rootcrs.pl -deconfig -force

Using configuration parameter file: ./crsconfig_params

PRCR-1119 : Failed to look up CRS resources of ora.cluster_vip_net1.type type

PRCR-1068 : Failed to query resources

Cannot communicate with crsd

PRCR-1070 : Failed to check if resource ora.gsd is registered

Cannot communicate with crsd

PRCR-1070 : Failed to check if resource ora.ons is registered

Cannot communicate with crsd

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'racmhq-11gr2-n2'

CRS-2673: Attempting to stop 'ora.ctssd' on 'racmhq-11gr2-n2'

CRS-2673: Attempting to stop 'ora.asm' on 'racmhq-11gr2-n2'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'racmhq-11gr2-n2'

CRS-2677: Stop of 'ora.mdnsd' on 'racmhq-11gr2-n2' succeeded

CRS-2677: Stop of 'ora.asm' on 'racmhq-11gr2-n2' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'racmhq-11gr2-n2'

CRS-2677: Stop of 'ora.ctssd' on 'racmhq-11gr2-n2' succeeded

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'racmhq-11gr2-n2' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'racmhq-11gr2-n2'

CRS-2677: Stop of 'ora.cssd' on 'racmhq-11gr2-n2' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'racmhq-11gr2-n2'

CRS-2677: Stop of 'ora.gipcd' on 'racmhq-11gr2-n2' succeeded

CRS-2673: Attempting to stop 'ora.gpnpd' on 'racmhq-11gr2-n2'

CRS-2677: Stop of 'ora.gpnpd' on 'racmhq-11gr2-n2' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'racmhq-11gr2-n2' has completed

CRS-4133: Oracle High Availability Services has been stopped.

Successfully deconfigured Oracle clusterware stack on this node

最后重新执行root.sh（一个接一个的执行，不要同时执行）