Page History

...

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   9i    <precise_root>\product\oracle\install\9i\ DBA_Install_Base_Objects_9i.sql
      • For Oracle 10g   10g    <precise_root>\product\oracle\install\10g\ DBA_Install_Base_Objects_10g.sql
      • For Oracle 11g   11g    <precise_root>\product\oracle\install\11g\ DBA_Install_Base_Objects_11g.sql
      • For Oracle 12c   12c    <precise_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   9i    <precise_root>\product\oracle\install\9i\ Install_I40_Objects_9i.sql
      • For Oracle 10g   10g    <precise_root>\product\oracle\install\10g\ Install_I40_Objects_10g.sql
      • For Oracle 11g   11g    <precise_root>\product\oracle\install\11g\ Install_I40_Objects_11g.sql
      • For Oracle 12c   12c    <precise_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_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

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