Friday, September 12, 2014

Bounce the Apache Server

Bounce Apache Server - Oracle Apps R12
BOUNCE APACHE SERVER
After deploying OAF files to application server, you need to restart Apache server to take effect of changes done.  Below are the steps to bounce apache server in R12.

Go to $COMMON_TOP/admin/scripts

1. adapcctl.sh stop                   --        Stop Oracle HTTP Server (OHS) instance
2. adoacorectl.sh stop              --        Stop OPMN managed OACORE OC4J instance

3. adapcctl.sh start                    --       Start Oracle HTTP Server (OHS) instance
4. adoacorectl.sh start               --       Start OPMN managed OACORE OC4J instance

Note:  Any changes in your java code requires restart of apache services.

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

No comments:

Post a Comment