for the next few weeks I am going to look at two topics. The first is installation and configuration of the different Oracle database products. The second is different ways of managing and keeping a server and database operational. The base platform that I am working from is a vmware image. The different operating systems that I will work with are Windows XP, Windows 2000, Windows 2003, Red Hat Enterprise Linux Release 4, and Oralce Unbreakable Linux Release 4 Update 4.
I am going to look at these different operating system platforms as well as four different database platforms (Oracle – all flavors, mySQL, SQL Server, and Postgress). The intent is to look at the basic functionality of the database, the footprint required, and a basis for benchmarking all of the functions and configurations needed for a database.
I am also going to look at the different management tools like Oracle Enterprise Manager, Nagios/NetSaint, CA Unicenter, BMC Patrol, and Quest. The purpose here is to look at the different management tools and how well it integrates into an ITIL environment, how well it functions, and how difficult it is to configure and construct.
To begin our tests, I have created a suite of VMWare images on a hard disk. These images are stock installations of the various operating systems. These systems use a file resident virtual disk and not an attached disk to perform the operations. All of the images run on an external Buffalo USB 1/2 TByte disk. I am doing all of the tests on a Dell Latitude D620 with 2G or RAM.
The configuration matrix for the operating systems looks like:
Windows XP – requirements: 300Mhz CPU, 128 M RAM.
consumed 1.24G disk with install
Windows 2000 – requirements: 200Mhz CPU, 64 M RAM.
consumed 2.1G disk with install
Windows 2003 – requirements: 200Mhz CPU, 256 M RAM.
consumed 2.19G disk with install
RHEL4 – requirements: 300Mhz CPU, 256 M RAM.
consumed 0.97G disk with install
UnbrLinux R4U4 – requirements: 300Mhz CPU, 256 M RAM.
consumed 1.2G disk with install
next entry…. memory and disk footprint for databases