Oracle

Set up the following system environment variable:

 LOCAL = <tns for SERVICESscheduling and SWAT DBs>.

For example:

• Right-click My Computer, click Properties, click Advanced, click Environment Variables, click New under System Variable.
• Variable name: LOCAL
• Variable value: <tns for SERVICESscheduling and SWAT DBs>
• Click OK
  
  

Create the ServiceSWAT Console Database User in the same Oracle instance as the ServiceScheduling schema. This user should have the same permissions as are required for the ServiceScheduling database user.

Sample SQL to create user:

 CREATE USER <SWAT_CONSOLE>
 IDENTIFIED BY <SWAT_CONSOLE>
 DEFAULT TABLESPACE <TS01>
 TEMPORARY TABLESPACE <TEMP>
 QUOTA unlimited ON <TS01>;
 GRANT spdev TO <SWAT_CONSOLE>

As an example, use USERS instead of <TS01> and temp instead of <TEMP>:

Ensure that the properties file is updated with the ServiceSWAT console users value entered above:- “console_username” and “console_password”.

The values in the properties file are used by the Perl scripts to add permissions to database users during setup of the ServiceSWAT instance.

Run <installation directory>\webapps\ServiceSWAT\database\SWAT-runall-Once.sql against ServiceSWAT Console Schema:

sqlplus <console username/console password> @SWAT-runall-Once.sql