Create an Initialization Parameter File in Oracle

Q

How To Create an Initialization Parameter File in Oracle?

✍: FYIcenter.com

A

This is Step 3. To run an Oracle database as an Oracle instance, you need to create an initialization parameter file, which contains a set of initialization parameters.

The easiest way to create an initialization parameter file to copy from the sample file provided by Oracle. You can do this in a command window as shown below:

>cd $ORACLE_HOME

>copy .\config\scripts\init.ora .\database\initFYI_ini.ora

>edit .\database\initFYI_ini.ora
(replace XE by FYI)

In this example, only the SID is changed from XE to FYI. All other parameters are maintained as is.

 

Creating New Database Instance Manually

⇒⇒Oracle Database Tutorials

2016-10-17, 171👍, 0💬