OraRestart
From My Admin Page
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