To create and configure an Oracle database, follow the instructions in the sections below:
Additional Information
For descriptions of bracketed names (for example, <DBA name>), see Documentation Conventions.
Follow the instructions in Oracle user documentation to create an Oracle database.
When creating the database, select the character set UTF8. The UTF8 character set handles non-Latin 1 character storage and is necessary to ensure that storing data in Unicode is acceptable. Select the UTF8 character set for each database you create.
For more information on Unicode and internationalization features in Collaboration, refer to the Collaboration Administration Guide.
These instructions assume you have a functional version of Oracle DBA Studio.
From the Windows Start menu, select an Oracle client tool such as SQL Worksheet or SQL Plus to access the Oracle server. These instructions assume that you are using SQL Worksheet.
In the Oracle
Enterprise Manager Login dialog box, select "Launch DBA Studio
standalone".
Click OK.
The Oracle DBA Standalone application opens. Select the service in which you want to create a new tablespace for use with CCS. After selecting the service, login using the service username and password.
Expand the server
name, expand Storage, then
expand Tablespaces.
Right-click Tablespaces and select Create...
Enter the Name
of the database that you want to create, for example "CCS" and
change the size of the database.
Database Sizing Guidelines:
Change the database size to 30 MB for general testing purposes
Change the database size to 100 MB for load testing
For production settings, see Calculate Database Size
A dialog box appears confirming that you have created the tablespace.
Expand the server
name, then expand Security,
then expand Users.
Right-click Users and select Create..
Enter
a Name for the database user and
a Password (enter a confirmation
password as well).
Under Tablespaces
click Default to display the list
of tablespaces. Select the tablespace that you previously created (for
example CCS).
Click the Role tab. Select Resource from the top frame of the tab, then click the down arrow key to add Resource to the list of granted roles. Click Create when finished.
A dialog box appears confirming that you have created the user.
To connect to the database, copy the Oracle JDBC-Thin Driver v8.1.7 (classes12.zip) to the <CCS install dir>\servlet directory.
To locate the Oracle JDBC-Thin Driver v8.1.7 driver (Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.2.x):
Search your Oracle installation CDs for the file classes12.zip, or
Go to the Oracle download site (http://technet.oracle.com/software/download.htm). If you are not already a member of the Oracle Technology Network, click on the membership link at the top of the page to join. Membership is free.
Note: If you are already a member of the Oracle Technology Network, you can find the classes12.zip file at:
http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/winsoft.html
From the Oracle installation CD or the Oracle download site, copy the file classes12.zip to <CCS install dir>\servlet.
Note: If IIS is running then you need to restart the server before Collaboration can detects the newly installed drivers.
Important: Do not unzip the classes12.zip file.
Your database sizing requirements will depend on the behavior of your customer service agents. We suggest that you contact customer support for database sizing recommendations.
Please complete the following table before contacting customer support.
Estimate the number of ... |
Estimate |
Logins and logouts per agent per day |
|
Sessions per day (all agents) |
|
Chat messages per session |
|
Shared URLs per session |
|
Agents active each day |
|
Days to retain data |
|
The figures below are included as examples only. Contact customer support for sizing information specific to your database configuration.
Event |
Memory Allocation |
Agent login |
320 bytes |
Agent logout |
320 bytes |
Agent session |
2200 bytes |
Average size of a chat message |
100 bytes |
Average size of a shared URL |
100 bytes |
Calculation |
TOTAL |
[Number of agents] |
logins and logouts per day |
[Number of sessions per day] |
session size per day |
[Number of sessions per day] |
chat size per day |
[Number of sessions per day] |
shared URL size per day |
Add the per-day totals and multiply by the [Days to retain data].
Allocate additional memory for static agent data.