Page History

...

To enter FocalPoint inputs1.    After

1. After adding all Tier installation instance properties inputs, click Advanced.

...

1. Click the General tab.

...

1. Click the drop-down menu and select the server which the FocalPoint should be installed upon.

...

1. Click OK.

Anchor
SamplingAlertscustommetricsfromthemonitoredinstance SamplingAlertscustommetricsfromthemonitoredinstance

Sampling Alerts custom metrics from the monitored instance

To enable sampling of Alerts custom metrics for this instance1.    After

1. After adding all Tier installation instance properties inputs, click Advanced.

...

1. Click the General tab.

...

1. Mark the box

...

1. "Enable sampling of custom metrics for this

...

1. instance."

...

1. Click OK.

Anchor
Collapsingstatementswithdifferentconstantsintoasinglestatementwithbindvariables Collapsingstatementswithdifferentconstantsintoasinglestatementwithbindvariables

Collapsing statements with different constants into a single statement with bind variables

...

To collapse statements with different constants into a single statement with bind variables1.    After

1. After adding all Tier installation instance properties inputs, click Advanced.

...

1. Click the Settings tab.

...

1. Check the box

...

1. "Collapse statements with different constants into a single statement with bind

...

1. variables."

...

1. Click OK.

...

Anchor
SavingOraclesessioninformationforaspecifiedperiodoftime SavingOraclesessioninformationforaspecifiedperiodoftime

Saving Oracle session information for a specified period of time

...

To save Oracle session information for a specified period of time1.    After

1. After adding all Tier installation instance properties inputs, click Advanced.

...

1. Click the Settings tab.

...

1. Click the drop-down menu and select the desired time for saving information from the last Oracle session.

...

1. Click OK.

Anchor
AssociatingOracleactivitywithnetworkstatistics AssociatingOracleactivitywithnetworkstatistics

Associating Oracle activity with network statistics

...

To enter Oracle activity settings associated with network activity and performance1.    After

1. After adding all Tier installation instance properties inputs, click Advanced.

...

1. Click the Settings tab.

...

1. Check the box

...

1. "Associate Oracle activity with network

...

1. statistics."

...

1. Click OK.

Anchor
SpecifyingadditionalOracleListenerports SpecifyingadditionalOracleListenerports

Specifying additional Oracle Listener ports

...

To specify additional Oracle Listener ports1.    After

1. After adding all Tier installation instance properties inputs, click Advanced.

...

1. Click the Settings tab.

...

1. Check the box

...

1. "Associate Oracle activity with network

...

1. statistics."

...

1. Enter the Oracle Listener port number.
   If the port number already appears on the list, select it.

...

1. If the port number is new, click Add and enter the new Listener port number.

...

1. Click OK.

To remove an Oracle Listener port1.    Select

1. Select the Oracle Listener port number from the list.

...

1. Click Remove to delete the port number from the list.

...

1. Click OK.

Anchor
Definingschemaspecificconfigurationparameters Definingschemaspecificconfigurationparameters

Defining schema-specific configuration parameters

To define schema specific configuration parameters1.    

1. (Optional) Click the drop-down menu and select a tablespace name.

...

1. Info

   This is the name of the tablespace in which the installer will create the Precise for Oracle schema. You can select an existing tablespace name from the list, or enter a new tablespace, causing the installer to create a new tablespace for the schema. If all your tablespaces are stored in Oracle files that reside on RAM devices, Precise for Oracle tablespaces must also reside in a tablespace stored in an Oracle file that resides on a RAM device.

...

1. If a tablespace is chosen, enter the datafile for the tablespace.

   Info

...

1. This is the name of the datafile in which the tablespace will be created. This text box is only available if you use a new tablespace. If the Oracle instance belongs to an Oracle Real Application Cluster (RAC) database, you must use a datafile on a shared storage device that is accessible to all Oracle instances of the Oracle RAC.

...

1. (Optional) Click the drop-down menu and select a temporary tablespace name.

...

1. Info

   This is the name of the temporary tablespace in which the installer will create the Precise for Oracle schema. You can select an existing temporary tablespace name from the list, or enter a new one, causing the installer to create a new temporary tablespace for the schema. If all your tablespaces are stored in Oracle files that reside on RAM devices, Precise for Oracle tablespaces must also reside in a tablespace stored in an Oracle file that resides on a RAM device.

...

1. If a temporary tablespace name is chosen, enter the datafile for the temporary tablespace.

...

1. Info
   This is the name of the datafile in which the temporary tablespace will be created. This text box is only available if you use a new temporary tablespace. If the Oracle instance belongs to an Oracle RAC database, you must use a datafile on a shared storage device that is accessible to all Oracle instances of the Oracle RAC.

...

1. Select where to store the datafiles.
   To browse for the appropriate folder, click the browse (...) button.
   For Oracle ASM specify ASM disk group instead (for example: +DISKGRP1/ora11asm/)

   Info

...

1. This is the folder where you want to keep the datafiles for the new tablespace and/or the new temporary tablespace. By default, this is the Oracle home folder. You can type a different folder path or click browse (...).

...

1. Click OK.

Anchor
MonitoringRACinstallations MonitoringRACinstallations

Monitoring RAC installations

...

If you want to administrate RAC settings in Precise, you can do it also via the Configuring Clusters option in AdminPoint.

If you want to change the default1.    Enter

1. Enter the cluster name for the RAC database.

...

1. Click OK.

Anchor
MonitoringERP MonitoringERP

Monitoring ERP

Use the ERP Tab to define the SAP Interpoint.

...

To install the SAP Interpoint for an Oracle instance1.    After

1. After adding all Tier installation instance properties inputs, click Advanced.

...

1. Click the ERP tab.

...

1. Mark the box "Install SAP Interpoint on this instance."

...

...

1. Enter the SAP system name.
   This is the SID of the SAP instance to monitor. The SID consists of

...

1. three uppercase characters.

...

1. Enter the application server name to be used to connect to the SAP system.

...

1. Enter the system number (a two-digit system number of the application server).

...

1. Enter the user name.

   Info

...

1. The SAP Interpoint uses this user to connect to the SAP system for retrieving system information. Verify that you are using an SAP user that you defined as part of the pre-installation tasks.

...

1. Enter the password.

...

1. Enter the name of the SAP system client.

...

1. Click OK.

For information on the installation of other ERP systems, such as Siebel and Oracle Applications, see Installing Siebel Tier Collectors on page 30 and see Installing Oracle Applications Tier Collectors on page 152.

To install PeopleSoft extension for an Oracle instance1.    After

1. After adding all Tier installation instance properties inputs, click Advanced.

...

1. Click the ERP tab.

...

1. Mark the box

...

1. :Install the PeopleSoft extension."

...

1. Info

...

1. The Oracle Tier Collectors can display correlated information of the activities and resource consumption of your PeopleSoft application components in your Oracle instance. Select this option to correlate PeopleSoft information with Oracle resource consumption.

Anchor
ManuallyinstallingPreciseforOracledatabaseschemas ManuallyinstallingPreciseforOracledatabaseschemas

Manually installing Precise for Oracle database schemas

The Precise for Oracle installation process automatically installs schemas on the Oracle database. This process must be performed for each Oracle instance installed. If you install Oracle instance schemas only, FocalPoint schemas need not be previously installed. To manually install Oracle instance schemas only1.    Set

1. Set the Oracle instance manual schema installation to "

...

1. true" by running the following script on the Precise root folder on the main Precise FocalPoint machine.

...

1. • Windows
     infra\bin\psin_cli.bat
     -i3-user user-name
     {-i3-encrypted-password encrypted-password
     | -i3-clear-password clear-password}
     -action settings-update
     -name manual-install-oracle-schema
     -value true

...

1. • UNIX
     ./infra/bin/psin_cli.sh
     -i3-user user-name
     {-i3-encrypted-password encrypted-password
     | -i3-clear-password clear-password}
     -action settings-update
     -name manual-install-oracle-schema
     -value true

...

1. Manually install the Precise for Oracle database schemas.

...

1. Install the Oracle Tier instance, using the Precise installer.

To manually install Precise for Oracle database schemas1.    On

1. On the server where Precise Oracle collector will be installed, perform the following steps:

   ...

   1. 1. Connect to the monitored instance with DBA user privileges (connect

   ...

   1. 1. "as sysdba").

   ...

   1. 1. Find the appropriate file according to the monitored instance version, and run the corresponding SQL script using SQL*PLUS or Query Analyzer.
         • For Oracle 9i    <precise_root>\product\oracle\install\9i\ DBA_Install_Base_Objects_9i.sql
         • For Oracle 10g    <precise_root>\product\oracle\install\10g\ DBA_Install_Base_Objects_10g.sql
         • For Oracle 11g    <precise_root>\product\oracle\install\11g\ DBA_Install_Base_Objects_11g.sql
         • For Oracle 12c    <precise_root>\product\oracle\install\12c\ DBA_Install_Base_Objects_12c.sql

   ...

   1. 1. Edit the file and replace the parameters according to the instructions in the file.

   ...

   1. In that same location, perform the following steps:

      ...

      1. 1. Connect to the monitored instance with Precise user privileges.

      ...

      1. 1. Find the appropriate file according to the monitored instance version, and run the corresponding SQL script using SQL*PLUS or Query Analyzer.
            • For Oracle 9i    <precise_root>\product\oracle\install\9i\ Install_I40_Objects_9i.sql
            • For Oracle 10g    <precise_root>\product\oracle\install\10g\ Install_I40_Objects_10g.sql
            • For Oracle 11g    <precise_root>\product\oracle\install\11g\ Install_I40_Objects_11g.sql
            • For Oracle 12c    <precise_root>\product\oracle\install\12c\ Install_I40_Objects_12c.sql

      ...

      1. If the Oracle Tier is installed on Windows, log in to the server that the Oracle Tier was installed on, browse to the <precise_root> folder, and run the following command after installing the Oracle Tier Collector on that server:
         • For 32 bit Oracle:
           products\oracle\bin\psor_collector_starter.exe Instance_Name -i -b32
         • For 64 bit Oracle:
           products\oracle\bin\psor_collector_starter.exe Instance_Name -i -b64
           Instance_Name should be entered in uppercase letters only.

      To install Precise for Oracle without using the Oracle's system user as an installation parameter1.    To

      1. To manually create the schema and the Precise Oracle user, use Oracle's system (dba) user.

      ...

      1. Within the installation parameters, choose Connect As: Normal.

      To reset the Precise for Oracle installation process to automatically install schemas on the Oracle database1.    Reset

      1. Reset the Oracle instance manual schema installation to "false" by running the following script on the Precise root folder on the main Precise FocalPoint.
         • Windows
           

      ...

      1. • infra\bin\psin_cli.bat
           -i3-user user-name
           {-i3-encrypted-password encrypted-password
           | -i3-clear-password clear-password}
           -action settings-update
           -name manual-install-oracle-schema
           -value false

      ...

      1. • UNIX
           ./infra/bin/psin_cli.sh
           -i3-user user-name
           {-i3-encrypted-password encrypted-password
           | -i3-clear-password clear-password}
           -action settings-update
           -name manual-install-oracle-schema
           -value false

       

      Precise. Performance intelligence from click to storage. Learn more > >

      Precise Website	Solutions	Support	Support Portal	Community	About Us	Legal