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.