Social Icons

Wednesday, July 24, 2013

Bounce Apache server in R12

First Check the active user in the Application by Running Below Query in TOAD/Sql Developer.


select fnd.user_name,
       icx.responsibility_application_id,
    icx.responsibility_id,
    frt.responsibility_name,
       icx.session_id,
    icx.first_connect,
       icx.last_connect,
       DECODE ((icx.disabled_flag),'N', 'ACTIVE',
                                'Y', 'INACTIVE') status
from   fnd_user fnd,
       icx_sessions icx,
    fnd_responsibility_tl frt
where  fnd.user_id = icx.user_id
and icx.responsibility_id = frt.responsibility_id
and icx.disabled_flag <> 'Y'
and trunc(icx.last_connect) = trunc(sysdate)
order by icx.last_connect;


If no active users are there, then you can follow the below process otherwise any user is active in Application will get Connection Error

Server Bouncing for OAF Customizations: 



we need to run two scripts:

1)Script which is responsible for bouncing Oracle HTTP Server (adapcctl.sh)
2)Script which responsible for bouncing OC4J container (adoacorectl.sh)

So basically, here is the sequence of steps you need to do :
1) Connect to Host Server using Putty
2) Change the Directory by using this command  cd $ADMIN_SCRIPTS_HOME
3) And Execute below Commands in current Directory
   3.1) adapcctl.sh stop
   3.2) adoacorectl.sh stop
   3.3) adapcctl.sh start
   3.4) adoacorectl.sh start



1 comment :

">