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, 3738🔥, 0💬
Popular Posts:
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...