Restart Oracle Database

Like most things in the world of computing, our database may need to be restarted.

To restart Oracle:

  1. Open a new terminal (or Konsole) window
  2. Switch to the root user: sudo su
  3. Enter the password (note it will not show you typing but it is working)
  4. Switch to the oracle user: su oracle
  5. Launch sqlplus with elevated privileges: sqlplus / as sysdba
  6. Shutdown the database: SHUTDOWN IMMEDIATE
  7. Start it up again: STARTUP
  8. Exit till the window closes: exit (repeat until window closes)