Collections:
Start an Oracle Instance in Oracle
How To Start an Oracle Instance in Oracle?
✍: FYIcenter.com
This is Step 6. Now you are ready to start the new Oracle Instance without any database. This instance will be used to create a database. Starting an instance without database can be done by using STARTUP NOMOUNT statement as shown below:
>.\bin\sqlplus /nolog SQL> CONNECT / AS SYSDBA Connected. SQL> SHUTDOWN ORACLE instance shut down. SQL> STARTUP NOMOUNT ORA-00821: Specified value of sga_target 16M is too small, needs to be at least 20M
The SHUTDOWN command is need to bring the default instance XE down.
The STARTUP NOMOUNT command failed because it tried to start the default instance XE, and there is a bad parameter in the XE instance SPFile.
See the next FAQ question to find another way to start the new instance FYI.
⇒ Start a Specific Oracle Instance in Oracle
⇐ Create a Server Parameter File in Oracle
2018-05-08, 1747🔥, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...