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.
⇒ Connect to Oracle Server as SYSDBA in Oracle
⇐ Establish Administrator Authentication to the Server in Oracle
2019-04-03, 1996🔥, 0💬
Popular Posts:
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...