天天看點

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.