SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/data/oracle/product/11.2.0/db_1/dbs/initorcl.ora'
如下图：
解决办法：
cp /data/oracle/admin/orcl/pfile/init.ora.914201625650 /data/oracle/product/11.2.0/db_1/dbs/initorcl.ora
重新创建即可：
SQL> create spfile from pfile;
File created.
