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.
2018-05-08, 868👍, 0💬
Popular Posts:
How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Count Duplicated Values in a Column in SQL Server? If you have a column with duplicated value...
How To Concatenate Two Text Values in Oracle? There are two ways to concatenate two text values toge...