Configuring the Oracle Database for Use with Sterling Gentran:Server

We suggest that you define a new tablespace in Oracle where the Sterling Gentran:Server® database tables can be created. This ensures that the database tables are not created in the system tablespace.

Note: Make sure to specify that the NLS_LANG parameter is set to American and the NLS_Territory parameter is set to America so the audit log will work correctly.

Use this procedure to complete your Oracle database installation when you are installing a new Sterling Gentran:Serversystem.

Create two ODBC Data Sources in Microsoft Windows: one using the Microsoft ODBC for Oracle driver and the other using the Oracle ODBC driver.
Note: Make sure both are unique names and are set up as system DSNs.
If it is available, use the Oracle ODBC Test tool to verify that the system has access to the database through both drivers. See your Oracle documentation for more information about using the Oracle ODBC Test tool.
Begin your Sterling Gentran:Server installation.
When the install prompts for the name of the DSN you want to use with Sterling Gentran:Server, type the DSN you created with the Microsoft ODBC for Oracle driver.
The install will then prompt for the name of the DSN created with the Oracle ODBC driver.
Enter the DSN name for the Oracle ODBC driver.
Finish the installation of the primary Sterling Gentran:Server system controller and apply any necessary options.
If you want to verify your installation, continue with the next step. Otherwise, you have completed your Oracle database installation.
After the installation process is complete, run the Sterling Gentran:Server System Configuration utility by selecting from the Start menu Programs > Gentran Server > Gentran Server Configuration.
The system displays the System Configuration dialog box.
Select the System tab and verify that the DSN indicated uses the Oracle ODBC driver from the ODBC Data Source list.
Select the Audit/Notification tab and click Server.
The system displays the Audit/Notification Server Properties dialog box, which enables you to configure database and notification server options.
Verify that ODBC Data Source setting for Audit/Notification (in the ODBC Data Source list) indicates the DSN that uses the Microsoft ODBC driver. Change the setting if necessary.
Click OK to exit the System Configuration utility.
Run the Mailbox Server Manager by selecting from the Start menu Programs > Gentran Server > Gentran Server Mailbox.
The system displays the Mailbox Server Manager.
Register your Mailbox Server.
See the IBM® Sterling Gentran:Server for Microsoft Windows Communications User Guide for more information.

Note: The Mailbox Server is the Microsoft Windows machine name of the Sterling Gentran:Server system.
Right-click on the server name in the display and select Properties.
The system displays the Server Properties dialog box.
On the Database tab, verify that the ODBC Data Source setting indicates the DSN that uses the Oracle ODBC driver.
Note: ODBC translation with an Oracle database should always use an Oracle ODBC driver. Microsoft ODBC Oracle drivers are not supported for ODBC translation and will result in translation errors.
If you have made any changes to the DSN selections, you need to restart the Sterling Gentran:Server services. From the Control Panel, access the Windows Services dialog box and stop and restart your Sterling Gentran:Server services in the following order:
1. Audit Notification Service
2. Mailbox Service
3. Executive Service
See your Microsoft Windows documentation more information about stopping and starting services.