Collections:
Start a Specific Oracle Instance in Oracle
How To Start a Specific Oracle Instance in Oracle?
✍: FYIcenter.com
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.
⇒ Start with a Minimum Initialization Parameter File in Oracle
⇐ Start an Oracle Instance in Oracle
2018-05-08, 3645🔥, 0💬
Popular Posts:
What Happens to the Current Transaction If a START TRANSACTION Is Executed in MySQL? If you are in a...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...