how to find running concurrent process id in operation system for R12,R11

execute below sql definition in sqlplus with apps user.

SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id = &Request_ID
AND a.phase_code = 'R';

it will want concurrent no,

after find out process id, you can list.

ps -ef | grep process_id

how to start / stop netbackup services in unix

Stop:
/usr/openv/netbackup/bin/goodies/netbackup stop

Start:
/usr/openv/netbackup/bin/goodies/netbackup start

deleted xml definition in CONTEXT_FILE after adautocfg.sh for R12

i write xml definition for custom top in CONTEX_FILE, but it is deleted after run adautocfg.sh.

xml syntax:
<XXXXX_TOP oa_var="s_xxxxx_top" oa_type="PROD_TOP" oa_enabled="FALSE">$APPL_TOP/xxxxx/12.0.0</XXXXX_TOP>

SOLUTİON:

write in topfile.txt and run  adautocfg.sh. ($APPL_TOP/admin/topfile.txt)
synatx:
xxxxx    $APPL_TOP

how to count EBS users

query:

SELECT user_id, user_name, full_name
    FROM fnd_user fu, per_all_people_f papf
   WHERE papf.person_id = fu.employee_id
         AND SYSDATE BETWEEN fu.start_date AND NVL (fu.end_date, SYSDATE)
         AND SYSDATE BETWEEN papf.effective_start_date
                         AND NVL (papf.effective_end_date, SYSDATE ) ORDER BY 2;

TNS-01151: Missing listener name, APPS_database-SID, in LISTENER.ORA for 11g

PROBLEM:

i have problem (below) when run adstrtal.sh after  Perl adcfgclone.pl appsTier.

TNS-01101: Could not find service name libociei.so

TNS-01101: Could not find service name libociei.so
03/01/14-22:17:48 :: adalnctl.sh: Starting listener process APPS_SID.

LSNRCTL for Solaris: Version 10.1.0.5.0 - Production on 01-MAR-2014 22:17:48

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Starting $ORACLE_HOME/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.1.0.5.0 - Production
Log messages written to $ORACLE_HOME/network/log/apps_mesakl04.log
TNS-01151: Missing listener name, APPS_database-SID, in LISTENER.ORA

Listener failed to start. See the error message(s) above...


SOLUTION:

cd  $INST_TOP/ora/10.1.2/network/admin/

if listener.ora is not found under path

cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh


it will solve.
go to $INST_TOP/ora/10.1.2/network/admin/ for test.

Could not find all the required OS utilities in the $PATH' Error for solaris when run perl adcfgclone.pl appsTier for R12

PROBLEM:

cd $COMMON_TOP/clone/bin  and  run perl adcfgclone.pl appsTier :

bash-3.2$ perl adcfgclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.8

Enter the APPS password :

Checking for make...
 Unable to locate 'make' utility in path
 Checking for ld...
 Unable to locate 'ld' utility in path
 Checking for ar...
 Unable to locate 'ar' utility in path
 Unable to locate all utilities with system path.
 PATH = $COMMON_TOP/clone/bin/../jre/bin:/bin:/usr/bin:/usr/bin:/bin:/opt/openv/pdde/pdopensource/bin:/usr/X11/bin:/usr/openwin/bin


WARNING:  could not find all the required os utilities in the $path. please review the checks above                                                                                        w the checks above


SOLUTION:

To implement the solution, please execute the following steps:

1. Locate the missing utilities. On most releases of unix, they are in /usr/ccs/bin
2. Include a reference to the utilities path in the $PATH environment variable for the applmgr user used to manage the instance. Remember to export the PATH for changes to take effect.
3. Rerun the command 'perl adcfgclone.pl appsTier'

ref:   adcfgclone.pl is Unable to Locate All Utilities in the System Path - 'Could not find all the required OS utilities in the $PATH' Error (Doc ID 397742.1)