This section includes the following topic:
Updating or recovering the Collector schema
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.
Use the values for sid and host as they appear in AdminPoint (case sensitive!).
If the Collector agent is installed on a Windows machine, stop the Collector agent before running the or_version_update utility.
To modify the Precise Collector schema
- From the Oracle FocalPoint directory run the following script:
Windowsproducts\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. - 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
| Parameter | Description |
|---|---|
| host | Hostname or IP address of the server on which Oracle is installed. Mandatory |
| Sid | The Oracle SID. Mandatory |
| user | The name of the user with dba privileges. Mandatory |
| password | The password of the dba user. Mandatory |
| port | The Oracle listener port. Only needed when the port has been changed. Optional |
| manual | Indication that you only want to update the Precise registry. Precise for Oracle objects are not updated. Information on what manual tasks have to be performed afterwards are displayed. Optional |
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
- On the server with the Collector agent, open the:
<i3_root>/products/oracle/ORACLE_SID/schema folder. - 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
When running the or_version_update.bat/sh utility, after upgrading an Oracle instance installed on a UNIX machine, you may get a wrong Oracle home. To resolve this issue, go to the latest Known Problems document and see Installation for the Precise for Oracle AppTier section for more information.
When running the or_version_update.bat/sh utility, after changing the Oracle listener port, the Collect agent may be unable to start. To resolve this issue, go to the latest Known Problems document and see Installation for the Precise for Oracle AppTier section for more information.
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal