修改及配置多个controlfile时出现报错

ORA-00202: control file:

ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory

alter system set control_files='/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g01.ctl',

'/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g02.ctl',

'/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g03.ctl' scope=spfile;

[@more@]

当database 处于open status 时可以用alter system set control_files='/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g01.ctl',

'/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g02.ctl',

'/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g03.ctl' scope=spfile; 来设置初始化文件中的控制文件参数,如下的报错出现就是因为设置control_files='/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g01.ctl,

/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g02.ctl,

/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g03.ctl' 错误;

有时候数据库系统启动时找不到默认的第一个spfile<sid>.ora时就会去找spfile.ora,如果也找不到的话,才会找到init<sid>.ora;

所以为保证加载成功:

SQL>startup nomount;

SQL>alter system set control_files='/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g01.ctl',

'/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g02.ctl',

'/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g03.ctl' scope=spfile;

SQL>create pfile from spfile;

==============错误描述=================

starting up 1 shared server(s) ...
Tue May 6 09:22:55 2008
ALTER SYSTEM SET control_files='/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g01.ctl',

'/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g02.ctl',

'/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g03.ctl' SCOPE=SPFILE;
Tue May 6 09:23:11 2008
alter database mount
Tue May 6 09:23:11 2008
ORA-00202: control file: '/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g01.ctl,

/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g02.ctl,

/opt/ora10g/oradata/ORA10G/controlfile/control_ora10g03.ctl'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory