Configuring an Oracle database

You can use Oracle as a supporting database with IBM® UrbanCode Release server. Create the database before you install IBM UrbanCode Release. Typically the database is installed on a computer other than the one where the server is located.

About this task

When you install IBM UrbanCode Release, you need the database connection information and the JDBC JAR file. The user account for the database must have these minimum privileges:

RESOURCE, CONNECT, CREATE SESSION, and CREATE TABLE.

IBM UrbanCode Release supports the following editions. Version 11g or later is supported for each edition.

No specific parameterization, optimization setting, or histogram generation is required. The server does not require n* types, such as nchar, nvarchar2 and nclob. The server does not support multiple databases.

Procedure

  1. Obtain the Oracle JDBC driver JAR file for the edition of Oracle that you are using. The JDBC JAR file is included with the Oracle installation files. This file must be available when you run IBM Installation Manager.
  2. Record the values of the database parameters so that you can supply them when you run IBM Installation Manager and install IBM UrbanCode Release. The following parameters are typical for an installation of Oracle used to support IBM UrbanCode Release:
    Parameter Value
    Database user name ibm_ucr
    Database password user_account_password
    Database driver class oracle.jdbc.driver.OracleDriver
    Database connection string jdbc:oracle:thin:@database_server:1521:ORCL
    Note:

    Set the database schema to use as the user's default schema.


Feedback