This problem occurs after the database is installed today. I searched the internet and found many posts to solve this problem,
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: cocould not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initora10g. ora'
Directly perform the following operations:
Cp/u01/app/oracle/admin/orcl/pfile/init. ora.823201112436/u01/app/oracle/product/10.2.0/db_1/dbs/initora10g. ora
In addition, pay attention to the following issues,
[Root @ localhost dbs] # ls-l
Total 64
-Rw-r ----- 1 oracle oinstall 1544 Sep 23 hc_orcl.dat
-Rw ---- 1 oracle oinstall 1544 Sep 23 hc_sandy.dat
-Rw-r ----- 1 oracle oinstall 12920 May 3 2001 initdw. ora
-Rw-r ----- 1 oracle oinstall 8385 Sep 11 1998 init. ora
-Rw-r ----- 1 root 2473 Sep 23 02: 27 initora10g. ora
-Rw-r ----- 1 oracle oinstall 24 Sep 23 0:22 lkORCL
-Rw ---- 1 oracle oinstall 24 Sep 23 0:31 lkSANDY
-Rw-r ----- 1 oracle oinstall 1536 Sep 23 orapworcl
-Rw-r ----- 1 oracle oinstall 1536 Sep 23 orapwsandy
-Rw-r ----- 1 oracle oinstall 2560 Sep 23 spfileorcl. ora
-Rw-r ----- 1 oracle oinstall 3584 Sep 23 spfilesandy. ora
Confirm the permission of this file. If the permission is different from the permission of the current file, modify the following:
[Root @ localhost dbs] # chown oracle: oinstall initora10g. ora
After the above operations, there should be no problem
Author "sandy"