2.3. Managing Parameter Initialization Files

Oracle uses parameter initialization files to store information about initialization parameters used when an Oracle instance starts. Oracle reads the parameter file to obtain information about how the Oracle instance should be sized and configured upon startup.

As you learned in Chapter 1, the parameter file can be either a plain text file, commonly referred to as a PFILE, or it can be a binary parameter file, commonly referred to as an SPFILE. The default location that Oracle searches to find the PFILE and SPFILE parameter files is $ORACLE_HOME/dbs on Unix systems and %ORACLE_HOME%/database on Windows systems.

Oracle uses a search hierarchy when a startup command is issued without specifying either ...

Get OCA: Oracle 10g™ Administration I: Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.