Archive for October, 2008

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
Read Full Post | Make a Comment ( None so far )

How to configure Workflow Mailer in 11i & R12

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

One of the simple configuration in Oracle Apps is the Java Workflow Mailer configuration. The steps are simple but the key point is verifying and validation the pre-reqs before proceeding with the configuration. This post had been divided into two parts 1) Pre-reqs validation and 2) Workflow Mailer configuration.

Pre-reqs validation include SMTP & IMAP server access, dedicated email id and folders creation.

You can download the document here.

cheers,
OraclePitStop.

Read Full Post | Make a Comment ( None so far )

How to enable / generate trace for a form 11i / R12

Posted on October 6, 2008. Filed under: DBA/Admin Tips, Diagnostics, R12, TroubleShooting | Tags: , |

This step can be performed by any user who has access to the professional approach (ie., the forms not the jsp). By access i meant any responsibility which launches the form.

Steps: (In the forms window)

1. Click on Help -> Diagnostics -> Trace

2. Under trace you have 5 options – select the appropriate option

3. Key in the apps password in the prompted window.

4. The next window will specify the logfile name and location.

cheers,
OraclePitStop

Read Full Post | Make a Comment ( None so far )

How to identify if a port is listening on a unix server

Posted on October 6, 2008. Filed under: Apps Technology Stack, DBA/Admin Tips, Diagnostics, Operating System, R12, TroubleShooting | Tags: , , , |

We often get into a situation wherein we have to check if a particular port is being used by some process.
Command

netstat -an | grep [port number] | grep LISTEN

Command to identify the OS process associated with a port

lsof -i tcp:[port number]

cheers,

OraclePitStop

Read Full Post | Make a Comment ( 1 so far )

httpd: bad group name dba

Posted on October 1, 2008. Filed under: Configuration, DBA/Admin Tips, Operating System, R12, SOA, Technology, TroubleShooting | Tags: , , , |

All were working fine on our SOA server untill we restarted the services. All the custom oc4j components came up fine except the HTTP component.

Below is the error in opmn/logs/HTTP_Server~1.log

apachectl startssl: execing httpd
httpd: bad group name dba

Executing the id command for the SOA owner returned

$ id
uid=5352(username_masked) gid=500()

Note the blank open and closed brackets next to 500.

The root cause of the problem was read access on file /etc/group had been revoked by the root user.
$ ls -l /etc/group
-r–r—–   1 root       3              955 Oct  1 06:36 /etc/group

Both username and group information is stored in the httpd.conf. This file is read everytime you start apache. Since there was no read access to the /etc/group file and also no group information available for the SOA owner httpd service failed to start.

After granting read access to everyone, the services came up fine.

Above solution not only holds good to SOA but also to any Oracle product which uses apache viz., Oracle Apps, Oracle 10gAS.

cheers,
OraclePitStop.

Read Full Post | Make a Comment ( None so far )

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