Start the Default Instance in Oracle


How To Use "startup" Command to Start Default Instance in Oracle?



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:

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

Introduction to Oracle Database 10g Express Edition

⇑⇑ Oracle Database Tutorials

2020-09-15, 1553👍, 0💬