ora-01078 failure in processing system parameters 的原因及解决思路
[root@itlife365.com ~]# su - oracle
[oracle@itlife365.com ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Feb 20 15:36:30 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '/home/db/oracle/oradata/itlife365db/rspfile_128m'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SQL>
解决方法:
1、环境变量问题
此错误由环境变量设置错误引起，一般情况下是由于用户安装oracle时更改了默认的SID，所以只更改oracle的.bash_profile文件中的SID设置即可。
2、参数文件丢失
/home/db/oracle/oradata/itlife365db/rspfile_128m
从备份中还原
