SyntaxHighlighter JS

2013-01-13

How to restart Oracle

  1. Log into Oracle Unix account via SSH (i.e. PuTTY)
  2. From the Unix prompt, type the command below to log into Oracle sys account via sqlplus

    sqlplus sys as sysdba

  3. From sqlplus, type the commands below to shutdown and start up the database

    shutdown normal;
    startup mount;
    alter database open;
    exit;

  4. From the Unix prompt, type the command below to restart the Oracle listener
    lsnrctl stop
    lsnrctl start 

No comments:

Post a Comment