Oracle - Create an Initialization Parameter File in Oracle

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, 517👍, 0💬

Start an Oracle Instance in Oracle
How To Start an Oracle Instance in Oracle? This is Step 6. Now you are ready to start the new Oracle Instance without any database. This instance will be used to create a database. Starting an instance without database can be done by using STARTUP NOMOUNT statement as shown below: >.\bin\sqlp... 2018-05-08, 629👍, 0💬

Bring a Tablespace Online in Oracle
How To Bring a Tablespace Online in Oracle? If you have brought a tablespace offline, now you want to make it available to users again, you can use the ALTER TABLESPACE ... ONLINE statement as shown in the following script: SQL> connect HR/fyicenter SQL> CREATE TABLESPACE my_space 2 DA... 2019-01-01, 589👍, 0💬

Bring a Tablespace Offline in Oracle
How To Bring a Tablespace Offline in Oracle? If you want to stop users using a tablespace, you can bring it offline using the ALTER TABLESPACE ... OFFLINE statement as shown in the following script: SQL> connect HR/fyicenter Connected. SQL> CREATE TABLESPACE my_space 2 DATAFILE '/temp/... 2019-01-01, 581👍, 0💬

Start a Specific Oracle Instance in Oracle
How To Start a Specific Oracle Instance in Oracle? A simple way to start a specific Oracle instance is to start the instance with the PFILE option as shown in the following example: >.\bin\sqlplus /nolog SQL> CONNECT / AS SYSDBA Connected. SQL> STARTUP NOMOUNT PFILE=$ORACLE_HOME... 2018-05-08, 569👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.