Himanshu Sinha - Oracle Apps DBA , Oracle DBA, Oracle Cloud DBA , Enterprise Architect.

Here is Details .. How to add additional managed server. By default there is single  Web Application Services in EBS 12.2   If you want to increase number of server either oacore, oafm, forms or forms-c4ws then below instruction need to follow. In below example we are adding one more oacore server. To check current edition: echo $FILE_EDITION Follow below steps to add oacore services Step 1: Take backup of $CONTEXT_FILE from both edition Step 2: Run script on run edition: [applmgr@ebs122 ~]$ perl $AD_TOP/patch/115/bin/adProvisionEBS.pl ebs-create-managedserver  -contextfile=/apps01/applmgr/TEST/fs2/inst/apps/TEST_ebs122/appl/admin/TEST_ebs122.xml  -managedsrvname= oacore_server2 -servicetype= oacore -managedsrvport= 7203 -logfile=/tmp/oacore2.log Enter the APPS Schema password: Enter the WebLogic AdminServer password: The logfile for this session is located at /tmp/oacore2.log Check the logfile for any error message....

1.How to Determine Which Manager Ran a Specific Concurrent Request? col USER_CONCURRENT_QUEUE_NAME for a100 select b.USER_CONCURRENT_QUEUE_NAME from fnd_concurrent_processes a, fnd_concurrent_queues_vl b, fnd_concurrent_requests c where a.CONCURRENT_QUEUE_ID = b.CONCURRENT_QUEUE_ID and a.CONCURRENT_PROCESS_ID = c.controlling_manager and c.request_id = '&conc_reqid'; -- Input the request id . ========================================================================= Long Running Concurrent Request In Oracle : Looking on how to check long running concurrent request in Oracle Apps 11i or R12? Here’s the overview of the SQL query script to detect the session information of each program. First you need to get the listing of running concurrent request in Oracle Apps 11i or R12. You can use the SQL query script as below to obtain the list of running request. SELECT a.request_id ,a.oracle_process_id "SPID" ,frt.responsibility_name ,c...