Configuring an Oracle database

Before you install the server, install the Oracle database and provide the JDBC JAR file for the installation process.

Before you begin

Before you install the IBM® UrbanCode Deploy server, install an Oracle database. If you are evaluating IBM UrbanCode Deploy, you can install the database on the same system as the IBM UrbanCode Deploy server.

When you install IBM UrbanCode Deploy, you need the Oracle connection information and a user account with table creation privileges.

IBM UrbanCode Deploy supports the following editions:

Version 10g or later is supported for each edition.

Procedure

  1. Obtain the Oracle JDBC driver. The JDBC JAR file is included among the Oracle installation files. The driver is unique to the edition you are using.
  2. Copy the JDBC JAR file to installer_directory\lib\ext.
  3. Begin server installation, see Installing the server. When you are prompted for the database type, enter oracle.
  4. Provide the JDBC driver class IBM UrbanCode Deploy uses to connect to the database. The default value is oracle.jdbc.driver.OracleDriver.
  5. Provide the JDBC connection string. The format depends on the JDBC driver. Typically, it is similar to the following code:
    jdbc:oracle:thin:@DB_URL:DB_PORT
    For example:
    jdbc:oracle:thin:@localhost:1521
  6. Finish by entering the database user name and password.
    Note: The schema name must be the same as the user name.

Feedback