Page History

This section includes the following topic:

• Updating or recovering the Collector schemaOracle version

Anchor
UpdatingOrRecovering UpdatingOrRecovering

Updating

...

the

...

Oracle version

When you upgrade your Oracle version from version 8i to version 9i, version 8i to version 10g, or version 9i to version 10g, you need to modify the Precise Collector schema. The modification can be performed via the following procedure.

You can also use the procedure to recreate a corrupted or removed Collector schema.

To modify the Precise Collector schema

1. From the Oracle FocalPoint directory run the following script:
   Windows    products\oracle\install\or_version_update.bat
          -host host
          -sid sid
          -user user
          -password password
          [-port port
          -manual]
   UNIX          ./products/oracle/install/or_version_update.sh
          -host host
          -sid sid
          -user user
          -password password
          [-port port
          -manual]
   You now see all information about the previous and current installation of Oracle.
2. Type Y and click Enter.

After a successful update, you see the message that the Precise configuration update was completed successfully.

The following table describes the parameters that are mandatory and optional in the script.

Table 10-1 Script parameters

If Oracle Applications is installed on the processed instance, perform the following procedure to verify that the installation was successful.

To verify that the Oracle Applications installation is successful

1. On the server with the Collector agent, open the:
   <i3_root>/products/oracle/ORACLE_SID/schema folder.
2. Run the following script:
   Windows. verify_install_oracle_apps.bat
   UNIX. /verify_install_oracle_apps.sh

If the following message is displayed, the installation was successful:

Starting VERIFY Interpoint/Oracle Application Installation
SUCCESS - Veritas database objects are in place

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

, You must uninstall the monitored instance(s) from Precise, and then reinstall the monitored instance(s) using the same instance ID.

1. Make sure the Warehouse Maintenance (Weekly) does not run soon.
2. To uninstall:
   1. Navigate to the AdminPoint installation.
   2. Select Instances and Clusters.
   3. Select the instance(s) to be uninstalled, and then click Delete.
3. To reinstall:
   1. Navigate to the AdminPoint installation.
   2. Select Instances and Clusters.
   3. Click Add Instance.
   4. Complete the appropriate fields, and then click Advanced.
   5. Click the option to install using the same instance ID (Associate the instance with the data of the deleted instance).

...