Configuring the Database ■ Configuring an Oracle 9i Database for CCA
To create a new Oracle 9i database
1Copy the database\Oracle\Automated directory from the CCA installation package to the host you use to run database creation scripts.
2Edit 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 |
| |||
- | Database TNS Name | my_db_connection | |||
&3 | - | TWTableSpace | CCA db Table | Space | |
12
Contact Center Anywhere Installation Guide Version 8.1