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, 1767🔥, 0💬
Popular Posts:
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...