首页 » ORACLE » Troubleshooting db instance start failed PRCR-1064 CRS-2643 or CRS-2717 CRS-0223 during patching

Troubleshooting db instance start failed PRCR-1064 CRS-2643 or CRS-2717 CRS-0223 during patching

12c注意 instance terminal caused by ASMB process ORA-04031 init_heap_kfsg上篇提到了这个bug,在安装bug是不是很顺利分享一下。

第一报错在安装GI的patch 31341859 时提示lib/libserver12.a 不存在,解决方法,从其它节点复制一个重新安装就Ok.

第二个报错rootcrs.pl -prepatch脚本是报错终止, 然后想暂时启实例回头再测,启动实例失败.

oracle@anbob2:/oracle/app/oracle/product/12.2.0.1/dbhome_1/dbs> $ORACLE_HOME/bin/srvctl start instance -d stbydb  -n anbob2
PRCR-1013 : Failed to start resource ora.stbydb.db
PRCR-1064 : Failed to start resource ora.stbydb.db on node anbob2
CRS-2643: The server pool(s) where resource 'ora.stbydb.db' could run have no servers

sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 4 16:23:30 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-39510: CRS error performing start on instance 'tbcsa2' on 'stbydb'
CRS-2717: Server 'anbob2' is not in any of the server pool(s) hosting resource 'ora.stbydb.db'
CRS-0223: Resource 'ora.stbydb.db' has placement error.
clsr_start_resource:260 status:223
clsrapi_start_db:start_asmdbs status:223

有种情况时“rootcrs.pl -prepatch”脚本会把RESOURCE_USE_ENABLED标志改为0, 在后面”rootcrs.pl -postpatch”脚本后才回修改回1, 需要修改为1然后重启GI stack.

anbob2:[/]#crsctl get resource use
CRS-4966: Current resource use parameter value is 1 --(if it's 0)

anbob2:[/]#crsctl set resource use 1
CRS-4416: Server attribute 'RESOURCE_USE_ENABLED' successfully changed. Restart Oracle High Availability Services for new value to take effect.

anbob2:[/]#crsctl stop crs

anbob2:[/]#crsctl  start crs

恢复正常

打赏

, ,

对不起,这篇文章暂时关闭评论。