重庆思庄Oracle、Redhat认证学习论坛

标题: The Database Instance Cannot Be Started with ORA-29707 [打印本页]

作者: 刘泽宇 时间: 2023-7-30 11:40
标题: The Database Instance Cannot Be Started with ORA-29707
现象：
On : 12.2.0.1 version, Real Application Cluster

The database instance cannot be started with ORA-29707

SQL> startup
ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated
ORA-29707: inconsistent value 0 for initialization parameter _lm_use_tx_tsn with other instances
SQL>

变动：
The customer changed hidden parameter of DRM.

原因：
In order for this parameter to take effect, all instances must be stopped and then startup.

SQL> alter system set "_gc_undo_affinity" = FALSE scope=spfile sid='*';

System altered.

SQL> alter system set "_gc_policy_time" = 0 scope=spfile sid='*';

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-29707: inconsistent value 0 for initialization parameter _lm_use_tx_tsn with other instances
SQL>

处理方法：
Reset the hidden parameters.

1. Reset parameter on surviving node.

SQL> alter system reset "_gc_undo_affinity";

SQL> alter system reset "_gc_policy_time";

2. Startup effect instance.

SQL>startup

或者：

Shutdown all instances and restart all of them.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)