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

最新推荐文章于 2025-12-04 15:25:15 发布

转载最新推荐文章于 2025-12-04 15:25:15 发布 · 130 阅读

文章标签：

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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-995587/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-995587/