Using HP PRM with Oracle Databases

Oracle process listing

The ps -ef output looks similar to the following output when all three database instances are open:

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

oracle 1822 1 3 09:35:48 ? 0:00 ora_dbw0_Mktg

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

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

oracle 1862 1 4 09:35:55 ? 0:00 ora_pmon_Sales

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

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

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

oracle 1905 1 4 09:36:01 ? 0:00 ora_pmon_Support

oracle 1864 1 3 09:35:55 ? 0:00 ora_dbw0_Sales

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

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

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

oracle 1875 1 0 09:35:55 ? 0:00 ora_reco_Sales

oracle 1907 1 4 09:36:01 ? 0:00 ora_dbw0_Support

oracle 1819 1 4 09:35:48 ? 0:00 ora_pmon_Mktg

oracle 1779 1 0 09:35:23 ? 0:00

/u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER_Mktg -

oracle 1774 1 0 09:35:12 ? 0:00

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

oracle 1916 1 0 09:36:01 ? 0:00 ora_smon_Support

oracle 1918 1 0 09:36:01 ? 0:00 ora_reco_Support

oracle 1920 1 0 09:36:01 ? 0:00 ora_arc0_Support

jstark 1959 1958 0 09:41:36 ? 0:00 oracleSales

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

bmeade 2031 2030 0 09:46:36 ? 0:00 oracleSupport

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

klane 2124 2123 0 09:50:03 ? 0:00 oracleMktg

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

This process list also shows Oracle shadow processes for users connected to the database instances.

The shadow processes have the process IDs of 1959, 2031, and 2124. Shadow processes are

created when users connect to a database instance. In this example, three users are connected to

different database instances. User jstark is connected to the Sales database, user bmeade is

connected to the Support database, and user klane is connected to the Mktg database. The shadow

processes relay database requests from users to the Oracle database. The process names for shadow

processes have the same pattern as the Oracle database server processes. Consequently, these

processes are caught by the application record pattern and moved to the appropriate PRM groups.

This process list also shows Oracle listener processes. Although you can configure Oracle to have a

single listener process for all database instances, it is preferable to have a separate listener process

for each database instance so that the listener process can be moved to the same PRM group as its

associated database instance. The listener processes in this list have process IDs of 1769, 1779, and

1774.