Kill LOCAL=NO Process in Oracle Database

kill -9 `ps -ef | grep LOCAL=NO | grep AFZ | grep -v grep | awk '{print $2}'`

Kill Particular User Session in R12

select * from dba_blockers;

select * from v$session where client_identifier like 'SYSADMIN%' order by logon_time desc;

ALTER SYSTEM KILL SESSION '101,25576';

Find the APPLSYSPUB password in R12

 Source the application env file.

1. echo $GWYUID

APPLSYSPUB/PUB

2. grep -i applsyspub $FND_SECURE/$TWO_TASK.dbc

GWYUID=APPLSYSPUB/PUB

3. grep -i s_gwyuid_pass $CONTEXT_FILE

password oa_var=”s_gwyuid_pass”-- PUB -- password