Home » RDBMS Server » Server Administration » Planning and Creating an Oracle 11g Database
|
|
|
|
Re: Planning and Creating an Oracle 11g Database [message #614155 is a reply to message #614119] |
Sat, 17 May 2014 13:46   |
 |
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
looks like a bunch of "trick" questions.
What server has only 2gb total ram? This is the absolute minimum for Oracle 11.2 on a Windows platform. (You didn't specify the details on this supposed "server". Exactly what version of Windows, and if 32-bit or 64-bit?) Is it even possible to buy a server class machine with only 2-gb of ram? Is it even possible to buy a desktop class machine with only 2gb of ram? The cheapest consumer desktop I see on Dell's site is 4gb.
Windows will take 1gb of that 2gb.
Quote:"Our oracle database systemwide usable memory shall not exceed 25% of the server memory during its lifetime."
So with 2gb of RAM, you want to limit your total allocation to Oracle at 512 mb. That's for the SGA and PGA, supporting 6 concurent connections."
Quote:"The database should not accept more than 75 database files during its lifetime."
As memory serves me there is an init parameter to control the max files, but what kind of justifacation does such a requirement have?
Quote:"The database should be available 7/7 days, and 24/24 hours.
No data loss is allowed during the database lifetime."
Now you are talking a lot of Hight Availablity options - Data Guard and RAC. Both of which are going to require multiple servers, the addition of Grid Infrastructure .. According to the GI installation Guide for Windows, the minimum memory is 4-gb - and you are limited to a machine with only half of that, and you are only allowd to use half of *that*.
Plus if you have to guarantee 24/7, you have to throw out Windows and go to an OS that does not have to be re-started every week.
In short, your "requirements" simply cannot be met. So are these real requirements that a business is putting to you? Or is this some sort of test/exam/learning exercise?
|
|
|
|
Re: Planning and Creating an Oracle 11g Database [message #614524 is a reply to message #614511] |
Thu, 22 May 2014 15:33   |
 |
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
Mu889 wrote on Thu, 22 May 2014 12:57Yes, i said that i have an exam.
You said you had an "assignment". I have assignments all the time. I can't remember the last time I had an "exam" (except by my doctor)
Quote: I know that this requirements is a virtual one for a real Server.
Virtual requirements for a real server? I have no idea what that means.
Quote:but i need an answers for my questions, please>>
I provided several answers that should guide you to whatever the deliverable is for your assignment/exam. Bottom line is there is simply no way all of the "requirements" can be met.
- Your "server", with its stated memory, isn't even capable of functioning as a reasonable desktop/workstation. To consider it for use as even a minimal database server is a joke.
- The further limitation of how much memory you are allowed to actually use means it will not meet even the minimum specification for hosting a minimal oracle database.
- The limitation on the number of data files in the database, while in itself could probably be met, is totally pointless, indicating that the person making such a 'requirement' hasn't a clue. As if the other "requirements" didn't already reveal it.
- The requirement for 24/7 availability with zero data loss cannot be met by any single-server installation, and doubly-so when that server is running Windows, with its frequent requirement for re-start.
Given all of the above, why should one even begin to address questions about dedicated vs. shared server, spfile vs. init.ora, pool size and other init parms? It is akin to being given the task of hauling a 10-ton load with a Mo-ped, and asking about what kind of tires you should use.
|
|
|
|
|
Goto Forum:
Current Time: Sun May 04 13:57:18 CDT 2025
|