This section includes the following topic:
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
products\oracle\install\or_version_update.bat
-host host
-sid sid
-user user
-password password
[-port port
-manual]
./products/oracle/install/or_version_update.sh
-host host
-sid sid
-user user
-password password
[-port port
-manual]
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
verify_install_oracle_apps.bat
/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 |
When running the |
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal