Configuring an Oracle server database for the UrbanCode Deploy server#
To use an Oracle database with the server, before you install the server, install the Oracle database and provide the JDBC JAR file for the server installation process.
Before you install the UrbanCode™ Deploy server, install an Oracle database. If you are evaluating UrbanCode Deploy, you can install the database on the same system as the UrbanCode Deploy server.
When you install UrbanCode Deploy, you need the Oracle connection information and a user account with resource, connect, create session, and create table privileges.
UrbanCode Deploy supports the following editions.
- Oracle Database Enterprise
- Oracle Database Standard
- Oracle Database Standard One
- Oracle Database Express®
For most production systems, use an architecture that is based on Oracle Real Application Clusters (RAC).
No specific parameterization, optimization setting, or histogram generation is required. The server does not require
n* types, such as
nclob. The server does not support multiple databases.
Note: If you upgrade your database to version 12c, you must edit the installed.properties file on the server and add the following line of code:
Note: It is recommended that the database be encoded in UTF-8. Changing the database to a case-sensitive collation is also recommended.
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.
When multiple drivers are available, you might need to consult with the database provider to determine which driver to use. The JDBC driver version that you must use might depend on the version of the database and the version of Java™ used by the UrbanCode Deploy server.
Copy the JDBC JAR file to installer_directory\lib\ext.
Begin server installation. See Installing the server.
When you are prompted for the database type, enter oracle.
Provide the JDBC driver class UrbanCode Deploy uses to connect to the database.
The default value is
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)))
Finish by entering the database user name and password.
Note: The schema name must be the same as the user name.
Parent topic: Installing the server database