首页 » Cloud, ORACLE 9i-23ai » Troubleshooting ORA-32000 when modify ASM spfile (oracle 19.11)

Troubleshooting ORA-32000 when modify ASM spfile (oracle 19.11)

昨天在配置ASM instance参数时发现参数无法修改,提示ora-32000,即使是grid sysasm, 环境是新安装的oracle RAC,最近刚安装的19c 11RU,也并非是19.11 RU的新特性,主要还是安装过程中出过问题AUTOupgrade 失败,手动处理,没有更新集群状态。简单记录

grid# sqlplus / as sysasm
SQL>alter system set memory_target=1536m scope=spfile;
ERROR at line 1:
ORA-32000: write to SPFILE requested but SPFILE is not modifiable

这个问题的原因通常是是集群或ASM实例处理rolling patching滚动升级阶段,该阶段不允许修改spfile参数,因为可能在升级后不同版本对参数不支持或带来不同的影响。

检查状态

Last login: Thu Jul  1 16:19:55 CST 2021
[grid@anbob5 ~]$  crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [724960844].
[grid@anbob5 ~]$ 

[grid@anbob6 ~]$ crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [724960844].
[grid@anbob6 ~]$ 

SQL> SELECT SYS_CONTEXT('SYS_CLUSTER_PROPERTIES', 'CLUSTER_STATE') FROM DUAL;

SYS_CONTEXT('SYS_CLUSTER_PROPERTIES','CLUSTER_STATE')
--------------------------------------------------------------------------------
In Rolling Patch

Note:
注意当前处于ROLLING PATCH阶段,同时版本号为724960844, 同一CLUSTER的不同节点相同,如果确认当前补丁已安装完成,可以手动结束ROLLING PATCH到normal模式。

[root@anbob5 ~]# crsctl stop rollingpatch
CRS-1161: The cluster was successfully patched to patch level [3331580692].
[root@anbob5 ~]# su - grid
Last login: Thu Jul  1 16:52:26 CST 2021
[grid@anbob5 ~]$ crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [3331580692].
[grid@anbob5 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jul 1 16:53:45 2021
Version 19.11.0.0.0
Copyright (c) 1982, 2020, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0

SQL> SELECT SYS_CONTEXT('SYS_CLUSTER_PROPERTIES', 'CLUSTER_STATE') FROM DUAL;

SYS_CONTEXT('SYS_CLUSTER_PROPERTIES','CLUSTER_STATE')
--------------------------------------------------------------------------------
Normal

以上操作只在一个节点执行即可, 通常正常升级,是在最后一个节点AUTOUPGRADE时脚本中自动判断,结束Rolling Patch。 另外建议对比oracle binary file 大小确实升级正常。

打赏

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