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, 2265🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...