Basic Oracle Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
How To Start a Specific Oracle Instance?
Answer:
A simple way to start a specific Oracle instance is to start the instance with the PFILE option as shown in the following example:
>.insqlplus /nolog
SQL> CONNECT / AS SYSDBA
Connected.
SQL> STARTUP NOMOUNT
PFILE=$ORACLE_HOME/database/initggl_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.
>.insqlplus /nolog
SQL> CONNECT / AS SYSDBA
Connected.
SQL> STARTUP NOMOUNT
PFILE=$ORACLE_HOME/database/initggl_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.
Download Oracle Database Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How To Start an Oracle Instance? | How To Start Instance with a Minimal Initialization Parameter File? |