i learnt this

Ever wanted to restart your oracle database instance? Here are some basic steps that will help you restart your oracle db on linux. Firstly, login to your database as oracle You can keep a check on ora processes like this - > ps - ef | grep ora Check that ORACLE_HOME, ORACLE_SID is properly set. Login as sysdba using sqlplus sqlplus / as sysdba >shutdown abort; This will abort all the running processes and immediately shutdown your oracle db. Once this is done, >startup; This will start and mount your db and your db is ready to use. In case your listener is down, start it using the following commands: Set the proper ORACLE_SID. lsnrctl start Db is ready to use. Starting and stopping OEM There is a very powerful oracle monitoring tool called the oracle enterprise manager. I totally love using it. It gives entire performance matrix of your db and also make oracle administration easy. Use it to believe its power. Start emctl. Useful command...