连接数据库时提示ORA-01078: failure in processing system parameters

 

SQL> conn / as sysdba

已连接到空闲例程。

SQL> startup

ORA-01078: failure in processing system parameters

LRM-00109: ???????????????? 'D:/ORACLE/PRODUCT/10.2.0/DB_1/DATABASE/INITSNOOPY93

.ORA'

到D:/ORACLE/PRODUCT/10.2.0/DB_1/DATABASE/下发现少了initsnooopy93.ora这个文件（初始化参数文件）

只要把D:/oracle/product/10.2.0/db_1/admin/snoopy93/pfile下的init.ora.1222011135539文件拷贝到D:/ORACLE/PRODUCT/10.2.0/DB_1/DATABASE/下并改名为initsnooopy93.ora即可