OraRestart

From My Admin Page
Jump to: navigation, search

Stop DBs

To see which DB's are running do :

  • "ps -ef | grep pmon"
  • su to oracle, enter the appropriate DB, run:
  • sqlplus /nolog
  • connect / as sysdba
  • shutdown immediate

If multiple databases do: export ORACLE_SID=<DATABASE> and repeat steps above...

Start DBs

To Start, login as above but instead of "shutdown immediate" do "startup".

List DBs

To list all databases, find "oratab" file (i.e. /var/opt/oracle/oratab )

  • File Format: database_sid:oracle_home_dir:Y|N
Database_sid is the system id (SID)
Oracle_home_dir = ORACLE_HOME directory
Y|N is should automatically start @ boot