Installing Oracle

Before installing the Release Automation server, install an Oracle database. If you are evaluating Release Automation, you can install the database on the same machine where the Release Automation server will be installed.

When you install Release Automation, you will need:

the Oracle connection information, and
a user account with table creation privileges.

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 the Oracle JDBC driver specific to the database edition you are using (see http://www.oracle.com/technetwork/indexes/downloads/index.html) and save it in your application server libs directory for Tomcat or lib directory for JBoss.
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 the 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 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 and whether you are connecting using a service or an instance name.
- If you are connecting using a service name, the format is similar to:
  jdbc:oracle:thin:@//[DB_HOST]:[DB_PORT]/[SID]
  
  For example:
  
  jdbc:oracle:thin:@//serverName:1521/serena_ra
- If you are connecting using an instance name, the format is similar to:
  jdbc:oracle:thin:@[DB_HOST]:[DB_PORT]:[SID]
  
  For example:
  
  jdbc:oracle:thin:@serverName:1521:serena_ra
Finish by entering the database username and password.

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