Oracle Audio Technologies 8.1 - Manual (Page 14)

Contact Center Anywhere Installation Guide Version 8.1
Configuring the Database ■ Configuring an Oracle 9i Database for CCA
12
To create a new Oracle 9i database
1 Copy the database\Oracle\Automated directory from the CCA installation package to the host you
use to run database creation scripts.
2 Edit the UseMe.sql file to reflect the correct information necessary to create the database by
using the following guidelines:
NOTE: Keep the quotation marks (‘’) surrounding the parameters’ value.
■ Replace &1 with the password of the sys user.
■ Replace &2 with the name of the connection to the database server saved in tnsnames.ora
file. The tnsnames.ora file typically resides at ORACLE_HOME\network\admin.
■ Replace &3 with the name of the table space that will contain all database tables.
■ Replace &4 with the path to the location where table space will be created. For example,
C:\oracle\oradata\oracle\twcc81.ora.
■ Replace &5 with the size of the table space. The default size is 500MB. This value is not a
limitation, and the database can grow over that limit.
■ Replace &6 with the name of the temporary table space that contains temporary data, which
occurs, for example, when a complex SELECT statement is executed.
■ Replace &7 with the path to the location where the temporary table space will be created.
For example, C:\oracle\oradata\oracle\twcc81tmp.ora
■ Replace &8 with the size of the temporary table space. The default size is 50MB.
■ Replace &9 with the growth size of the temporary table space. The default size is 10MB.
■ Replace &10 with the name of the database role will be created.
■ Replace &11 with the username of the user that has administration privileges on the new
database. For example, admincc81 can be used.
■ Replace &12 with the password of user declared in parameter &11.
■ Replace &13 with the username of user who has access to the CCA database. For example,
cc81.
■ Replace &14 with the password of user declared in parameter &13.
■ Replace &15 with the database service name (SID).
■ Replace &16 with the host name or IP address of the database server.
■ Replace &17 with the port that Oracle 9i database server uses to listen for new connection.
By default, port 1521 is used by Oracle 9i database server. If your Oracle 9i database server
is using a different port, this value must be modified.
After editing the script file, it returns to the following:
-- &1 - sys password sys_password
-- &2 - Database TNS Name my_db_connection
-- &3 - TWTableSpace CCA db Table Space