O'Reilly logo

OCA: Oracle 10g™ Administration I: Study Guide by Matthew Weishan, Joseph C. Johnson, Bob Bryla, Chip Dawes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required