Oracle 8i

To create and configure an Oracle database, follow the instructions in the sections below:

  1. Create the Oracle Database

  2. Open an Oracle Client Tool

  3. Create a Tablespace

  4. Create a User

  5. Install Native Oracle JDBC Driver

Additional Information

For descriptions of bracketed names (for example, <DBA name>), see Documentation Conventions.

Create the Oracle Database

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.

Top

Open an Oracle Client Tool

  1. 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.

  2. In the Oracle Enterprise Manager Login dialog box, select "Launch DBA Studio standalone".  

    Click OK.

  1. 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.

Top

Create a Tablespace

  1. Expand the server name, expand Storage, then expand Tablespaces.

  2. Right-click Tablespaces and select Create...

  3. Enter the Name of the database that you want to create, for example "CCS" and change the size of the database.

    Database Sizing Guidelines:

Top

Create a User

  1. Expand the server name, then expand Security, then expand Users.

  2. Right-click Users and select Create..

  3.  Enter a Name for the database user and a Password (enter a confirmation password as well).

  4.   Under Tablespaces click Default to display the list of tablespaces. Select the tablespace that you previously created (for example CCS). 

  5. 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.

  6.   A dialog box appears confirming that you have created the user.

Top

Install Native Oracle JDBC Driver

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):

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.  

Top

Calculate Database Size

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

 

Database Sizing Example

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

Calculations

 

Calculation

TOTAL

[Number of agents]
* [Number of logins and logouts per day]

logins and logouts per day

[Number of sessions per day]
* [Agent session size]

session size per day

[Number of sessions per day]
* [Number of chat messages per session]
* [Average size of a chat message]

chat size per day

[Number of sessions per day]
* [Number of shared URLs per session]
* [Average size of a shared URL]

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.

Top