Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - Start the Default Instance
(Continued from previous topic...)
How To Use "startup" Command to Start Default Instance?
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
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.
(Continued on next topic...)
- What Is Oracle Database 10g Express Edition?
- What Are the Limitations of Oracle Database 10g XE?
- What Operating Systems Are Supported by Oracle Database 10g XE?
- How To Download Oracle Database 10g XE?
- How To Install Oracle Database 10g XE?
- How To Check Your Oracle Database 10g XE Installation?
- How To Shutdown Your 10g XE Server?
- How To Start Your 10g XE Server?
- How Much Memory Your 10g XE Server Is Using?
- How To Start Your 10g XE Server from Command Line?
- How To Shutdown Your 10g XE Server from Command Line?
- How To Unlock the Sample User Account?
- How To Change System Global Area (SGA)?
- How To Change Program Global Area (PGA)?
- What Happens If You Set the SGA Too Low?
- What To Do If the StartDB.bat Failed to Start the XE Instance?
- How To Login to the Server without an Instance?
- How To Use "startup" Command to Start Default Instance?
- Where Are the Settings Stored for Each Instance?
- What To Do If the Binary SPFile Is Wrong for the Default Instance?
- How To Check the Server Version?