Step 4: Create the Initialization Parameter File

When an Oracle instance starts, it reads an initialization parameter file. This file can be a text file, which can be created and modified with a text editor, or a binary file, which is created and dynamically modified by the database. The binary file, which is preferred, is called a server parameter file. In this step, you create a text initialization parameter file. In a later step, you create a server parameter file from the text file.

dell emc training courses malaysia

  • Create the initialization parameter file.

One way to create the text initialization parameter file is to edit the sample presented in “Sample Initialization Parameter File”.

CompTIA training courses malaysia

If you create the initialization parameter file manually, ensure that it contains at least the parameters listed in Table 2-2. All other parameters not listed have default values.

citrix training courses malaysia

For convenience, store your initialization parameter file in the Oracle Database default location, using the default file name. Then when you start your database, it will not be necessary to specify the PFILE clause of the STARTUP command, because Oracle Database automatically looks in the default location for the initialization parameter file.

citrix certification malaysia

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *