Modify the Oracle Database Host Settings After Installation

Symptom:

After installing the Enterprise Management Server, I need to modify the Oracle database server settings to point to a different server.

Solution:

You can modify the Enterprise Management Server to work with an Oracle database on a different host after installation:

Stop the JBoss application server service on the Enterprise Management Server.
Backup the Oracle database on the current host.
Restore the Oracle database on the new host.
Navigate to the following directory, where JBoss_HOME indicates the directory where you installed JBoss:
```
JBoss_HOME/server/default/deploy
```
Locate and back up the following files:
- imauditdb-ds.xml
- imquartzdb-ds.xml
- imtaskpersistencedb-ds.xml
- imworkflowdb-ds.xml
- objectstore-ds.xml
- reportsnapshot-ds.xml
Open each file and locate the <connection-url> entry.

Modify the connection settings to specify the new Oracle database host name. For example:

<connection-url>jdbc:oracle:thin@//new_host_name:1521/sid_or_service_name</connection-url>

Start the JBoss application server service.
You have modified the Oracle database host settings.