Changing Metadata Repository

In my earlier post I wrote about and how to create metadata repository. In this I am writing how to change the metadata repository. By changing metadata repository means pointing the BPM to store the BPEL processes and instances information on a new server.

There are two ways of doing the same :

1. First is through EM (Enterprise Manager) console and
2. The second is directly editing the data-sources.xml file.

So, lets do it through first method.

Through Enterprise Manager or EM Console

1. Login to EM Console.
2. Click the instance for which data repository has to be changed. In this case oc4j_soa.
3. 
   Click on administration tab.
4. 
   Click on the arrow against the JDBC Resources.
5. 
   Click on the connection pool for which data repository has to be changed.
6. 
   Enter the URL and credentials of new database.
7. 
   Click Apply.
8. Repeat from step 5 for other connection pools.
9. Restart the SOA Suite.
10. You are done.

The other way to do the same is to directly edit the data-sources.xml file.

Here are the steps:

1. Find data-sources.xml in [Oracle Home\j2ee\oc4j_soa\config]
2. Open it in any text editor.
3. You'll find the sections as below:
   
4. Replace the values of host port service_name with that of new database.
5. Restart the SOA Suite.