Oracle - Start a Specific Oracle Instance in Oracle

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

Popular Posts:

Passing Values to St...

How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedu...

ISNULL() - Replacing...

How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...

DDL (Data Definition...

What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...

Creating Multi-State...

How To Create an Multi-Statement Table-Valued Function in SQL Server Transact-SQL? To create a multi...

sys.procedures - Lis...

How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...