Identify the types of information contained in the initialization file.
Oracle Initialization File and Parameters
The database initialization file is a text file containing a number of parameters that control how the Oracle database works.
At a very high-level, you could categorize those parameters as:
A pointer to the database control files
Information about the database itself, such as the physical block size used when reading and writing datafiles
Parameters that control the Oracle background processes
Parameters that control how Oracle allocates memory
Pointers to the directories containing the alert log and trace files for the instance
Here are some lines from a typical initialization file:
There are many parameters that you can set in the initialization file. Oracle documents all of them in the Oracle Server Reference Manual.
Look through the following SlideShow to learn about the most important parameters in a bit more detail:
Important Oracle Initialization Parameters
How the Initialization File works
Oracle reads the initialization file whenever you start an instance.
Any changes that you make to the initialization file afterwards will not take effect until you shut down and restart your system.
Strictly speaking, Oracle does not consider the initialization file to be part of a database.
here is why.
It is an important file though, and you want to preserve it with the same care that you do all the other files that are database files.
Initialization File - Exercise
First, click the Exercise link below to find and look at your database's initialization file. Initialization File - Exercise