Step 5: Create a Server Parameter File (Recommended) (63)

Oracle recommends that you create a server parameter file. The server parameter file
enables you to change initialization parameters with database commands and persist
the changes across a shutdown and startup. You create the server parameter file from
your edited text initialization file.

The following script creates a server parameter file from the text initialization
parameter file and writes it to the default location. The script can be executed before or
after instance startup, but after you connect as SYSDBA. The database must be
restarted before the server parameter file takes effect.
-- create the server parameter file
CREATE SPFILE='/u01/oracle/dbs/spfilemynewdb.ora' FROM
PFILE='/u01/oracle/admin/initmynewdb/scripts/init.ora';
SHUTDOWN
-- the next startup will use the server parameter file
EXIT

第五步 : 建立服務引數檔案

[@more@]