Collections:
Create an Initialization Parameter File in Oracle
How To Create an Initialization Parameter File in Oracle?
✍: FYIcenter.com
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.
2019-04-03, 945👍, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...