Should 9iAS and the customer database be on separate servers? Do you have any best practices?
Best practices are variable at times. Normally, you want the database on one server, the application server on another (and the Web cache on still another). However, it all depends of the capability of your server and the application you are using. We have clients with the customer database, the infrastructure instance and the middle tier instance on one server. It works fine because the server can handle the load. The difference between one server and two is strictly the server's ability to handle the load. There is no redundancy or high arability gained by only two servers.
If you believe that your system will grow in the future, then use two servers as this will allow you to easily add additional application server tiers for load balancing.
Related Q&A from John Garmany, Senior Oracle Trainer, Burleson Consulting
I am facing the ORA-04076 error. I googled the error but was unable to understand it. What exactly do I need to do to solve this? I am using Toad.continue reading
We are using Oracle Database. In our client site, we have 500 users using the database at one time. Sometimes the database objects become invalid ...continue reading
I get the ORA-12541 error message when I try to connect through Forms6i and Reports6i Builder. I've started the listener. I have no problems ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.