3.3.4 Setup procedure (Windows)

(1) Register PFM - RM for Oracle

To perform integrated management of PFM - RM for Oracle using PFM - Manager and PFM - Web Console, you must register PFM - RM for Oracle with PFM - Manager and PFM - Web Console.

The conditions and procedure for registering PFM - RM for Oracle are the same as when a cluster system is not used. For details about the conditions and procedure for registering PFM - RM for Oracle, see 2.1.4(1) Register PFM - RM for Oracle.

To Page Top

(2) Bring the shared disk online

Make sure that the shared disk is online. If the shared disk is not online, use the cluster software or the volume manager to bring it online.

To Page Top

(3) Set up the logical host environment for PFM - RM for Oracle

Execute the jpcconf ha setup command to set up the logical host environment. When you execute the command, the necessary files are copied to the shared disk, the logical host definition is set up, and the logical host environment is created.

Note:

Before you execute the command, stop all Performance Management programs and services throughout the Performance Management system. For details about how to stop services, see the chapter on starting and stopping Performance Management in the JP1/Performance Management User's Guide.

To set up the logical host environment:

1. Execute the jpc conf ha setup command to create the logical host environment for PFM - RM for Oracle.

   Execute the command as follows:

   jpcconf ha setup -key RMOracle -lhost jp1-halora -d S:\jp1

   Use the -lhost option to specify the logical host name. In the example above, the logical host name is jp1-halora. For DNS operation, specify a logical host name with the domain name portion removed.

   Specify the name of the shared disk directory as the environment directory name of the -d option. For example, if you specify -d S:\jp1, the directory S:\jp1\jp1pc is created, and the files for the logical host environment are created in that directory.

   Notes:

   - PFM - RM for Oracle runs on file systems. Specify the shared disk for the file system.

   - For the environment directory name, do not specify a path containing a parenthesis ((,)).

   If the path contains a parenthesis, the logical host environment will be created successfully, but PFM - RM for Oracle startup may fail.

2. Execute the jpcconf ha list command to check the logical host settings.

   Execute the command as follows:

   jpcconf ha list -key all

   Confirm that the logical host environment you created has been set up correctly.

To Page Top

(4) Set the connection-target PFM - Manager

Execute the jpcconf mgrhost define command to specify which PFM - Manager is to manage PFM - RM for Oracle.

1. Execute the jpcconf mgrhost define command to set the connection-target PFM - Manager.

   Execute the command as follows:

   jpcconf mgrhost define -host jp1-hal -lhost jp1-halora

   Use the -host option to specify the host name of the connection-target PFM - Manager. If that PFM - Manager is running in a logical host environment, specify the logical host name of the PFM - Manager in the -host option. In the example above, the logical host name of PFM - Manager is jp1-hal.

   Use the -lhost option to specify the logical host name of PFM - RM for Oracle. In the example above, the logical host name of PFM - RM for Oracle is jp1-halora.

   Although an example of interactive command execution is shown here, the jpcconf mgrhost define command can be also executed non-interactively. For details about the jpcconf mgrhost define command, see the chapter that describes commands in the manual JP1/Performance Management Reference.

To Page Top

(5) Create an Oracle account to be used

Create an Oracle account that has specific system privileges to collect performance data for the Oracle Database monitored by PFM - RM for Oracle.

For details about how to create an Oracle account, see 2.1.4(2) Create an Oracle account to be used in PFM - RM for Oracle.

This setup task is unnecessary when you use the sys account.

To Page Top

(6) Set up an instance environment

Execute the jpcconf inst setup command to set up an instance environment for PFM - RM for Oracle.

The setup procedure is the same as the setup procedure in a non-cluster system, except that, in a cluster system, you must specify the logical host name in the -lhost option when executing the jpcconf inst setup command.

In a cluster system, the jpcconf inst setup command is executed in the following format:

jpcconf inst setup -key RMOracle -lhost logical-host-name -inst instance-name

Although an example of interactive command execution is shown here, the jpcconf inst setup command can be also executed non-interactively. For details about the jpcconf inst setup command, see the chapter that describes commands in the manual JP1/Performance Management Reference.

As the agent log output folder (the value of log_path), specify the path of a folder that is on the shared disk.

For details about other settings and procedures, see 2.1.4(3) Set up an instance environment.

To Page Top

(7) Set the monitoring target

Execute jpcconf target setup command to specify which Oracle host for PFM - RM for Oracle to monitor.

The setup procedure is the same as the setup procedure in a non-cluster system, except that, in a cluster system, you must specify the logical host name in the -lhost option when executing the jpcconf tatget setup command.

In a cluster system, the jpcconf target setup command is executed in the following format:

jpcconf target setup -key RMOracle -inst instance-name -target monitoring-target-name -lhost logical-host-name

Although an example of interactive command execution is shown here, the jpcconf inst setup command can be also executed non-interactively. For details about the jpcconf inst setup command, see the chapter that describes commands in the manual JP1/Performance Management Reference.

For details about other settings and procedures, see 2.1.4(3)(b) Set the monitoring target.

To Page Top

(8) Set up the logical host environment for other Performance Management programs

At this point, set up any other Performance Management programs, such as PFM - Manager or PFM - RM, on the same logical host.

For details about how to set up these products, see the chapters on setup and operation in a cluster system in the JP1/Performance Management User's Guide, and the chapter on operation in a cluster system in the manuals for the applicable version of PFM - RM.

To Page Top

(9) Specify network settings

This setup task is necessary only when you change the network settings to match the configuration in which Performance Management is used.

The following are the two network setting items:

• IP addresses

  To specify the IP address used by Performance Management in a network environment where multiple LANs are connected, directly edit the contents of the jpchosts file.

  After editing the file, copy it from the executing node to the standby node.

  For details about how to set IP addresses, see the chapter on installation and setup in the JP1/Performance Management Planning and Configuration Guide.

• Port numbers

  If Performance Management programs will communicate with each other through a firewall, use the jpcconf port command to set the port numbers.

  For details about how to set port numbers, see the chapter on installation and setup and the chapters on setup and operation in a cluster system in the JP1/Performance Management Planning and Configuration Guide.

To Page Top

(10) Change the size of log files

The operating status of Performance Management is output to a log file unique to Performance Management. This log file is called the common message log. This setting is required only when you wish to change this file size.

For details, see the chapter that describes installation and setup in the JP1/Performance Management Planning and Configuration Guide.

To Page Top

(11) Change the storage location of performance data

Perform this setting only if you want to change the folders where the database of performance data managed by PFM - RM for Oracle is saved, backed up, exported, or imported.

For details, see 2.6.1 Changing the storage location of performance data.

To Page Top

(12) Setting up the action log

This setting is required to output action log when alarm occur. The action log stores history information that is output in conjunction with the alarms for thresholds related to system load and other conditions.

For details about how to set up the action log, see K. Outputting Action Log Information.

To Page Top

(13) Export the logical-host environment definition file

Once you have created the logical host environment for PFM - RM for Oracle, export the environment definition as a file. In the export process, a file containing the collective definition information for all Performance Management programs set up on that logical host is output. Export the environment definition only after you have set up all additional Performance Management programs on the logical host.

To export the environment definition of the logical host:

1. Execute the jpcconf ha export command to export the environment definition of the logical host.

   The definition information for the logical host environment you created is output to an export file. You can give this file any name you wish.

   For example, execute the command as follows to output the logical host environment definition to the file lhostexp.txt:

   jpcconf ha export -f lhostexp.txt

   Although an example of interactive command execution is shown here, the jpcconf ha export command can be also executed non-interactively. For details about the jpcconf ha export command, see the chapter that describes commands in the manual JP1/Performance Management Reference.

To Page Top

(14) Copy the logical-host environment definition file to the standby node

Copy the file you exported in (13) Export the logical-host environment definition file from the executing node to the standby node.

To Page Top

(15) Take the shared disk offline

Use the cluster software or the volume manager to take the shared disk offline. Note that if you intend to continue using the shared disk, you do not need to take it offline at this point.

To Page Top

(16) Import the logical-host environment definition file

On the standby node, import the exported file you copied from the executing node.

Use the jpcconf ha import command to set up the environment definition for the Performance Management programs of the logical host that you created on the executing node so that they run on the standby node. If more than one Performance Management program was installed on the logical host, the definition information for all of the programs is imported in batch form.

Note that the shared disk does not need to be online when you execute this command.

To import the logical-host environment definition file:

1. Execute the jpcconf ha import command to import the environment definition of the logical host.

   Execute the command as follows:

   jpcconf ha import -f lhostexp.txt

   Although an example of interactive command execution is shown here, the jpcconf ha import command can be also executed non-interactively. For details about the jpcconf ha import command, see the chapter that describes commands in the manual JP1/Performance Management Reference.

   When you execute the command, the settings on the standby node are changed to reflect the environment described in the export file. This sets up the standby node to run PFM - RM for Oracle as a logical host.

   If you used the jpcconf ha import command to assign fixed port numbers during setup, the same port numbers will take effect on the standby node.

2. Execute the jpcconf ha list command to check whether the logical host is set up correctly.

   Execute the command as follows:

   jpcconf ha list -key all

   Check whether the same output is displayed as when you executed jpcconf ha list on the executing node.

To Page Top

(17) Register PFM - RM for Oracle in the cluster software

If you intend to use Performance Management programs in a logical host environment, make sure that the programs are registered in the cluster software. Also, set up the environment so that the Performance Management programs are started and stopped based on instructions from the cluster software.

For details about how to register PFM - RM for Oracle in the cluster software, see your cluster software documentation.

For the dependency settings specified if PFM - RM for Oracle is on the PFM - Manager logical host, see the chapter on cluster system setup and operation in the JP1/Performance Management User's Guide.

This subsection describes how to register PFM - RM for Oracle in your cluster software, using the settings for Windows WSFC as an example.

Register the following services of PFM - RM for Oracle in the cluster software:

#

Shared disk resource

Replace LHOST with the logical host name. For example, if the instance name is SDC1 and the logical host name is jp1-halora, the display name of the service will be PFM - RM Store for Oracle SDC1 [jp1-halora], and the service name will be JP1PCAGT_1S_SDC1 [jp1-halora].

For WSFC, register these services as WSFC resources. Set each resource as follows:

• In Resource type, register the resource as Generic Service.

• Set Dependencies as shown in Table 3-3.

• Set the Policies tab in Properties by taking into account whether you want a failover to occur in the event of a Performance Management program failure.

  For example, to trigger a failover when a failure occurs in PFM - RM for Oracle, set the Policies tab as follows:

  • Select the If resource fails, attempt restart on current node radio button.

  • Select the If restart is unsuccessful, fail over all resources in this Role ceck box.

  • In principle, set Maximum restarts in the specified period: to 3.

Note:

The cluster software is responsible for starting and stopping the services that have been registered in it. Set Startup type for those services to Manual to prevent them from starting automatically when the OS starts. When you set up a service using the jpcconf ha setup command, Startup type for the service will be set to Manual. Also, do not use the following command to forcibly stop a service registered in the cluster software:

jpcspm stop -key all -lhost logical-host-name -kill immediate

To Page Top

(18) Check whether services can be started and stopped from the cluster software

Check whether the cluster software is operating correctly by using it to issue start and stop requests to Performance Management programs on each node.

To Page Top

(19) Set up the environment in the cluster system

After setting up the Performance Management programs, use PFM - Web Console to set up the environment for the programs. You will then be able to display reports on the operating status of monitoring targets, and notify users whenever a problem occurs.

For details about setting up the environment for Performance Management programs, see the chapters on setup and operation in a cluster system in the JP1/Performance Management User's Guide.

To Page Top