EBS并发管理器管理工具-cpadmin介绍

并发管理器对于EBS系统的重要性想必不用再多说什么了。对于EBS系统来说，DBA在做日常管理维护的时候大多较为复杂，对于经验尚浅的同学来说也极富挑战。最近在某些EBS DBA群组中并发管理器的问题又被多次提及。很多人建议使用cmclean脚本，cmclean脚本确实可以帮助大家解决某一些问题，但是该脚本有可能会带来其他意想不到的问题，所以在此严重建议大家不要使用cmclean脚本。

并发处理命令行工具，是本文介绍的并发管理工具，它是EBS提供的与其他ad工具类似的自动处理工具。下面对该工具做具体介绍：

1、运行cpadmin工具

对于EBS 12.2.5系统来说，oracle已经集成了cpadmin工具，对于12.2.3&12.2.4的EBS系统需要安装补丁24408550，R12的系统可以通过补丁19287293。我们通过应用APP层run fs环境变量即可在命令行下直接运行cpadmin

具体步骤如下：

$ . EBSapps.env run

$ cpadmin.sh

cpadmin.sh脚本位于$FND_TOP/bin目录下

2、cpadmin工具解释

$ cpadmin.sh

.............................

Enter the password for your ‘APPS’ ORACLE schema:[输入apps用户密码]
Connecting to database…

CP Administration Main Menu
————————————————–

1. Administer Concurrent Managers

2. Administer Concurrent Requests

E. (E)xit CP Administration

Enter your choice: [E] :

In the menu option 1 Administer the managers has lot of handy apps dba scripts
Administer Concurrent Managers
————————————————–

1. Manager Status
– 管理器状态： 使用这一选项显示所有管理器的状态

2. Clean concurrent processing tables
– 清并发处理相关表：这个选项用来清理并发处理的表以来替代cmclean.sql

3. Set Manager Diagnostics
– 设置管理器诊断：开启或关闭对个别管理器的诊断。

4. Control a manager or service
– 管理器控制：用这个选项来发送一个请求，比如：开启，关闭或验证某一个管理器。

5. Rebuild Concurrent Manager Views
– 重建管理器视图：用这个选项来重建视图 FND_CONCURRENT_WORKER_REQUEST 和FND_CONCURRENT_CRM_REQUESTS。

R. (R)eturn to previous menu

E. (E)xit CP Administration

I am impressed with the option 2. Clean concurrent processing tables
Alternative for cmclean.sql

Enter your choice: [R] : 2

Running command: Clean concurrent processing tables (120.0.12020000.5)
————————————————–

该选项主要用在内部管理器（ICM）无法启动管理器时

This utility should be used when the Internal Concurrent
Manager fails to start due to corrupted internal state
information.
The Internal Concurrent Manager must not be running at
this time. The utility will verify the Internal
Concurrent Manager is not running before making changes.

Continue (Y or N)

Below option also very useful for us. We can set the debug for the below critical managers and identify the cause of an issue quickly
Option 3. Set Manager Diagnostics

Enter your choice: [R] : 3

Running command: Set Manager Diagnostics (120.0.12020000.1)
————————————————–

1. ICM
2. CRM
3. Output Post-Processor
4. Request-Processing Managers
5. Transaction Managers
6. Cancel and return to menu

Set diagnostics for:

In the main menu of cpadmin.sh
Option 2 Administer Concurrent Requests have lot of interesting options. Below example will really thrills you.

Administer Concurrent Requests
————————————————–

1. Analyze Concurrent Requests
– 分析请求：用这个选项来分析一个请求。

2. Move Request Files
– 移动请求文件：用这个选项来改变请求日志和输出文件的位置。

R. (R)eturn to previous menu

E. (E)xit CP Administration

Enter your choice: [R] : 1

Running command: Analyze Concurrent Requests (120.0.12020000.1)
————————————————–

Analyze a Concurrent Request
This utility analyzes a concurrent request and returns details

EnterRequest ID: 7444720[输入需要分析的请求号]
7444720 is a valid request ID

Analyzing request 7444720
——————————————————
Program information:
Program: Active Users (FNDSCURS)
Application: Application Object Library
Executable type: Oracle Reports (P)
Executable file name or procedure: FNDSCURS
Run alone flag: N
SRS flag: Q
NLS compliant: Y
Output file type: TEXT
——————————————————

——————————————————
Submission information:
It was submitted by user: SYSADMIN
Using responsibility: System Administrator
It was submitted on: 02-17-16 09:24:45AM
It was requested to start on: 02-17-16 09:24:45AM
Parent request id: -1
Language: AMERICAN
Territory: AMERICA
Priority: 50
Arguments: (0) null
——————————————————

——————————————————
Analysis:
Request 7444720 has completed with status: Normal
It began running on: 02-17-16 09:24:47AM
It completed on: 02-17-16 09:25:13AM
It was run by : Standard Manager
Logfile: /u01/app/VIS/fs_ne/inst/VIS_major/logs/appl/conc/log/l7444720.req
Outfile: /u01/app/VIS/fs_ne/inst/VIS_major/logs/appl/conc/out/o7444720.out
It produced completion message: Normal completion

2. Move Request Files also give lot of options for apps dba to manage the concurrent request

Administer Concurrent Requests
————————————————–

1. Analyze Concurrent Requests
– Analyze Concurrent Requests and print out details

2. Move Request Files
– Commands to change request log and output file locations

R. (R)eturn to previous menu

E. (E)xit CP Administration

Enter your choice: [R] : 2

Move Request Files
————————————————–

1. Set new filenames for a single request
– Set new filenames for a single request to a new complete path and filename

2. Set node for a single request
– Set node for a single request to a different node

3. Move files for a single request
– Move files for a single request to a different directory

4. Move files for multiple requests within date range
– Move files for multiple requests within date range to a different directory

5. Set node for multiple requests within date range
– Set node for multiple requests within date range to a different node

6. Move files for multiple requests within request id range
– Move files for multiple requests within request id range to a different directory

7. Set node for multiple requests within request id range
– Set node for multiple requests within request id range to a different node

R. (R)eturn to previous menu

E. (E)xit CP Administration

Enter your choice: [R] : 1

Running command: Set new filenames for a single request (120.0.12020000.2)
————————————————–

Enter single request_id: 7444720
Enter new complete path and filename for logfile(or no input to leave logfile unchanged):

对于cpadmin的详细信息可以参考http://docs.oracle.com/cd/E26401_01/doc.122/e22953/T174296T575591.htm#8159578文档