oracle rac ora-01105,RAC环境ORA-01105、ORA-01677错误 | 信春哥，系统稳，闭眼上线不回滚！...

RAC环境在修改参数后，重启一个节点遇到ORA-01105和ORA-01677错误。数据库版本11.2.0.4。具体操作如下，以下操作在节点1。

SQL> alter system set db_file_name_convert='+DATA/erpdb/datafile/','/u01/app/oracle/oradata/erpdb/','+DATA/erpdb/tempfile/','/u01/app/oracle/oradata/erpdb/' scope=spfile sid='*';

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 7.0283E+10 bytes

Fixed Size 2260368 bytes

Variable Size 1.5032E+10 bytes

Database Buffers 5.5029E+10 bytes

Redo Buffers 219426816 bytes

ORA-01105: mount is incompatible with mounts by other instances

ORA-01677: standby file name convert parameters differ from other instance

这是因为节点1重启后，新修改的参数已经生效，而节点2此时没有重启，使用的还是旧的参数，两边不一致。关闭或重启节点2，节点1可以成功启动。

[oracle@SL010M6-DB-ERPDB2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 11 10:26:59 2015

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 7.0283E+10 bytes

Fixed Size 2260368 bytes

Variable Size 1.5301E+10 bytes

Database Buffers 5.4761E+10 bytes

Redo Buffers 219426816 bytes

Database mounted.

Database opened.

节点2关闭或重启后，节点1可正常启动。

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.