This topic describes how to change the database used by BMC Release Process Management.
Note
Before you begin, ensure that the new database version is the same as your current BMC Release Process Management application version.
To change the current database for the product, complete the following steps:
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>