Multiple database instances

Our database and enterprise server is same sun4500 machine. We are having standard four environments – JD, DV, PY and PD. Due to disk space constraint on enterprise server we are thinking of shifting development (DV and PY) database on some other database server. So my question is whether JDE database can be hosted on multiple oracle instances running on different servers? If yes then how to go about it ?

Thanks in advance

This is absolutely possible. In fact it is a good idea to separate your test environments so that if you want to refresh data etc, you are not affecting your production area. We have two separate datbases on two different servers. Database JDE1 hosts all the pathcodes, system tablespoaces and production business data, while database JDET (on a separate machine) hosts our test data and test control tables. I personally favour this configuration as it leaves the DV and PY pathcodes on the main server. In this way you can make sure that all your code is backed up in one database.

To make the change, create an oracle database on your new server and migrate the tablespaces for Business Data - Dev and Business Data - PY along with the associated control table tablespaces. You can do this a number of ways including exporting and reimporting the data, or running R98403.

Add new database datasources to point to the new database and tablespaces and reconfigure your DV and PY environments to point to them.

You will also need to add the setting to point to the new database and server in all your client tnsnames files.

Hope this helps

Regards
Marty