Understanding Initialization Parameters (85)

最新推荐文章于 2025-12-09 09:24:19 发布

转载最新推荐文章于 2025-12-09 09:24:19 发布 · 79 阅读

文章标签：

本文介绍了Oracle实例启动时读取初始化参数的过程及所使用的文件类型。主要讲解了文本初始化参数文件和服务器参数文件的区别，以及如何创建和使用服务器参数文件。还提供了不同操作系统下参数文件的默认位置和名称。

When an Oracle instance starts, it reads initialization parameters from an initialization
parameter file. This file can be either a read-only text file, or a read/write binary file.
The binary file is called a server parameter file, and it always resides on the server. A
server parameter file enables you to change initialization parameters with ALTER
SYSTEM commands and to persist the changes across a shutdown and startup. It also
provides a basis for self-tuning by the Oracle Database server. For these reasons, it is
recommended that you use a server parameter file. You can create one from your
edited text initialization file or by using the Database Configuration Assistant.

Before you create a server parameter file, you can start an instance with a text
initialization parameter file. Upon startup, the Oracle instance first searches for a
server parameter file in a default location, and if it does not find one, searches for a
text initialization parameter file. You can also override an existing server parameter
file by naming a text initialization parameter file as an argument of the STARTUP
command .

Default file names and locations for the text initialization parameter file are shown in
the following table:

Platform Default Name Default Location
UNIX and Linux init$ORACLE_SID.ora $ORACLE_HOME/dbs
Windows init%ORACLE_SID%.ora %ORACLE_HOME%database

参数化参数文件
1. 使用spfile
2. Windows下默认的位置和名称为%ORACLE_HOME%database : init%ORACLE_SID%.ora

[@more@]

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

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