Before installing the Serena Release Automation server, install an Oracle database. If you are evaluating Serena Release Automation, you can install the database on the same machine where the Serena Release Automation server will be installed.
When you install Serena Release Automation, you will need:
the Oracle connection information, and
a user account with table creation privileges.
Oracle Database Enterprise
Oracle Database Standard
Oracle Database Standard One
Oracle Database Express
Version 10g or later is supported for each edition.
Download and install the JDK–not a JRE–that corresponds to your operating system (see http://www.oracle.com/technetwork/java/javase/downloads/).
Download the Oracle JDBC driver specific to the database edition you are using (see http://www.oracle.com/technetwork/indexes/downloads/index.html) and save in your Apache-Tomcat libs folder.
Install the JDBC driver.
Create the Oracle database by executing the following commands:
CREATE USER serena_ra;
GRANT CONNECT, RESOURCE serena_ra
Begin server installation, see Server Installation.
Select the Oracle database option in the installer.
Provide the Oracle JDBC driver (see step 2).
Provide the JDBC driver class Serena Release Automation will use to connect to the database.
The default value is:
oracle.jdbc.driver.OracleDriver
Provide the JDBC connection string. The format depends on the JDBC driver. Typically, it is similar to:
jdbc:oracle:thin:@[DB_URL]:[DB_PORT]
For example:
jdbc:oracle:thin:@localhost:1521
Finish by entering the database username and password.
NOTE
The schema name must be the same as the user name.