Using HP PRM with Oracle Databases

Placing listener processes with HP Process Resource Manager C.03.02 and later

Starting with PRM C.03.02, PRM supports Extended Regular Expressions in alternate names. This

support enables you to create application records for listener processes.

To put the listener processes in the same PRM groups as their database instances, use the following

application records:

/u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr::::Sales,’tnslsnr.*Sales’

/u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr::::Mktg, ’tnslsnr.*Mktg’

/u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr::::Support,

’tnslsnr.*Support’

Pattern matching rules

Pattern matching follows the rules for Basic Regular Expressions and, with PRM C.03.02 and later,

Extended Regular Expressions, as outlined in the regexp(5) manpage.

Because pattern matching is intended to match a collection of alternate names to a fully qualified

executable, PRM was engineered to ensure that other applications and processes matching the

pattern were not inadvertently put in the wrong PRM group. PRM does this by comparing file system

inode numbers. For a process matching the alternate name pattern to be placed in the configured

PRM group, it must share the file system inode number of the parent process.

The Oracle database administrator does not have to worry about inode numbers because all

processes launched from the same executable (for example, Oracle database instances) share the

same file system inode number.

Validation

Use the ps -efP command to validate that all database processes are running in the correct PRM

groups. The column labeled PRMID indicates each process’s PRM group.

UID PRMID PID PPID C STIME TTY TIME COMMAND

oracle Mktg 1832 1 0 09:35:48 ? 0:00 ora_reco_Mktg

oracle Mktg 1822 1 4 09:35:48 ? 0:00 ora_dbw0_Mktg

oracle Sales 1873 1 0 09:35:55 ? 0:00

ora_smon_Sales

oracle Mktg 1830 1 0 09:35:48 ? 0:00

ora_smon_Mktg

oracle Sales 1862 1 2 09:35:55 ? 0:00

ora_pmon_Sales

oracle Mktg 1834 1 0 09:35:49 ? 0:00 ora_arc0_Mktg

oracle Mktg 2116 2115 0 09:49:08 ? 0:00 oracleMktg

(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle Support 1905 1 2 09:36:01 ? 0:00

ora_pmon_Support

oracle Sales 1864 1 1 09:35:55 ? 0:00

ora_dbw0_Sales

oracle Sales 1877 1 0 09:35:55 ? 0:00

ora_arc0_Sales

oracle Sales 1769 1 0 09:35:02 ? 0:00

/u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER_Sales