Using HP PRM with Oracle Databases

Process management

Figure 4 shows that each database instance (Sales, Support, and Mktg) is launched from a unique

instance of the same executable: /u01/app/oracle/product/10.2.0/db_1/bin/oracle. The

processes for the database instance are renamed according to the variable $ORACLE_SID. This is

important because the fully qualified executable in the PRM application record must be the one that

launches the processes you want to place in a specific PRM group.

Figure 4. Oracle processes

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

svrmgr1

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

ora_pmon_Sales

ora_reco_Sa

les

ora_smon_Sales

ora_dbw0_Sales

ora_arc0_Sales

ora_pmon_Support

ora_reco_Support

ora_smon_Support

ora_dbw0_Support

ora_arc0_Support

ora_pmon_Mktg

ora_reco_Mktg

ora_smon_Mktg

ora_dbw0_Mktg

ora_arc0_Mktg

Executable

Transient executable

Tran

sient executable

Transient executable

$ORACLE_SID = Sales

$ORACLE_SID = Support

$ORACLE_SID = Mktg

fork/rename

Sales db

processes

fork/rename

Support db

processes

fork/rename Mktg

db processes