Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Start the Default Instance

By: FYIcenter.com

(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:

>.\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.

(Continued on next topic...)

  1. What Is Oracle Database 10g Express Edition?
  2. What Are the Limitations of Oracle Database 10g XE?
  3. What Operating Systems Are Supported by Oracle Database 10g XE?
  4. How To Download Oracle Database 10g XE?
  5. How To Install Oracle Database 10g XE?
  6. How To Check Your Oracle Database 10g XE Installation?
  7. How To Shutdown Your 10g XE Server?
  8. How To Start Your 10g XE Server?
  9. How Much Memory Your 10g XE Server Is Using?
  10. How To Start Your 10g XE Server from Command Line?
  11. How To Shutdown Your 10g XE Server from Command Line?
  12. How To Unlock the Sample User Account?
  13. How To Change System Global Area (SGA)?
  14. How To Change Program Global Area (PGA)?
  15. What Happens If You Set the SGA Too Low?
  16. What To Do If the StartDB.bat Failed to Start the XE Instance?
  17. How To Login to the Server without an Instance?
  18. How To Use "startup" Command to Start Default Instance?
  19. Where Are the Settings Stored for Each Instance?
  20. What To Do If the Binary SPFile Is Wrong for the Default Instance?
  21. How To Check the Server Version?

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...