LDN - Luminis Developer Network

We had an instance (no pun intended) where I had to change the database that supports our production instance of the portal. I'm talking moving the database to completely new production hardware.

First off, I exported and imported the LUMINIS and UPORTAL schemas from our old instance into our new one. Then I perused through a configman -x dump and looked for the database connection settings and then decided to look at the support site.

Answer 931 lists instructions on how to do just this. While it looks as though it is for III.2 only, it works for III.3 as well.

Here are the settings you need to change -

database.GroupTools.datasource=sqlserver1
database.TargetedAnnouncements.datasource=sqlserver1
database.datasource.oracle1.allocatedConnectionTimeout=300
database.datasource.oracle1.deallocatedConnectionTimeout=300
database.datasource.oracle1.driver=oracle.jdbc.driver.OracleDriver
database.datasource.oracle1.host=
database.datasource.oracle1.maxConnections=65
database.datasource.oracle1.minAllocatedConnections=50
database.datasource.oracle1.minDeallocatedConnections=3
database.datasource.oracle1.name=
database.datasource.oracle1.password=
database.datasource.oracle1.port=1521
database.datasource.oracle1.type=Oracle
database.datasource.oracle1.url=jdbc:oracle:thin:@:1521:
database.datasource.oracle1.user=
database.datasource.sqlserver1.driver=com.jnetdirect.jsql.JSQLDriver
database.datasource.sqlserver1.host=slcsup20.sct.com
database.datasource.sqlserver1.name=slcsup42a
database.datasource.sqlserver1.password=pipeline
database.datasource.sqlserver1.pool.allocatedConnectionTimeout=300
database.datasource.sqlserver1.pool.deallocatedConnectionTimeout=300
database.datasource.sqlserver1.pool.maxConnections=65
database.datasource.sqlserver1.pool.minAllocatedConnections=50
database.datasource.sqlserver1.pool.minDeallocatedConnections=3
database.datasource.sqlserver1.port=1433
database.datasource.sqlserver1.type=SqlServer
database.datasource.sqlserver1.url=jdbc:JSQLConnect://slcsup20.sct.com:1433/DatabaseName=slcsup42a
database.datasource.sqlserver1.user=tgreen

Depending on your installation, change the first 2 lines to either sqlserver1 or oracle1

database.GroupTools.datasource=oracle1
database.TargetedAnnouncements.datasource=oracle1

this refers to the rest of the settings. If you're using oracle like we are, use oracle1 and ignore all the sqlserver1 settings. You can leave them as-is, they won't hurt anything.

If you've never used configman before, to change a setting use the -s (set) switch like this :

configman -s database.GroupTools.datasource sqlserver1

Notice you leave off the = sign

However, if you want to make it easier on yourself, create a text file, paste these setting in it just like they are above, keeping the = signs this time. Change the values you need to change for your configuration and save the file (something like database_parms.cfg) somewhere on your luminis box.

From a command prompt on your luminis box, cd to the location you saved your file and issue this command :

configman -i database_parms.cfg

This will import the settings all at once.

Now you must change one other item, the rdbm.properties file. This is located in $CP_WEBINF/config

Change the jdbc:oracle:thin:@:
: line to your new database information.

Save this file, and then bounce luminis.
When it comes up, it'll wake up at its new location.

-Jon