Question

Two Applications sharing the same database

Shared databases, Database administration, Oracle security, Database security, Oracle 9, Oracle, Solaris 10, Solaris, Oracle E-Business Suite

Hi ,

We have ORACLE RDBMS 9.2.0.6 ,and E-business suit 11.5.10.2 .
Platform is Solaris 10.
The applicatioin and the database are on the same server.

We have users accessing this application from another Geographical location .Those users are facing performance problems due to the link .
Question:
Can we add another server and install only the application on it and put this server in the other locaton ,and still having at the same time in our current location the application and the database on the same server ? is it possible to have two applications sharing the same database? if yes ,how to do this ? Please provide some resources ,notes ect....

Thank you

With about 99% of the applications out there, yes you can do this.

You simply install the application on the second server and when configuring it set the database connection to be the remote database server name and username and password.

Check with Oracle and make sure that the E-business suit supports being installed on an application server farm.

Do keep in mind that you will need to purchase a second license for the Application server on the remote server.