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.

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 at a minimum the following privileges:
  • RESOURCE
  • CONNECT
  • CREATE SESSION
  • CREATE TABLE
Oracle Version 11g or later is supported for each of the following editions.
  • Oracle Database Enterprise
  • Oracle Database Standard
  • Oracle Database Standard One
  • Oracle Database Express

The server expects data from the database to be encoded in UTF-8.

No specific parametrization, 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.

The IBM UrbanCode Release database consists of approximately fifty tables. While storage requirements vary by installation, database storage of 10-20 GB is sufficient for most installations.

Note:
  • If upgrading to Oracle Version 12c, you must edit the installed.properties file on the server and add the following line of code:
    hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
  • If upgrading to Oracle Version 19c, download the ODBC8 driver should be downloaded from Oracle website and that should be placed in the /urbandcode_release_dir/lib/ext directory.

Ensure that the hibernate.connection.url property in the installed.properties file points to the updated database.

Finally, update the JDBC driver in the /urbandcode_release_dir/server/tomcat/lib/ext directory.

To configure an oracle database complete the following 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 the install program.
  2. Record the values of the database parameters so that you can supply them when you 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 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
    In the case of Oracle RAC, you might need to specify properties in the connection string in the format of the following example:
    jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)
  (HOST=host)(PORT=port))(CONNECT_DATA=(SERVICE_NAME=port)))
    If you have more than one server, specify the host name and port of each server, as in the following example:
    jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
  (ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=port1))
  (ADDRESS=(PROTOCOL=TCP)(HOST=server2)(PORT=port2))
  (CONNECT_DATA=(SERVICE_NAME=service)))
    Note: Set the database schema to use as the user's default schema.