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

2016-10-16, 314👍, 0💬

Popular Posts:

ROUND() - Rounding V...

How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...

Binary Literals in S...

What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...

READ_ONLY/READ_WRITE...

How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...

CONVERT() - Formatti...

How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...

Windows Applications...

How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect ...