This section includes the following topics:
The default location for the FocalPoint installation is on the same server as the Precise Framework. The General tab allows you to define a different server as the location for the FocalPoint installation.
To enter FocalPoint inputs
To enable sampling of Alerts custom metrics for this instance
This option will handle all statements that have the same text but different literals as the same statement. The data will not include literals but the first value used for each literal.
To collapse statements with different constants into a single statement with bind variables
Precise for Oracle saves historical files that contain performance information. These files are parsed and loaded into the PMDB. When session information is viewed, Precise for Oracle accesses these files. You can specify the retention period that the session information is saved.
To save Oracle session information for a specified period of time
This is the network time experienced by Oracle entities, provided you install the Insight Savvy for Network on this server.
To enter Oracle activity settings associated with network activity and performance
This option is relevant if you have installed the Insight Savvy for Network on the Oracle server. You can add TCP/IP ports that are used by SQL*Net Listeners to have network traffic on those ports monitored. See Configuring a Listener to listen to a different port on page 47 for details.
To specify additional Oracle Listener ports
To remove an Oracle Listener port
To define schema specific configuration parameters
(Optional) Click the drop-down menu and select a tablespace name.
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. |
If a tablespace is chosen, enter the datafile for the tablespace.
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. |
(Optional) Click the drop-down menu and select a temporary tablespace name.
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. |
If a temporary tablespace name is chosen, enter the datafile for the temporary tablespace.
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. |
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/)
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 (...). |
The RAC tab will only appear on the advanced screen if the system detected that you are installing an instance that is part of a cluster. |
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 default
Use the ERP Tab to define the SAP Interpoint.
The Oracle Tier Collectors can display correlated information on the activities and resource consumption of your SAP application components in your Oracle instance. Select this option to correlate SAP information with Oracle resource consumption. |
To install the SAP Interpoint for an Oracle instance
Enter the user name.
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. |
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 instance
Mark the box :Install the PeopleSoft extension."
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. |
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 only
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
./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
To manually install Precise for Oracle database schemas
<precise_root>\product\oracle\install\9i\ DBA_Install_Base_Objects_9i.sql
<precise_root>\product\oracle\install\10g\ DBA_Install_Base_Objects_10g.sql
<precise_root>\product\oracle\install\11g\ DBA_Install_Base_Objects_11g.sql
<precise_root>\product\oracle\install\12c\ DBA_Install_Base_Objects_12c.sql
<precise_root>\product\oracle\install\9i\ Install_I40_Objects_9i.sql
<precise_root>\product\oracle\install\10g\ Install_I40_Objects_10g.sql
<precise_root>\product\oracle\install\11g\ Install_I40_Objects_11g.sql
<precise_root>\product\oracle\install\12c\ Install_I40_Objects_12c.sql
<precise_root>
folder, and run the following command after installing the Oracle Tier Collector on that server:products\oracle\bin\psor_collector_starter.exe Instance_Name -i -b32
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 parameter
To reset the Precise for Oracle installation process to automatically install schemas on the Oracle database
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
./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
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal