Re: [ilugd] Oracle 8i on 4 Xenon processors
On Fri, 2004-06-25 at 19:03, Yashpal Nagar wrote: Hi ILUGD, I have Proliant ML 570 Xenon 2.2 GHz, 4 CPU server. It has got 38 GBs 8 Nos SCSI hard disks. What we want this server to be Oracle 8i as the database server with Linux as the Operating system. I have some queries relating to this- Oracle is offcially supported on ES version of Redhat AFAIK. So recommended is that. Installing and running on debian/RHL 9/fedora has not been a problem Is feodra core 2 a worth to tried out as Database server or Redhat 9.0 or 8.0 is still better? Supreet ___ ilugd mailinglist -- [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/[EMAIL PROTECTED]/
Re: Re: [ilugd] Oracle 8i on 4 Xenon processors
Yashpal == Yashpal Nagar [EMAIL PROTECTED] writes: Yashpal Hi ILUGD, I have Proliant ML 570 Xenon 2.2 GHz, 4 CPU Yashpal server. It has got 38 GBs 8 Nos SCSI hard disks. What we Yashpal want this server to be Oracle 8i as the database server Yashpal with Linux as the Operating system. I have some queries Yashpal relating to this- Yashpal Is feodra core 2 a worth to tried out as Database server Yashpal or Redhat 9.0 or 8.0 is still better? *Always* go by the Oracle certification matrices of the respective Linux vendor. In case of RedHat, please refer - http://www.redhat.com/oracle_cert/ How about SuSe? Oracle prefers this distribution over others. You can refer - http://www.suse.de/en/business/certifications/certified_software/oracle/matrix.html Yashpal Our application needs a lot of Database I/Os , So Yashpal basically we are DB performance hungry what kind of RAID Yashpal system we should implement, RAID 5 ? Download the PDF document from the following URL document - http://www.quest-pipelines.com/ pipelines/dba/archives/Raid1.pdf After going through this document, I hope your performance 'hungry' DB won't be complaining for food for long time. BR, N ___ ilugd mailinglist -- [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/[EMAIL PROTECTED]/
Re: [LIH]Re: [ilugd] Oracle 8i on 4 Xenon processors
On Saturday 26 June 2004 00:45, Sanjeev Ghane Gupta wrote: I assume this is 8 x 36GB SCSI. LC? LW? Part number, please? My mistake, it is 36 GB x 8 SCSI U320 10K HP, Part no 286713-B22 I would suggest, if you have the cash, RHEL. This will work great for Oracle. Guaranteed. If your database is really important to your company, this is good value for the money. You get really great support. Ok, but which one? Redhat Enterprise Linux - AS (upto 16 CPUs 64 GB Main memory) OR Redhat Enterprise Linux ES (upto 2 CPU 8GB Main memory) I think we should get RHEL-AS ? recalling 4CPUs xenon 2.2 Ghz we have. Else, either Whitebox http://whiteboxlinux.org/ if you would like to stick to Red Hat, or Debian http://www.debian.org Any success stories?, package updates ... Everyone is performance hungry, for various value of performance. What do you really need? Performance in terms of speed, or reliability? Firstly, apart from RAID 0, any other RAID MUST (I mean MUST) be: implemented purely (yes, purely) in hardware have a large RAM cache (512M? at least 256M) have a battery backup, on the RAID card, at least 96 hours (think: long weekend) Anything else is at best useless, at worst snake oil. It is HP 6400 array controller with 192 MB cache. I have the smart start CDs But when i choose Linux as the OS(other options are windows 2000, windows 2003, Novel,OS/2, SCO etc) in ROM Based Setup Utility (RBSU) and then boots from smart start CD 7.0 it says :- OS selected is not supported for assisted installation using smart start... :( How do i configure array of hard disk for RAID?. I have hardware card for RAID system. let me check its no.. Give one try to install Redhat 8.0 FC2 WITHOUT setting up any RAID is fine! Next, if you can lay your databases/indices decently, the bulk of your work is done. A good DBA will out-perform a team of Sys Adms any day in database performance. How IO intensive is your app anyway? If really high, go to 15k drives, U320 (although U160 are not much worse). This is a quick win. Look for 8MB caches, on-drive. Buy good SCSI cables. The fastes way to improve HDD IO, in my view, is to stick in few G of RAM into the box. Amazing what caching will do. Split your drives into 3 groups: A RAID 5 set, or RAID 10, for your data A RAID 1 set, for the OS + App A normal disk, for swap + /tmp (who cares if you lose this?) This is attracting setup well, will give it one try... bonnie++ is your friend. http://www.coker.com.au/bonnie++/ And for RAID any higher than 1, you need a storage array. You cannot just pop-in disks into your cabinet and leave it at that, read up on spindle synchronization if you want to do RAID 3. The drives you have may not support this. Regards, Yash If you do realise you need faster drives, you know who to call :-) -- Sanjeev ghane Gupta --- This SF.Net email sponsored by Black Hat Briefings Training. Attend Black Hat Briefings Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com ___ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help ___ ilugd mailinglist -- [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/[EMAIL PROTECTED]/
Re: [LIH]Re: [ilugd] Oracle 8i on 4 Xenon processors
--- Yashpal Nagar [EMAIL PROTECTED] wrote: I have the smart start CDs But when i choose Linux as the OS(other options are windows 2000, windows 2003, Novel,OS/2, SCO etc) in ROM Based Setup Utility (RBSU) and then boots from smart start CD 7.0 it says :- OS selected is not supported for assisted installation using smart start... :( HP / Compaq do not support assisted install of Linux. They also do not have good support for drivers that you may need for some hardware. Dell has better support. How do i configure array of hard disk for RAID?. I have hardware card for RAID system. let me check its no.. Give one try to install Redhat 8.0 FC2 WITHOUT setting up any RAID is fine! Usually when BIOS messages appear for RAID controller, it tells you what keys to use to get into BIOS configuration of that RAID card. It could be ctrl-m for example. You do RAID configuration in raid card BIOS. Split your drives into 3 groups: A RAID 5 set, or RAID 10, for your data A RAID 1 set, for the OS + App A normal disk, for swap + /tmp (who cares if you lose this?) A separate RAID 1 for transaction logs ? Regards, Naresh = -- Naresh __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail ___ ilugd mailinglist -- [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/[EMAIL PROTECTED]/
Re: [ilugd] Oracle 8i on 4 Xenon processors
Yashpal == Yashpal Nagar [EMAIL PROTECTED] writes: Yashpal Hi ILUGD, I have Proliant ML 570 Xenon 2.2 GHz, 4 CPU Yashpal server. It has got 38 GBs 8 Nos SCSI hard disks. What we Yashpal want this server to be Oracle 8i as the database server Yashpal with Linux as the Operating system. I have some queries Yashpal relating to this- Yashpal Is feodra core 2 a worth to tried out as Database server Yashpal or Redhat 9.0 or 8.0 is still better? Use Debian on servers. It's arguably still the most stable and secure server distribution. Yashpal Our application needs a lot of Database I/Os , So Yashpal basically we are DB performance hungry what kind of RAID Yashpal system we should implement, RAID 5 ? Do NOT use software RAID at any level above 1 on a production server. Get a hardware RAID5 card, or use RAID1 with LVM or RAID1+0. Regards, -- Raju Yashpal Any pointers url etc is highly appreciated. -- Raj Mathur[EMAIL PROTECTED] http://kandalaya.org/ GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F It is the mind that moves ___ ilugd mailinglist -- [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/[EMAIL PROTECTED]/
Re: [ilugd] Oracle 8i on 4 Xenon processors
Yashpal Nagar wrote: Hi ILUGD, I have Proliant ML 570 Xenon 2.2 GHz, 4 CPU server. It has got 38 GBs 8 Nos SCSI hard disks. I assume this is 8 x 36GB SCSI. LC? LW? Part number, please? What we want this server to be Oracle 8i as the database server with Linux as the Operating system. I have some queries relating to this- Is feodra core 2 a worth to tried out as Database server or Redhat 9.0 or 8.0 is still better? I would suggest, if you have the cash, RHEL. This will work great for Oracle. Guaranteed. If your database is really important to your company, this is good value for the money. You get really great support. Else, either Whitebox http://whiteboxlinux.org/ if you would like to stick to Red Hat, or Debian http://www.debian.org Our application needs a lot of Database I/Os , So basically we are DB performance hungry what kind of RAID system we should implement, RAID 5 ? Everyone is performance hungry, for various value of performance. What do you really need? Performance in terms of speed, or reliability? Firstly, apart from RAID 0, any other RAID MUST (I mean MUST) be: implemented purely (yes, purely) in hardware have a large RAM cache (512M? at least 256M) have a battery backup, on the RAID card, at least 96 hours (think: long weekend) Anything else is at best useless, at worst snake oil. Next, if you can lay your databases/indices decently, the bulk of your work is done. A good DBA will out-perform a team of Sys Adms any day in database performance. How IO intensive is your app anyway? If really high, go to 15k drives, U320 (although U160 are not much worse). This is a quick win. Look for 8MB caches, on-drive. Buy good SCSI cables. The fastes way to improve HDD IO, in my view, is to stick in few G of RAM into the box. Amazing what caching will do. Split your drives into 3 groups: A RAID 5 set, or RAID 10, for your data A RAID 1 set, for the OS + App A normal disk, for swap + /tmp (who cares if you lose this?) bonnie++ is your friend. http://www.coker.com.au/bonnie++/ And for RAID any higher than 1, you need a storage array. You cannot just pop-in disks into your cabinet and leave it at that, read up on spindle synchronization if you want to do RAID 3. The drives you have may not support this. If you do realise you need faster drives, you know who to call :-) -- Sanjeev ghane Gupta ___ ilugd mailinglist -- [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/[EMAIL PROTECTED]/