How to Shut Down Application, Listener & DataBase Instance for Oracle R12

How to Shut Down Application, Listener & DataBase Instance for Oracle R12

Three steps : - 

Shut Down Application

Shut Down Database Instance
Stop Listener

1. Shutdown Application

$ su - applvis                                  

$ cd /d01/oracle/VIS/apps/apps_st/appl

$ . APPSVIS_testerp.env
$ cd $ADMIN_SCRIPTS_HOME
$ ./adstpall.sh apps/apps     ( Stop Application Tier )
$ exit

OPTIONAL: -

$ ps -ef|grep applvis      (To check whether all the processes are running or stopped  ; if  it shows all process "0" then application is cleanly down ; if other than "0" then their are some problems with shutdown / Or Application is not cleanly Down)

To kill a process (if error occurs during shut down of application)  then follow these steps: -

 $ ps -ef|grep applvis

$ ps -ef|grep applprod|wc -1

$ adcmctl.sh abort apps/apps

 $ exit

2. Shutdown Database

$ su - oravis   

$ cd /d01/oracle/VIS/db/tech_st/11.1.0

$ . VIS_testerp.env      (STOP DATABASE)
$  sqlplus "/as sysdba"
SQL> shutdown immediate
SQL> exit
 

3. Stop Listener

$ lsnrctl stop VIS
$ exit

       

To verify the TNS listner, Concurrent Manager & Oracle HTTP Server is down sucessfully.

a) TNS listner

$ ps -ef|grep tns

b) Concurrent Manager

$ ps -ef|grep FNDLIBR

c) Oracle HTTP Server

$ sh adapcctl.sh status

d) Database Instance

$ ps -ef|grep oravis

d) Application

$ ps -ef|grep applvis