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 JDKnot a JREthat corresponds to your operating system (see http://www.oracle.com/technetwork/java/javase/downloads/).
-
Download the Oracle database JDBC driver specific to the edition you are using from http://www.???.com/???/download/ and save in your Apache-Tomcat
libsfolder. -
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 the section called “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 user name and password.
Note
The schema name must be the same as the user name.
