IBM Tivoli Monitoring, Version 6.3

Oracle warehouse database procedure

Stop all running Warehouse Proxy agent instances and the Summarization and Pruning agent.
Back up your warehouse database.
Copy the scripts from The Tivoli Enterprise Portal Server in one of the following directories to a temporary directory on the system where the warehouse database is located:
- Windows
```
install dir\CNPS\SQLLIB\WAREHOUSE\Oracle
```
- UNIX and Linux
```
install dir/arch/cq/sqllib/WAREHOUSE/Oracle
```
On the system where the warehouse database is located, change to the directory where you placed the script files in Step 3. Then, connect to the warehouse database through the Oracle command line with the same user that the Warehouse Proxy agent uses to connect to the warehouse, and run the script. To run the script, the user ID must have authorization to alter tables and drop views, or to drop tables when using Case 2 Drop, or truncate tables when using Case 2 Truncate. The output is saved to a file named script name.log. Run the following command:
```
sqlplus ITMUSER/ITMPASS@WAREHOUS @script.sql
```
These parameters are used in the example:
- WAREHOUS is the connect identifier.
- ITMUSER is the user name used by the Warehouse Proxy agent.
- ITMPASS is the password used by the Warehouse Proxy agent.
- script.sql is the name of this script file. See Table 1 for the script file names.
Note: You might receive error messages such as the following from Oracle: ORA-00942: table or view does not exist
This message indicates that the table does not exist and cannot be altered, dropped, or truncated. This happens if you do not have warehousing or summarization enabled for the given table. For example if you only have hourly and daily summarization enabled, you see this message for the weekly, monthly, quarterly, and yearly summarization tables because these tables do not exist.

Feedback