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, 2056🔥, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...