Skip to main content

Steps to Setup PCP in Apps 11i

1.Create two shared folder. Both Apps Node should able to access these two file when any one of apps server goes down.
/appslog
/appstmp

2.Edit the following parameters in xml files under $APPL_TOP/admin in both APPS Node

$APPLCSF = /appslog
$APPLTMP = /appstmp
$APPLDCP = ON

3.Copy the existing tnsnames.ora and listener.ora file $ORACLE_HOME(806) and $ORACLE_HOME(iAS) and run autoconfiG
on both APPS node

3.Change the profile option

Concurrent:PCP Instance Check to "ON", if you need sensitive failover in Database Instance.

4.Set up the primary and secondary node names for all the concurrent managers according
to the desired distribution.

5.Create the following concurrent manager for the non-concurrent node as a primary node and concurrent node as a seconadry node.

1.Conflict Resolution Manager APPS2
2.Customer Profile Engine APPS2
3.Service Manager APPS2
4.Inventory Manager APPS2
5.INV Remote Procedure Manager APPS2
6.MRP Manager APPS2
7.OAM Metrics Collection Manager APPS2
8.PO Document Approval Manager APPS2
9.Receiving Transaction Manager APPS2
10.Standard Manager APPS2

6.Oracle Support Reference
Doc Id: Concurrent Manager Setup and Configuration Requirements in an 11i RAC Environment [ID 241370.1]
Doc Id: How to Set Up Parallel Concurrent Processing (PCP) in Apps 11i? [ID 388495.1]
Concurrent Managers Will Only Start on One Node in PCP/RAC Environment [ID 264296.1]

Comments

Mehmood Rehman said…
nice post keep it up...

http://mehmoodm.blogspot.com

Popular posts from this blog

ORA-20200 Error while running AWR report from PDB level

Issue: In 19c database, while generating AWR report from PDB level, got the below error.  In 12cR1 - We can only generate statistics and run the Workload Repository (AWR) report from CDB level.  Since 12.2, if we want to generate statistics and run AWR report from PDB level, we have to change  awr_pdb_autoflush_enabled parameter to TRUE. Error: ERROR at line 1: ORA-20200: Database/Instance 2832289441/1 does not exist in AWR_PDB_DATABASE_INSTANCE ORA-06512: at line 27 Solution: alter session set container=ORCL; >>>>   Set the container Name alter system set awr_pdb_autoflush_enabled=true; conn system/<pwd>@orclcdb     >>>> Login into PDB database alter system set AWR_SNAPSHOT_TIME_OFFSET=1000000 scope=both;   >>> Set the arameter to avoid performance issue while generating snapshot at the same time in CDB and PDB level. exec dbms_workload_repository.create_snapshot(); SQL> @?/rdbms/admin/awrrpt.sql Console Log: SQL> show pdbs       CON_ID CON

EBS 12.2 - Script to monitor JVM Heap Memory for the weblogic managed servers

#!/bin/sh # Script to monitor JVM Heap Memory for the managed servers # Author : Ramasubbu Sunadaravel # Date   : 23-Aug-2016 # Usage  : sh jvm_heap_mem_mon.sh run  ## VARIABLES save_date=`date +%d_%b_%y` LOGFILE=/export/home/applmgr/oraprocs/logs HISTFILE=/export/home/applmgr/oraprocs/histfile threshold=10 MAIL_LIST=rsundaravel@yahoo.com SCRIPT=/export/home/applmgr/oraprocs/.jvm_check.py ## SCRIPTS STARTS HERE . /r11/app/FLRPRD/R12apps/EBSapps.env . $FMW_HOME/wlserver_10.3/server/bin/setWLSEnv.sh java weblogic.WLST $SCRIPT > $LOGFILE/jvm_heap_monitoring.log date '+Start Time: %m/%d/%y %H:%M:%S' >> $HISTFILE/jvm_heap_monitoring_$save_date.log cat $LOGFILE/jvm_heap_monitoring.log|grep "%" >> $HISTFILE/jvm_heap_monitoring_$save_date.log date '+End Time: %m/%d/%y %H:%M:%S' >> $HISTFILE/jvm_heap_monitoring_$save_date.log #Alert DBA's if any of the managed server heap size reached more than $threshold value current=`

EBS 12.2 - Script to monitor Weblogic Managed servers

#!/bin/sh # Script to monitor Weblogic managed server status # Author : Ramasubbu Sunadaravel # Date   : 23-Aug-2016 . /r11/app/FLRPRD/R12apps/EBSapps.env ## VARIABLES ### LOGFILE=/export/home/applmgr/oraprocs/logs MAIL_LIST=rsundaravel@yahoo.com ADMIN_URL=http://test.domain.int:7014/console PARFILE=/export/home/applmgr/oraprocs/mgd_server_list.par ## - place all the managed servers name. WEBLOGIC_PWD = /export/home/applmgr/oraprocs/.weblogicpwd ## SCRIPT STARTS cat $PARFILE |while read line do managed_server=`echo $line | awk '{print $1}'` LOGFILE=/export/home/applmgr/oraprocs/logs echo $managed_server echo `cat $WEBLOGIC_PWD`|$ADMIN_SCRIPTS_HOME/admanagedsrvctl.sh status $managed_server|grep $managed_server|grep -v logs > $LOGFILE/$managed_server.log status=`cat $LOGFILE/$managed_server.log|grep "is running"|wc -l` if test $status -eq 1 then echo "$managed_server is Running" else echo "$managed