Start a Specific Oracle Instance in Oracle

Q

How To Start a Specific Oracle Instance in Oracle?

✍: FYIcenter.com

A

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/database/initFYI_ini.ora

ORA-02778: Name given for the log directory is invalid

The PFILE option allows you to specify the initialization parameter file of a specific Oracle instance. But the initialization parameter file created in Step 3 has some problem with the log directory.

Â

â‡’Creating New Database Instance Manually

â‡’â‡’Oracle Database Tutorials

2018-05-08, 1088👍, 0💬

Create a Server Parameter File in Oracle
How To Create a Server Parameter File in Oracle? This is Step 5. The initialization parameter file is good to get an Oracle database instance started. But it is not ideal run an instance as production. You need to convert the initialization parameter file into a Server Parameter File (SPFile) using ... 2018-05-08, 1275👍, 0💬

Connect to Oracle Server as SYSDBA in Oracle
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the Oracle server as an administrator is to use SQL*Plus. You need to run SQL*Plus with /nolog option and use the CONNECT with blank user name, blank password and AS SYSDBA option. Here is a sample sessi... 2019-04-03, 1258👍, 0💬

Create an Initialization Parameter File in Oracle
How To Create an Initialization Parameter File in Oracle? 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 t... 2019-04-03, 1250👍, 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, 1210👍, 0💬

Running CREATE DATABASE Statement Again in Oracle
How To Run CREATE DATABASE Statement Again in Oracle? After cleaning up the results of a previously failed CREATE DATABASE statement, you can run the CREATE DATABASE statement again as shown below: SQL> @$ORACLE_HOME\config\scripts\c reate_database_fyi.sql;CREATE DATABASE FYI * ERROR at line ... 2019-03-27, 1128👍, 0💬

Establish Administrator Authentication to the Server in Oracle
How To Establish Administrator Authentication to the Server in Oracle? This is Step 2. There are two ways to establish administrator authentication to a new database. Use a password file. Use operating system (OS) authentication. Using OS authentication is easier on Windows system. If you used your ... 2019-04-03, 1103👍, 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, 1089👍, 0💬

Run CREATE DATABASE Statement in Oracle
How To Run CREATE DATABASE Statement in Oracle? This is Step 7. Oracle Administrator Guide provided a sample CREATE DATABASE statement. But it is a long statement. You can modify and same it in a file, $ORACLE_HOME/configscripts/cre ate_database_fyi.sql,and run the file within SQL*Plus. Here is a co... 2018-05-08, 1072👍, 0💬

Clean Up When CREATE DATABASE Failed in Oracle
How To Do Clean Up If CREATE DATABASE Failed in Oracle? To better organize data files, you should create a dedicated directory for each Oracle database. This can be done by using Windows file explorer to create the \oraclexe\oradata\fyi\ directory. Try the CREATE DATABASE statement again, when you h... 2019-03-27, 1036👍, 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.