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.
- CREATE SESSION
- CREATE TABLE
- 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
nclob. The server does not support multiple
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.
- If upgrading to Oracle Version 12c, you must edit the
installed.propertiesfile on the server and add the following line of code:
- 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:
- 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.
Record the values of the database parameters so that you can supply them when you install
Release. The following parameters are typical for an installation of Oracle used to support IBM UrbanCode
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:
In the case of Oracle RAC, you might need to specify properties in the connection string in the format of the following example:
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.