修改db_files后遇ORA-01105 ORA-01174 解决

修改db_files后遇ORA-01105 ORA-01174 解决

增加数据文件时遇

ORA-00059: maximum number of DB_FILES exceeded
查看db_files
SQL> show parameter db_files
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     200

查看数据库已添加的数据文件数量，发现达到了200个，需要修改db_files参数，大于200.
修改db_files
SQL> show parameter db_files;

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
db_files                             integer                200
SQL> alter system set db_files=300 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 2.6523E+10 bytes
Fixed Size                  2219288 bytes
Variable Size            2.0737E+10 bytes
Database Buffers         5704253440 bytes
Redo Buffers               80158720 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-01174: DB_FILES is 300 buts needs to be 200 to be compatible

原因是RAC的节点db_files 参数不一致

在其中一个节点的sqlplus 里只执行shutdown /startup，只是对改节点的instane起作用，不能分别重启实例，需要整个重启数据库
.用srvctl 重启数据库
[oracle@whdata1 ~]$ srvctl stop database -d PROD

[oracle@whdata1 ~]$ srvctl start database -d PROD

[oracle@whdata1 ~]$ sqlplus / as sysdba;
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 20 15:27:39 2018

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> 

分别在两个节点查看，DB_FILES已修改。

SQL> show parameter db_files;

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------

db_files                             integer                200