Collections:
Start the Default Instance in Oracle
How To Use "startup" Command to Start Default Instance in Oracle?
✍: FYIcenter.com
If you logged in to the server as a SYSDBA, you start the default instance with the "startup" command. Here is how to start the default instance in SQL*Plus in SYSDBA mode:
>.\bin\sqlplus Enter user-name: SYSTEM/fyicenter AS SYSDBA Connected to an idle instance SQL> show instance instance "local" SQL> startup ORA-00821: Specified value of sga_target 16M is too small, needs to be at least 20M
Now the server is telling you more details about the memory problem on your default instance: your SGA setting of 16MB is too small. It must be increased to at least 20MB.
⇒ Instance Settings Stored in SPFile in Oracle
⇐ Login to Server without an Instance in Oracle
2020-09-15, 1706🔥, 0💬
Popular Posts:
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...