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
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
Thank you
ReplyDelete