Configuring your enterprise database

Configuring an Oracle database

Where you can install the database

You can install an Oracle 8.1.7 database and the ContentReporter server on the same machine or on different machines. If you install them on different machines, you must install an Oracle 8.1.7 client on the ContentReporter server machine.

Required configuration procedures

You must perform the following procedures to configure an Oracle database:

Configure the database to work with ContentReporter
Configure ContentReporter to use the Oracle database

The DB Admin tab with Oracle settings

The following screen shows the DB Admin tab with Oracle settings.

Database settings

The following table describes the Oracle database settings in ContentReporter.

Database setting	Description
User name	The Oracle user name of the account that ContentReporter uses to access the database.
Password	The password for the Oracle user account that ContentReporter uses to access the database.
Hostname	The Oracle server machine name. Example: If the machine name is "bills-nt.domainname.com," the host name is either "bills-nt" or "bills-nt.domainname.com."
Port	The port through which the ContentReporter server connects to an Oracle database. The default port is 1521.
Database Home	The Home directory of the Oracle database server or Oracle client.
SID	The Oracle Service Name or SID of the database instance used with ContentReporter.

Client requirements

The following table lists the ContentReporter server's Oracle client requirements.

Characteristic	Requirement
Version	The Oracle client's version (8.1.7) must match the Oracle database server's version.
Installed utilities	JDBC Drivers and SQL Loader utilities installed. These are part of the "Typical" client installation.

Configuring the database

To configure the database for ContentReporter, complete the following steps.

Step	Action
1	If you installed...	Then...
	The ContentReporter server and Oracle server on different machines	Install an Oracle 8.1.7 client on the ContentReporter server machine. Ensure that the SQL Loader utilities for the client are installed. These are included in the "Typical" installation.
	The ContentReporter server and Oracle server on the same machine	Ensure that the JDBC Drivers and SQL Loader utilities for the Oracle server are installed.
2	Create a user account for ContentReporter.
3	Go to Configuring ContentReporter.

Configuring ContentReporter

To configure ContentReporter for the database, complete the following steps.

Step	Action
1	Log into ContentReporter, and click the Administration tab.
2	Click Admin.
3	From the Cache Groups tab, click the DB Admin tab. Note At any point, you can click Reset to reset the database settings on this tab to their current (actual) state.
4	Select Oracle from the Database drop-down list.
5	Enter the Oracle account user name in the Username field, and enter the account password in the Password field.
6	Enter the Oracle server machine name in the Hostname field.
7	Ensure that port 1521 (or the appropriate port) appears in the Port field.
8	Click Browse to browse to and select the Oracle Home directory path, or enter the Home directory path manually. Example: F:\\oracle\\ora817\\
9	In the SID field, enter the Oracle Service Name or SID of the database instance used with ContentReporter.
10	Test ContentReporter server's connection to the Oracle database by clicking Test DB Connection.
11	If...	Then...
	A successful connection exists between ContentReporter and the Oracle database	Click OK. Click OK again.
	The database connection test failed	Click OK. Verify the information you entered and check network connectivity between the ContentReporter server and the SQL server. Repeat Step 10.
12	From the Administration page, log out of ContentReporter.
13	Stop and restart the ContentReporter service. (In Windows NT: Click Start > Settings > Control Panel > Services. Then stop and start the ContentReporter service. In Windows 2000: Right-click My Computer > Manage > expand Services and Applications > double-click Services. Then stop and start the ContentReporter service.) Note Any time you modify database settings, you must stop and restart the ContentReporter service for the new settings to take affect. You might need to wait a moment for ContentReporter to start running. Result: You successfully configured ContentReporter to use an Oracle database.