Page History

...

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 for more information, see Configuring a Listener to listen to a different port on page 47 for details.

To specify additional Oracle Listener ports

...

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 To change the default

1. Enter the cluster name for the RAC database.
2. Click OK.

...

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

To install PeopleSoft extension for an Oracle instance

1. After adding all Tier installation instance properties inputs, click Advanced.
2. Click the ERP tab.

3. Mark the box :"Install the PeopleSoft extension."

   Info
   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.

...

1. On the server where Precise Oracle collector will be installed, perform the following steps:
   1. For Oracle 12c, refer to file <precise_root>\product\oracle\install\12c\README.txt and follow the instructions there. This would create <precise_root>\product\oracle\install\12c\DBA_Install_Base_Objects_12c.sql.
   2. Connect to the monitored instance with DBA user privileges (connect "as sysdba").
   3. Find the appropriate file according to the monitored instance version, and run the corresponding SQL script using SQL*PLUS or Query AnalyzerSQL Developer.
      • 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
   4. Edit the file and replace the parameters according to the instructions in the file. For Oracle 12c, no replacements are required at this stage.
2. In that same location, perform the following steps:
   1. Connect to the monitored instance with Precise user privileges.
   2. Find the appropriate file according to the monitored instance version, and run the corresponding SQL script using SQL*PLUS or Query AnalyzerSQL Developer.
      • 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
For Oracle 12c containerized, the SQL script has to be run on the root container as well as on all PDBs.
3. 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 InstanceINSTANCE_Name NAME -i -b32
   • For 64-bit Oracle:
     products\oracle\bin\psor_collector_starter.exe InstanceINSTANCE_Name NAME -i -b64
InstanceINSTANCE_Name should NAME should be entered in uppercase letters only.

...

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
     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
   • 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

...