How to associate / map / include / exclude a concurrent program to / from a specific concurrent manager in 11i & R12?

Posted on October 14, 2008. Filed under: Configuration, DBA/Admin Tips, R12 | Tags: , , , , , , |

Depending on the business need, at times we might have to exclude / include a concurrent program from/to a specific concurrent manager. Say for example you have created a custom concurrent queue (CCQ) and custom concurrent program (CCP) and you want the CCP to be run only through the CCQ and not through the Standard Manager.
Steps

Login as sysadmin
System Administrator -> Concurrent : Manager -> Define
Press F11 and Search for the CCP
Click on Specialization Rules
Goto the last record and press down arrow (this will add a new row)
Select Include for Include / Exclude Column
Select Program for Type
Select appropriate application type for Application
Select the CCP for Name
Click on floppy icon (to save)

Apart from including to the CCQ, lets also exclude from Standard Manager

Press F11 and Search for the Standard Manager
Click on Specialization Rules
Verify if you already have a row for the CCP (Most probably you will not have one, because the default concurrent queue is always Standard Manager. If in case you have a row for the CCP, perform below steps without adding a new row or Goto the last record and press down arrow (this will add a new row)
Select Exclude for Include / Exclude Column
Select Program for Type
Select appropriate application type for Application
Select the CCP for Name
Click on floppy icon (to save)

Above steps can also be used on PCP setups, wherein you want to run a concurrent program only on one of the CM nodes and not on the other. The needs might differ between organizations but the method to exclude / include remains the same.

cheers,
OraclePitStop.

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: