Monday, October 18, 2010

Shut Down Application, Listener & DataBase Instance for Oracle R12 VISION

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
$ ./ apps/apps     ( Stop Application Tier )
$ exit

$ 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
$ 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 status

d) Database Instance
$ ps -ef|grep oravis

d) Application
$ ps -ef|grep applvis

Sukhwinder Singh


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

There was an error in this gadget