Configuring Oracle database

To use Oracle Database as the persistent storage repository for the SafeLinx Server, complete the following configuration instructions.

Before you begin

Oracle Database is supported for use with SafeLinx Server installations on Linux only. You cannot use Oracle Database with a SafeLinx Server that is installed on Windows Server.

Procedure

To configure Oracle for use with the SafeLinx Server:
  1. Make sure that the SafeLinx Server is installed.
  2. Make sure that you meet the third-party software requirements and install the software according to the recommendations of the manufacturer.
  3. During the installation, the SafeLinx Server checks for a supported version of the Oracle DataDirect ODBC Oracle Wire Protocol Driver. Verify that a DataDirect Connect ODBC driver that is compatible with the version of Oracle Database is installed. Also, download and apply any available patches for the DataDirect ODBC driver. For more information, see the system requirements.
  4. Create or choose an Oracle database to contain the session information and accounting and billing tables
  5. Copy the ODBC driver odbc.ini file to the conf directory of the SafeLinx Server installation directory and open the copy in a text editor.
  6. Add a line that is labeled wgdata=Comment text in the section of the file that is labeled ODBC Data Sources, where comment text can be any descriptive string. If you installed the accounting and billing support, also add a line that is labeled wgacct in same section of the file.
  7. In the wgdata section of the file, add the following line:

    TimestampTruncationBehavior=1

    If the file contains a wgacct section, add the preceding line to that section also.

  8. Use the Oracle Wire Protocol section as a template and create corresponding definitions. The Oracle Wire Protocol section provides Oracle database access without requiring an Oracle client.

    For an Oracle Wire Protocol section, update the Description, Hostname, PortNumber, and SID. Hostname is a host name or IP address that identifies the Oracle server. PortNumber identifies the port number on which the Oracle server is listening. You must include a SID (Oracle System Identifier) value if the Oracle server supports more than one instance of an Oracle database.

  9. Remove the LogonID and Password keys.
  10. Save and exit the file.

When you create a SafeLinx Server, the Add wizard prompts you to configure the relational database. Assign a database name and a database administrative ID and password. For Oracle, the database name corresponds to the Data Source Name defined in the odbc.ini file.