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.

本文固定链接: http://www.dbdream.com.cn/2015/08/rac%e7%8e%af%e5%a2%83ora-01105%e3%80%81ora-01677%e9%94%99%e8%af%af/ | 信春哥，系统稳，闭眼上线不回滚！