Configuring the Database
■
Configuring an Oracle 9i Database for CCA
Contact Center Anywhere Installation Guide
Version 8.1
13
@CreateDatabase.sql 'syspassword' 'oracle' 'TWTableSpacecc81'
'c:\oracle\oradata\oracle\twcc81.ora' '500M' 'TWTableSpacecc81Tmp'
'c:\oracle\oradata\oracle\twcc81tmp.ora' '50M' '10M' 'TWRolecc81' 'ADMINCC81'
'admincc81' 'cc81' 'cc81' 'oracle' 'support-db' 1521
3
Open the command line window. Navigate to directory that contains the UseMe.sql file by
cd
command.
4
Open the Sql Plus console by typing:
sqlplus /nolog
5
From the Sql Plus command prompt, type:
@UseMe.sql
to run the script file.
6
After the script file completes running, check all log files created to verify that no error is
reported during database creation process.
Upgrading an Older Oracle 9i Database for CCA
Complete these steps to upgrade an older Oracle 9i database for CCA:
To upgrade an Oracle 9i database for CCA
1
Copy the
Patch
folder for Oracle 9i Database Server from the installation package to the host
used to run database scripts. For example, we put it in
C:\CCA\database\Oracle\Patch
.
2
Edit the
UseMe_upgrade.sql
file in
Patch
folder to reflect the correct information that is
necessary to upgrade the database by using the following guidelines:
NOTE:
Retain the quotation marks (‘’) surrounding the parameters’ values.
■
Replace &1 with the username of the administrator who owns all the objects (tables, views,
indexes, and so on) in the database to be upgraded.
■
Replace &2 with the password of the administrator used in previous parameter.
-- &4 - PathTableSpace
Path for the TAW Table Space
-- &5 - TableSpaceSize
500M Initial size of the Table Space
-- &6 - TWTableSpaceTemp
TAW Temporary Table Space
-- &7 - PathTableSpaceTemp
Path for the TAW Temporary Table Space
-- &8 - TableSpaceTempSize
50M Initial size of the Temporary Table Space
-- &9 - TableSpaceTempGrowthSize
10M Temporary Table Space Growtrh Size
-- &10 - TWRole
TWRole
-- &11 - ADMINCC81 (Admin Username)
ADMINCC81
-- &12 - ADMINCC81 (Admin Password)
ADMINCC81
-- &13 - CC81 (User Username)
CC81
-- &14 - CC81 (User Password)
CC81
-- &15 - Database Service Name
Use by the JDBC Connection
-- &16 - Database Hostname
db Hostname --> Use by the JDBC Connection
-- &17 - Database Port Number
db port number --> Use by the JDBC Connection