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_s

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