Installing Oracle

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.

Serena Release Automation supports the following editions:

Oracle Database Enterprise
Oracle Database Standard
Oracle Database Standard One
Oracle Database Express

Version 10g or later is supported for each edition.

To install an Oracle database:

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 IDENTIFIED by serena_ra;

GRANT CONNECT TO serena_ra;

GRANT RESOURCE TO 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]/[SID]

For example:

jdbc:oracle:thin:@localhost:1521/dim12
Finish by entering the database username and password.

Note: The schema name must be the same as the user name.