Changing the product database

This topic describes how to change the database used by BMC Release Process Management.

To change the current database for the product, complete the following steps:

1. Stop the BMC Release Process Management service.
2. Go to RLMhome\releases\currentProductVersion\RPM\portal.war\WEB-INF\config.
3. Open the database.yml file in a text editor.
4. Change parameters the development, test, and production parameters as appropriate for your new database:

   • If you want to use PostgreSQL as your new database, enter the following parameters:

     adapter: jdbcpostgresql
     database: <database_name>
     host: <database_host_address>
     port: <database_port> # the default port is 5432
     username: <database_username>
     password: <database_password>
     encoding: utf8
     pool: 12
     wait_timeout: 10

   • If you want to use Oracle as your new database, enter the following parameters:

     adapter: oracle_enhanced
     database: <sid>/</service name> # specify either database SID or service name
     host: <database_host_address>
     port: <database_port> # the default port is 1521
     username: <database_username>
     password: <database_password>
     encoding: utf8
     pool: 12
     wait_timeout: 10
     cursor_sharing: EXACT

     Note

     If you use database service name for the connection, type a slash (/) before the service name.

     For example, if your service name is rpmorclservice, type database:/rpmorclservice.

     By default, the adapter sets the cursor_sharing value as FORCE. This overrides any configuration set on the database at the system level. Specify the value for cursor_sharing as EXACT to avoid performance issues.

   • If you want to use Microsoft SQL Server as your new database, enter the following parameters:

     adapter: jdbcmssql
     database: <database_name>
     host: <database_host_address>
     port: <database_port> # the default port is 1433
     username: <database_username>
     password: <database_password>
5. Save your changes.
6. Start the BMC Release Process Management service.