Cisco Cisco Workload Automation 6.3 Guía De Instalación

Installing the CWA Master for Unix

Updating Oracle Schema Manually

If any of the information is incorrect, you can type QUIT to cancel the installation or you can continue with the 
installation and make corrections in the master.props configuration file. 

The Installing screen displays.

Once installation is complete, the Installation Complete screen displays.

Press Enter to exit the installer.

Verify successful installation of the Master files by following the procedure described in 

Note: If you are installing the Unix Master from the command line, you must also manually install the database as a 
separate procedure. This procedure is described in the following section.

Updating Oracle Schema Manually

Although it is recommended that the installation process create the Master database for Oracle, users can create the 
Oracle schema manually. If you are installing the Unix Master from the command-line then you must first create the 
Oracle schema manually. Have your Oracle DBA perform the following procedures.

Locate the connectdb.sql script within the sql directory.

Edit the following parameters in this script:.

Note: For debugging purposes, you can run a spool file as you run the installation script.

create tablespace admiral_data datafile 'ADMIRAL_DATA' size 200m reuse autoextend on; 

create tablespace admiral_index datafile 'ADMIRAL_INDEX' size 100m reuse autoextend on;

create temporary tablespace admiral_temp datafile 'ADMIRAL_TEMP' size 200M reuse;

create user tidal identified by <call Technical Services for password> default 
tablespace admiral_data quota unlimited on admiral_data quota unlimited on 
admiral_index temporary tablespace admiral_temp;

(Contact Technical Services for the password to enter in the brackets < >.) 

grant create session, create table to tidal;
connect tidal/<call Technical Services for password>@ <tnsname>;

(Contact Technical Services for the password to enter in the brackets < >. Replace the string “tnsname” at the end 
of the CONNECT statement with the real TNSName that is used to connect to the Oracle database.)

Note: If you wish to install the datafiles in a specific directory, the Oracle DBA can change the 

CREATE TABLESPACE 

statements to specify a different directory location for the datafiles. The datafile growth options may also be modified 
if desired. Do not lower the default SIZE values.

Enter the information you received from Technical Services in the appropriate brackets in the connectdb.sql script.

Save the script.

Locate the orapopulate.sql script within the sql directory.

Find the following statement and change 

DOMAINNAME and SUPERUSERNAME to be the domain and user name of the 

initial super user account: