You need a big server. With many CPU. And lots of RAM.
Which is about accurate a requirement specification that you can get, given the total lack of a comprehensive set of details ito workloads, architecture, data volumes, performance expectations, and so on.
But then seeing that you are planning to use a an old version of Oracle, and an old o/s version, why am I not surprised that there is the naive thought that the barest of details can result in accurate h/w specifications....
the same server will act as an application server as well.
BAD Idea. Really very bad. IO patterns on an application server are completely different from a database server.
Disk will be a bottleneck.
And server will be Single Point of Failure,
And why Win2003 and not Win2008?
Senior Oracle DBA
we want to prepare a server having windows server 2003 to install oracle database 10g. the same server will act as an application server as well.
we want to know how much size of the following we need if we have 1000 concurrently connected users;
In addition to the other questions, why Oracle 10g, which is already at end-of-support?
because our organization cannot afford 11g database.
it is very costly.
we take quotation from companies for 11g database and fusion middleware(forms and reports).
they said it will cost you round about 92000 us dollors.
so we plan to continue the 10g since it is fulflling our requirements.
we are a educaitonal organizaion, a college.
>because our organization cannot afford 11g database.
Huh ? If you have a perpetual licence and have been paying for annual support, an upgrade to 11g is free because the support fees include update support.
You'd have to buy 11g only if
a. You didn't buy 10g with a perpetual licence but only a limited duration (1year to 5years) licence -- in which case you can't use 10g beyond that duration anyway !
b. You haven't been paying annual support fees
(Some/many years ago the annual support fees would be split into two components, product support and update support. but I don't think that split applies anymore).
Check with your licence manager and your support contracts.
If you haven't been using fusion middleware (i.e. do not have the licence for it), you'd have to buy the licence for it. Then, you'd have to check if the version is certified and supported with 10g.
Note : 10g is no longer being delivered.
Hemant K Chitale