Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - Instance Settings Stored in SPFile
(Continued from previous topic...)
Where Are the Settings Stored for Each Instance?
Settings for each instance are stored in a file called Server Parameter File (SPFile).
Oracle supports two types of parameter files, Text type, and Binary type.
parameter files should be located in $ORACLE_HOME\database directory.
A parameter file should be named like "init$SID.ora", where $SID is the instance name.
(Continued on next topic...)
- What Is Oracle Database 10g Express Edition?
- What Are the Limitations of Oracle Database 10g XE?
- What Operating Systems Are Supported by Oracle Database 10g XE?
- How To Download Oracle Database 10g XE?
- How To Install Oracle Database 10g XE?
- How To Check Your Oracle Database 10g XE Installation?
- How To Shutdown Your 10g XE Server?
- How To Start Your 10g XE Server?
- How Much Memory Your 10g XE Server Is Using?
- How To Start Your 10g XE Server from Command Line?
- How To Shutdown Your 10g XE Server from Command Line?
- How To Unlock the Sample User Account?
- How To Change System Global Area (SGA)?
- How To Change Program Global Area (PGA)?
- What Happens If You Set the SGA Too Low?
- What To Do If the StartDB.bat Failed to Start the XE Instance?
- How To Login to the Server without an Instance?
- How To Use "startup" Command to Start Default Instance?
- Where Are the Settings Stored for Each Instance?
- What To Do If the Binary SPFile Is Wrong for the Default Instance?
- How To Check the Server Version?