N/APosted on - 01/19/2012
We are using ORACLE RDBMS 22.214.171.124. We are also using E-business suit 126.96.36.199. The platform for this is Solaris 10. The same server stored the application and database. We are looking for input to add another server for installing the application only. We also want to put this server in another location. Can we use the same database in two applications? If it is possible, please explain how we can do this. Kindly provide some notes on it. Thank you.
How can we add another server for E-business suit application only?
You can surely use one database in both the applications provided they support the alternative format of the database.
First make sure that your second server has the same ORACLE RDBMS and the E business suit installed.
After that, copy the whole database from the server 1.
Go to the path where you want to put it in the server 2 and paste it.
Now open the ORACLE in the 2nd server and import the database from that path where you pasted it.
Click ok and it will load the database without any problem.
You might need to copy the coding for the triggers and insert codes and then run it again on the 2nd server so that they are created also.