Oracle DB Start and Stop

Oracle DB Start and Stop 

SQL> startup;            //mounts and opens DB (ex. Open MS word and also file)

SQL>startup mount;        //starts DB in mount state (ex. Open MS word application)

SQL> shutdown immediate;    

SQL>shutdown abort;

 Process:

• Nomount: Only control files are loaded (no datafiles)
• Mount: Datafiles are loaded
• Open: Datafiles are opened in read/write mode