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, 1676🔥, 0💬
Popular Posts:
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...