spfile

1 让ORACLE自己主动从spfile启动
 SQL> create spfile='/dev/vx/rdsk/vgora/lv_spfile' from pfile;
 SQL> shutdown immediate;
 改动initora11g.ora文件
 /oracle/app/product/11g/db/dbs
 cp initora11g.ora initora11g.ora_bak
 echo SPFILE='/dev/vx/rdsk/vgora/lv_spfile' > initora11g.ora
 SQL> startup

 2 pfile路径
 /oracle/app/admin/ora11g/pfile

原文地址:https://www.cnblogs.com/claireyuancy/p/6917656.html