- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- oracle 11i mid tier??
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2001 10:53 AM
тАО07-24-2001 10:53 AM
2 questions:
1) We have an N4000, 8 cpu, 8gb memory, 470gb disk. Running 2 50gb Oracle 8i instances (production mode) for up to 190 concurrent users.
What are your opinions regarding running Oracle 11i apps server? Would this N box be able to handle the apps server for these 2 instances for that amount of users
- or would seperate middle tier box be better?
2)If a middle tier is used, has anyone come across specific kernel tuning parameters for use with this application server tier. Theres lots of kernel recommendations for 8i databases out on the forums (which are great)but none i can find specific to an 11i mid tier apps server?
thanks all,
Mark
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2001 11:05 AM
тАО07-24-2001 11:05 AM
SolutionFor 2 instances that size your N-box work even break a sweat. In fact, a L-box would probably handle the load quite well. I am assuming you don't have zillions of very small, poorly indexed rows which make you these databases.
Since this is a production environment, you might consider a pair of L-boxs running MC/ServiceGuard. One could be the primary server for one instance and the other would be the primary server for the second instance.
Then in the first box failed, both instances would then be running on the second and the IP address associated with the first instance would also shift. The clients connected to Oracle would never be aware of which box(es) they are really running on. If high-availabilty is crucial, this would be my way to go.
As for tuning, other than setting shared memory, semaphores, and message queues to the Oracle installation suggestions, you need to
reduce dbc_max_pct to no more than 10% or so OR
kill that dynamic buffer cache stuff altogether
by setting bufpages to somewhere around 300MB (and that is generous).
My 2 cents, Clay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2001 11:13 AM
тАО07-24-2001 11:13 AM
Re: oracle 11i mid tier??
We are running Oracle 11i on an L2000-44 with 2 CPUs and 2 Gb of RAM. We also have the middle tier on that box, and it seems to be pushing it. Our DBAs say that with their testing the middle tier won't be able to live on the same box. But running on a nice N-class box should give you plenty of horsepower.
I haven't heard of any kernel tuning to do for the middle tier. You probably have all the bases covered with your tuning for the database side.
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2001 02:31 PM
тАО07-25-2001 02:31 PM
Re: oracle 11i mid tier??
john - just curious - can u tell me how many databases are on that L box and how big they are?
I didnt mention that we also have all our test and dev on an L2000 with 4 cpu and 4gb mem and wonderd what we could safely push on that for app server too.
thanks again - Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-26-2001 06:35 AM
тАО07-26-2001 06:35 AM
Re: oracle 11i mid tier??
We are running two databases. The main one is about 195 Gb and is the one they are testing with. The second one is about 2 Gb, and is just used for some miscellaneous stuff.
JP