Using HP PRM with Oracle Databases

9
Configuring HP Process Resource Manager
The following procedure outlines step-by-step instructions for configuring PRM to work with Oracle.
Steps involving the startup and configuration of the Oracle database are outside the scope of this
document. See the appropriate Oracle documentation. Also, see the HP Process Resource Manager
User’s Guide for more detailed configuration information.
You can configure PRM using its interface in HP System Management Homepage or on the command
line (using prmconfig). The following steps have been generalized so that they apply to both
approaches. The case study in the following section gives the specifics for a GUI approach and an
associated PRM configuration file that can be created in an editor and loaded using prmconfig to
give the same result.
NOTE
If you are configuring PRM’s shared memory management, load the PRM
configuration before starting the Oracle database. If the database is
already running when you load the PRM configuration, restart the
database.
1. Verify the versions of HP-UX, Oracle, and PRM that are installed on your system. This paper was
written based on functionality provided by HP-UX 11i v2 Update 2, Oracle 8i, Oracle 9i, Oracle
10g, and PRM C.03.02 or later.
2. Define your PRM groups. Review the advantages and disadvantages of FSS PRM groups
compared to pSet PRM groups as described in the “HP Process Resource Manager and Oracle
integration summary” section on page 7, and decide what type of PRM groups are appropriate
for your situation.
3. Define your MRGs.
4. Decide whether you want private memory entitlements for your Oracle database instances. (If you
assign a private memory entitlement to one PRM group, you must assign them to all groups.)
5. Review the section “Managing private memory” on page 5 to determine if you need memory
resource isolation for your Oracle instances. If so, enable memory isolation for the appropriate
PRM groups.
6. Decide whether you want shared memory management for the instance’s SGA. You can manage
shared memory for just one PRM group, multiple PRM groups, or all PRM groups.
7. Define your user records to reference the new PRM group definitions.
8. Add application record definitions for each Oracle database instance. Enter the full name of the
Oracle executable as the application name, the name of the PRM group, and the alternate name
for the Oracle application. The alternate name must have the format ora*<$ORACLE_SID> to
match all processes related to an individual Oracle database instance.
9. Place each listener process in its appropriate PRM group. This step must be completed manually by
using the prmmove command or by placing the commands in an executable script. See
“Managing listener processes” on page 16 for additional information.
10.(Available starting with HP-UX 11i v2) Create Secure Resource Partitions, if desired, using the
prm2scomp utility to generate a Security Containment configuration based on the PRM
configuration. This utility also modifies your PRM configuration to map the compartments to your
PRM groups. Load and activate the Security Containment configuration using the setrules utility.
11.Load the PRM configuration and enable the PRM application manager and the memory manager.