Administrative tasks - Oracle

A script is provided to perform actions such as granting rights or reorganizing the database. The file is located in inst_dir/dbtools/oracle/script

Oracle
dbgrant
This script grants the user permissions for the Dynamic Workload Console views. See the Dynamic Workload Console online help for full details.
A second script named dbmove is available, but it is to be run only if requested by Software Support.
Note: Do not run the dbmove script unless instructed to do so by Software Support. Running the script autonomously might damage or overwrite the data in your database.
Ensure you have the following permissions before running the scripts:
  • Oracle administrator permissions – the user must be defined to Oracle as an administrator
  • Full access (777) to the HCL Workload Automation installation directory
You can perform a number of other tasks on Oracle databases as follows:
Changing the Oracle access password
For more information, see Changing the properties for the database.
Maintaining the Oracle database
Like DB2, Oracle has a routine that regularly maintains the database. Similarly, this too can be run manually. The tool is invoked as follows: 
dbms_stats.gather_schema_statsschema_owner
See the Oracle documentation for full details of how and when to run it.
Obtaining information about the HCL Workload Automation databases installed on an Oracle instance
To determine which HCL Workload Automation databases are installed on an Oracle instance, do the following: 
su - oracle (UNIX only)
 sqlplus system/system_password@service_name
SQL> select * from all_tws_schemas;
The output should look like the following: 
SCHEMA_NAME
------------------------------
MDL
mdm10.2.3 <TWS_user>
Note:
  1. More than one instance of HCL Workload Automation can be shared in one instance of Oracle, using different schemas.
  2. In Oracle, the concept of "schema" and "user" are the same, so dropping an Oracle schema means dropping an Oracle user, which you do as follows: 
    SQL> drop user MDL cascade;