Home » RDBMS Server » Server Administration » pfile and spfile
pfile and spfile [message #53240] Fri, 06 September 2002 03:52 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
I understand it not required to bounce a oracle 9i database if changes are made to the init.ora file.
How is this possible? What are the steps to be followed?
What is the difference between a pfile and spfile?
Re: pfile and spfile [message #53241 is a reply to message #53240] Fri, 06 September 2002 04:29 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
with 9i certain initsid.ora parameters are dyanamic.!
ie..no need to bounce the database.
quoting the docs
Before Oracle9i, Oracle instances were always started using a text file called 
an init<SID>.ora. This file is by default located in the "$ORACLE_HOME/dbs"
directory.

In Oracle9i, Oracle has also introduced the 'SPFILE', which is a binary file 
stored on the database Server. Changes which are applied to the instance 
parameters may be persistent accross all startup/shutdown procedures.

In Oracle9i, you can startup the instance using either an spfile or an init.ora
file.

An Oracle9i instance may be started by:

    - default spfile          --> spfile<SID>.ora 
    - default init.ora file   --> init<SID>.ora 
    - specified init.ora file 
    - specified spfile

Previous Topic: Slow response from tnsping
Next Topic: ORA-03212: Temporary Segment cannot be created in locally-managed tablespace
Goto Forum:
  


Current Time: Fri Sep 20 00:51:55 CDT 2024