Bouncing the Application Database

COMMANDS:

 ps -ef | grep tns========>To find TNS Name (Which is in CAPS) which is used to stop listener.
oraprod   4069     1  0  2010 ?        00:34:59 /u01/oaprod/oaproddb/9.2.0/bin/tnslsnr OAPROD -inherit
applprod  9646     1  0  2010 ?        00:00:00 /u01/oaprod/oaprodora/8.0.6/bin/tnslsnr APPS_OAPROD -inherit
oraprod  30709 30558  0 08:11 pts/0    00:00:00 grep tns


ps -fu applprod=======>To find the processes running

ps -ef | grep LOCAL


adstpall.sh apps/apps from applprod
lsnrctl stop OAPROD from oraaprod
shutdown immediate from oraprod

startup from oraprod
lsnrctl start OAPROD from oraprod
adstrtal.sh apps/apps from applprod


tail -f alert_*.log========>To monitor the sequence of steps during startup and shutdown