Welcome, Guest Login

Rundeck Enterprise Support Center

Oracle Setup

Last Updated: Feb 03, 2017 10:31AM PST

Setup steps to connect Rundeck with Oracle
 

1) Download the latest oracle driver (eg, ojdbc7.jar version 12.1.0.2): 

http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html
Copy the downloaded file (ojdbc7.jar ) to the $CATALINA_HOME/lib 


2) Update  $RDECK_BASE/etc/rundeck-config.properties:

rundeck.projectsStorageType=db

dataSource.url = jdbc:oracle:thin:@127.0.0.1:1521:orcl (change server name and instance name)
dataSource.driverClassName = oracle.jdbc.driver.OracleDriver
dataSource.username = XXXXXX
dataSource.password = XXXXXXX
dataSource.dialect = org.hibernate.dialect.Oracle10gDialect

 

3) Database’s tables must be created manually ( to avoid issue https://github.com/rundeck/rundeck/issues/676) . 

You can copy the table creation script from this URL: 
http://support.rundeck.com/customer/portal/articles/2447898-oracle-script-‚Äč

The database user should have the following permissions in order to create all needed database objects:

grant create session to username;
grant create sequence to username;
grant create table to username;

 

4) Add the following command line when start rundeck: -Dhibernate.jdbc.use_get_generated_keys = true (to avoid this issuehttp://stackoverflow.com/questions/24050291/grails-hibernate4-upgrade-errors-on-
getgeneratedkeys
)


  Edit the file setenv.sh en $CATALINA_BASE/bin or 
  /etc/tomcat/tomcat.conf  (Red Hat) to add the 
hibernate.jdbc.use_get_generated_keys parameter

  JAVA_OPTS="$JAVA_OPTS -XX:MaxPermSize=256m -Xmx1024m -Xms256m -server  -            
   Drdeck.base=$RDECK_BASE -Drundeck.config.location=$RDECK_BASE/etc/rundeck-config.properties
-Dhibernate.jdbc.use_get_generated_keys=true
"

 

1fb43f9155a47800b95738aff7e657fc@rundeck.desk-mail.com
http://assets0.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete