Page History

...

1. After adding all Tier installation instance properties inputs, click Advanced.
2. Click the Settings tab.
3. Check the box "Associate Oracle activity with network statistics."
4. Enter the Oracle Listener port number.
   If the port number already appears on the list, select it.
5. If the port number is new, click Add and enter the new Listener port number.
6. Click OK.

...

1. Set the Oracle instance manual schema installation to "true" by running the following script on the Precise root folder on the main Precise FocalPoint machine.
   • 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
   • 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
2. Manually install the Precise for Oracle database schemas.
3. Install the Oracle Tier instance, using the Precise installer.

...

1. On the server where Precise Oracle collector will be installed, perform the following steps:
   1. Connect to the monitored instance with DBA user privileges (connect "as sysdba").
   2. 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 <precise_root>root>\product\oracle\install\9i\ DBA_Install_Base_Objects_9i.sql
      • For Oracle 10g    <precise <precise_root>root>\product\oracle\install\10g\ DBA_Install_Base_Objects_10g.sql
      • For Oracle 11g    <precise <precise_root>root>\product\oracle\install\11g\ DBA_Install_Base_Objects_11g.sql
      • For Oracle 12c    <precise <precise_root>root>\product\oracle\install\12c\ DBA_Install_Base_Objects_12c.sql
   3. Edit the file and replace the parameters according to the instructions in the file.
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 Analyzer.
      • For Oracle 9i    <precise <precise_root>root>\product\oracle\install\9i\ Install_I40_Objects_9i.sql
      • For Oracle 10g    <precise <precise_root>root>\product\oracle\install\10g\ Install_I40_Objects_10g.sql
      • For Oracle 11g    <precise <precise_root>root>\product\oracle\install\11g\ Install_I40_Objects_11g.sql
      • For Oracle 12c    <precise <precise_root>root>\product\oracle\install\12c\ Install_I40_Objects_12c.sql
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<precise_root> 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.

...

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

...