I'm working on removing a single-point of failure in a SOA & OSB infrastructure, the database. We have a limited number of resources and will only have a production RAC One Node database but would like to experiment and test it with out development & quality assurance SOA and OSB systems. This means that we would like to either;
A) Convert, test, revert.
- Convert our DEV SOA/OSB datasources to RAC multi data source
- Conduct our tests
- Revert (is this possible?) our DEV SOA/OSB datasources back to normal, non-RAC multi data source.
- Repeat 1 through 3 with QA SOA/OSB datasources.
- Repeat 1 through 3 with Production SOA/OSB datasources.
-- OR --
B) Backup, convert, test, restore.
- Backup our DEV SOA/OSB installation and database
- Convert our DEV SOA/OSB datasources to RAC multi data source
- Conduct our tests
- Restore our DEV SOA/OSB installation and database to the previous non-RAC version.
- Repeat 1 through 4 with QA SOA/OSB datasources.
- Repeat 1 through 4 with Production SOA/OSB datasources.
Finally, is a 'Convert to RAC multi data source' just a change in the data source identifier? Would a reversion just be a RAC multi data source with only one instance?
Cheers
Antony
ps This is the JDBC Component Schema Configuration screen:
This is the RAC multi data source configuration screen:
