天天看点

ORA-01078: failure in processing system parameters & LRM-00109: could not open parameter file

安装了oracle 12c后,启动数据库的过程中出现如下错误

sql> startup

ora-01078: failure in processing system parameters

lrm-00109: could not open parameter file '/u01/app/oracle/product/12.1.0/db_1/dbs/initepps.ora'

[oracle@gettestlnx01 ignite]$ cd /u01/app/oracle/product/12.1.0/db_1/dbs/

现在

/u01/app/oracle/product/12.1.0/db_1/dbs/下找不到initepps.ora文件,于是

去$oracle_home/admin/ignite/pfile下,找到文件init.ora.1242014234024,然后将文件拷贝到

/u01/app/oracle/product/12.1.0/db_1/dbs/目录下,并重命名为initepps.ora后,重启数据,问题解

决!

[oracle@gettestlnx01 dbs]$ cd /u01/app/oracle/admin/ignite/pfile

[oracle@gettestlnx01 pfile]$ ls

init.ora.1242014234024

[oracle@gettestlnx01 pfile]$ cp init.ora.1242014234024  /u01/app/oracle/product/12.1.0/db_1/dbs/initepps.ora

oracle instance started.

total system global area 1870647296 bytes

fixed size                  2289640 bytes

variable size             587202584 bytes

database buffers         1275068416 bytes

redo buffers                6086656 bytes

database mounted.

database opened.