About the Location of the Initialization Parameter File

Describes the location of the initialization parameter file.

If you do not specify a different initialization file with the option PFILE at database startup, then by default Oracle Database uses initialization parameter files located in

ORACLE_HOME\Database\init.ora

Note:

If you create a database manually using an SQL script, then you are required to create an initialization parameter file or copy an existing initialization parameter file and modify the contents. If you use Database Configuration Assistant to create a database, then the initialization parameter file is automatically created for you.