Re: Required packages on a zLinux server running Oracle vs Put everything on
Wow ... many replies to what sounds like a simple question. You should look further ahead. Will this system ever run anything else? (ie: besides Oracle) Marcy's point about the security patching is spot on. Keeping up with actual threats is tough enough, and if your organization is big enough then there will be perceived threats too. It's a pain. You don't need to minimize as much as you need to manage. If you can keep up with maint, there is little need to remove stuff. How many servers? Have you considered a shared copy of the op sys? (can of worms; should be a forked topic) I ask because with my own systems I've been sharing some packages for almost two decades. (The sharing methods vary.) Means that I can theoretically install or update something (even a shared op sys core) just one time. Right now you have only asked about the one box. Think outside that box. On Dec 15, 2011 10:40 PM, CHAPLIN, JAMES (CTR) james.chap...@cbp.dhs.gov wrote: I got into a discussion with a co-worker over packages that are installed on a zLinux oracle server. We are Running RHEL 5.7 at our site, and are using Oracle 10g (about to go to 11g). I noticed that our Oracle servers have an average of 1192 rpm packages installed and 91 define system services compared to our other non-Oracle servers (application, java, MQ Websphere) having only 450 - 480 installed rpm packages and 53 defined services. I am not an oracle expert. Can anyone point me to a list of required software packages to be installed to support Oracle 10g? If you have any suggestions or personal experiences with oracle and the zLinux base platform, your comments are welcome. Another statement was It does not matter what we have installed, as long as Oracle is working, or don't touch unless it is broken. A sample of the over 600 packages are httpd (apache) and eklogin. Others like squid I believe is needed. I am just looking for a good baseline and argument to clean up these servers from unneeded software. James Chaplin Systems Programmer, MVS, zVM zLinux -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/ -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/
Re: Required packages on a zLinux server running Oracle vs Put everything on
There's a RedBook (http://www.redbooks.ibm.com/abstracts/sg247634.html) for installing Oracle on System Z. It contains all the needed packages, so you could install just those packages. Having a lot of superfluous packages can slow your server down, use more memory and disk than it should, and create room for vulnerabilities (for instance on that Apache installed by default and never configured properly). Mauro http://mauro.limeiratem.com - registered Linux User: 294521 Scripture is both history, and a love letter from God. On Fri, Dec 16, 2011 at 1:43 AM, Marcy Cortes marcy.d.cor...@wellsfargo.com wrote: The argument for not having them there is that you are subject to far less security patching. Now, some organizations don't seem to care about that. Some others care more than one can ever imagine. Marcy -Original Message- From: Linux on 390 Port [mailto:LINUX-390@vm.marist.edu] On Behalf Of CHAPLIN, JAMES (CTR) Sent: Thursday, December 15, 2011 3:20 PM To: LINUX-390@vm.marist.edu Subject: [LINUX-390] Required packages on a zLinux server running Oracle vs Put everything on I got into a discussion with a co-worker over packages that are installed on a zLinux oracle server. We are Running RHEL 5.7 at our site, and are using Oracle 10g (about to go to 11g). I noticed that our Oracle servers have an average of 1192 rpm packages installed and 91 define system services compared to our other non-Oracle servers (application, java, MQ Websphere) having only 450 - 480 installed rpm packages and 53 defined services. I am not an oracle expert. Can anyone point me to a list of required software packages to be installed to support Oracle 10g? If you have any suggestions or personal experiences with oracle and the zLinux base platform, your comments are welcome. Another statement was It does not matter what we have installed, as long as Oracle is working, or don't touch unless it is broken. A sample of the over 600 packages are httpd (apache) and eklogin. Others like squid I believe is needed. I am just looking for a good baseline and argument to clean up these servers from unneeded software. James Chaplin Systems Programmer, MVS, zVM zLinux -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/ -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/ -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/
Re: Required packages on a zLinux server running Oracle vs Put everything on
Oh, we can do better than that :-) On the assumption that you have a support contract, all you need is in this article: Note 1086769.1 -Ensure you have prerequisite rpms to install Oracle Database and AS10g(midtier) on IBM: Linux on System z (s390x) This provides an rpm which consists only of prereqs, thus ensuring you have the packages needed for the appropriate product. Run both sets, and you're good for E-Business Suite also. It won't necessarily tell you what you have that's unnecessary, though. Cheers Damian -Original Message- From: Mauro Souza [mailto:thoriu...@gmail.com] Sent: 16 December 2011 10:56 To: LINUX-390@vm.marist.edu Subject: Re: Required packages on a zLinux server running Oracle vs Put everything on There's a RedBook (http://www.redbooks.ibm.com/abstracts/sg247634.html) for installing Oracle on System Z. It contains all the needed packages, so you could install just those packages. Having a lot of superfluous packages can slow your server down, use more memory and disk than it should, and create room for vulnerabilities (for instance on that Apache installed by default and never configured properly). Mauro http://mauro.limeiratem.com - registered Linux User: 294521 Scripture is both history, and a love letter from God. On Fri, Dec 16, 2011 at 1:43 AM, Marcy Cortes marcy.d.cor...@wellsfargo.com wrote: The argument for not having them there is that you are subject to far less security patching. Now, some organizations don't seem to care about that. Some others care more than one can ever imagine. Marcy -Original Message- From: Linux on 390 Port [mailto:LINUX-390@vm.marist.edu] On Behalf Of CHAPLIN, JAMES (CTR) Sent: Thursday, December 15, 2011 3:20 PM To: LINUX-390@vm.marist.edu Subject: [LINUX-390] Required packages on a zLinux server running Oracle vs Put everything on I got into a discussion with a co-worker over packages that are installed on a zLinux oracle server. We are Running RHEL 5.7 at our site, and are using Oracle 10g (about to go to 11g). I noticed that our Oracle servers have an average of 1192 rpm packages installed and 91 define system services compared to our other non-Oracle servers (application, java, MQ Websphere) having only 450 - 480 installed rpm packages and 53 defined services. I am not an oracle expert. Can anyone point me to a list of required software packages to be installed to support Oracle 10g? If you have any suggestions or personal experiences with oracle and the zLinux base platform, your comments are welcome. Another statement was It does not matter what we have installed, as long as Oracle is working, or don't touch unless it is broken. A sample of the over 600 packages are httpd (apache) and eklogin. Others like squid I believe is needed. I am just looking for a good baseline and argument to clean up these servers from unneeded software. James Chaplin Systems Programmer, MVS, zVM zLinux -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/ -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/ -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/ -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/
Re: Required packages on a zLinux server running Oracle vs Put everything on
Thanks, that was what I was looking for. James Chaplin Systems Programmer, MVS, zVM zLinux -Original Message- From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU] On Behalf Of Damian Gallagher Sent: Friday, December 16, 2011 9:47 AM To: LINUX-390@VM.MARIST.EDU Subject: Re: Required packages on a zLinux server running Oracle vs Put everything on Oh, we can do better than that :-) On the assumption that you have a support contract, all you need is in this article: Note 1086769.1 -Ensure you have prerequisite rpms to install Oracle Database and AS10g(midtier) on IBM: Linux on System z (s390x) This provides an rpm which consists only of prereqs, thus ensuring you have the packages needed for the appropriate product. Run both sets, and you're good for E-Business Suite also. It won't necessarily tell you what you have that's unnecessary, though. Cheers Damian -Original Message- From: Mauro Souza [mailto:thoriu...@gmail.com] Sent: 16 December 2011 10:56 To: LINUX-390@vm.marist.edu Subject: Re: Required packages on a zLinux server running Oracle vs Put everything on There's a RedBook (http://www.redbooks.ibm.com/abstracts/sg247634.html) for installing Oracle on System Z. It contains all the needed packages, so you could install just those packages. Having a lot of superfluous packages can slow your server down, use more memory and disk than it should, and create room for vulnerabilities (for instance on that Apache installed by default and never configured properly). Mauro http://mauro.limeiratem.com - registered Linux User: 294521 Scripture is both history, and a love letter from God. On Fri, Dec 16, 2011 at 1:43 AM, Marcy Cortes marcy.d.cor...@wellsfargo.com wrote: The argument for not having them there is that you are subject to far less security patching. Now, some organizations don't seem to care about that. Some others care more than one can ever imagine. Marcy -Original Message- From: Linux on 390 Port [mailto:LINUX-390@vm.marist.edu] On Behalf Of CHAPLIN, JAMES (CTR) Sent: Thursday, December 15, 2011 3:20 PM To: LINUX-390@vm.marist.edu Subject: [LINUX-390] Required packages on a zLinux server running Oracle vs Put everything on I got into a discussion with a co-worker over packages that are installed on a zLinux oracle server. We are Running RHEL 5.7 at our site, and are using Oracle 10g (about to go to 11g). I noticed that our Oracle servers have an average of 1192 rpm packages installed and 91 define system services compared to our other non-Oracle servers (application, java, MQ Websphere) having only 450 - 480 installed rpm packages and 53 defined services. I am not an oracle expert. Can anyone point me to a list of required software packages to be installed to support Oracle 10g? If you have any suggestions or personal experiences with oracle and the zLinux base platform, your comments are welcome. Another statement was It does not matter what we have installed, as long as Oracle is working, or don't touch unless it is broken. A sample of the over 600 packages are httpd (apache) and eklogin. Others like squid I believe is needed. I am just looking for a good baseline and argument to clean up these servers from unneeded software. James Chaplin Systems Programmer, MVS, zVM zLinux -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/ -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/ -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/ -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org
Re: Required packages on a zLinux server running Oracle vs Put everything on
I don't know if that would help too. Our Oracle specialist ran a script from Oracle to determine requirements and demanded that the requirements would be met otherwise he couldn't install Oracle. This is an SLES11 with Oracle 11. So now we have a guest with 4G memory, 2G /tmp and a lot of packages installed, including a full X-windows. Installing Oracle we had proved through measuring the system that he needed only 200M /tmp space and less than 1G memory. X is never being used. So even the Oracle scripts and books do not reflect the actual minimal requirements but still consider a stand-alone server running X. BTW, the server is now installed according to Oracle recommendations, running at over 55MIPS it is now a top5 machine in CPU consumption and 100% in Q3. No, the machine is not in use yet so this is the IDLE load. Our SLES10 with Oracle 10 is a guest with a minimal installation, meaning the absolute minimum required to run a Linux guest and added a few packages such as sudo, sysstat etc. On top of that we've added: cpp, gcc ,gcc-c++ , glibc-devel ,libaio-devel ,libmudflap, libstdc++-devel, java-1_5_0-ibm-devel, expat-32bit, fontconfig-32bit ,freetype2-32bit, glibc-devel-32bit, openmotif, xorg-x11-libs-32bit, zlib-32bit. So this is the actual minimum requirement. Anything more is not required to install or run an Oracle. Also the guest runs 2 oracle databases within 1G. Idle load at about 6MIPS and almost never in Q3. Conclusion, don't trust the requirements from Oracle, they are wrong. On the other hand, if you want to install using X then you indeed need a lot more than this. Regards, Berry. -Original Message- From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU] On Behalf Of Damian Gallagher Sent: vrijdag 16 december 2011 15:47 To: LINUX-390@VM.MARIST.EDU Subject: Re: Required packages on a zLinux server running Oracle vs Put everything on Oh, we can do better than that :-) On the assumption that you have a support contract, all you need is in this article: Note 1086769.1 -Ensure you have prerequisite rpms to install Oracle Database and AS10g(midtier) on IBM: Linux on System z (s390x) This provides an rpm which consists only of prereqs, thus ensuring you have the packages needed for the appropriate product. Run both sets, and you're good for E-Business Suite also. It won't necessarily tell you what you have that's unnecessary, though. Cheers Damian -Original Message- From: Mauro Souza [mailto:thoriu...@gmail.com] Sent: 16 December 2011 10:56 To: LINUX-390@vm.marist.edu Subject: Re: Required packages on a zLinux server running Oracle vs Put everything on There's a RedBook (http://www.redbooks.ibm.com/abstracts/sg247634.html) for installing Oracle on System Z. It contains all the needed packages, so you could install just those packages. Having a lot of superfluous packages can slow your server down, use more memory and disk than it should, and create room for vulnerabilities (for instance on that Apache installed by default and never configured properly). Mauro http://mauro.limeiratem.com - registered Linux User: 294521 Scripture is both history, and a love letter from God. On Fri, Dec 16, 2011 at 1:43 AM, Marcy Cortes marcy.d.cor...@wellsfargo.com wrote: The argument for not having them there is that you are subject to far less security patching. Now, some organizations don't seem to care about that. Some others care more than one can ever imagine. Marcy -Original Message- From: Linux on 390 Port [mailto:LINUX-390@vm.marist.edu] On Behalf Of CHAPLIN, JAMES (CTR) Sent: Thursday, December 15, 2011 3:20 PM To: LINUX-390@vm.marist.edu Subject: [LINUX-390] Required packages on a zLinux server running Oracle vs Put everything on I got into a discussion with a co-worker over packages that are installed on a zLinux oracle server. We are Running RHEL 5.7 at our site, and are using Oracle 10g (about to go to 11g). I noticed that our Oracle servers have an average of 1192 rpm packages installed and 91 define system services compared to our other non-Oracle servers (application, java, MQ Websphere) having only 450 - 480 installed rpm packages and 53 defined services. I am not an oracle expert. Can anyone point me to a list of required software packages to be installed to support Oracle 10g? If you have any suggestions or personal experiences with oracle and the zLinux base platform, your comments are welcome. Another statement was It does not matter what we have installed, as long as Oracle is working, or don't touch unless it is broken. A sample of the over 600 packages are httpd (apache) and eklogin. Others like squid I believe is needed. I am just looking for a good baseline and argument to clean up these servers from unneeded software. James Chaplin Systems Programmer, MVS, zVM zLinux
Re: Required packages on a zLinux server running Oracle vs Put everything on
There is a difference between the installation requirements and the runtime, as is usual. Installation requires x , but runtime doesn't - and the docs state 4GB as that's the amount needed to get a full install. If you're a min install, you might get away with 2GB without swapping to hard, but there we go. Once you've done the install, of course X isn't needed, but that will be for patching perhaps :-) Once you're into runtime, then YYMV - it's your workload that generates the resource usage. Cheers Damian -Original Message- From: van Sleeuwen, Berry [mailto:berry.vansleeu...@atos.net] Sent: 16 December 2011 17:09 To: LINUX-390@vm.marist.edu Subject: Re: Required packages on a zLinux server running Oracle vs Put everything on I don't know if that would help too. Our Oracle specialist ran a script from Oracle to determine requirements and demanded that the requirements would be met otherwise he couldn't install Oracle. This is an SLES11 with Oracle 11. So now we have a guest with 4G memory, 2G /tmp and a lot of packages installed, including a full X-windows. Installing Oracle we had proved through measuring the system that he needed only 200M /tmp space and less than 1G memory. X is never being used. So even the Oracle scripts and books do not reflect the actual minimal requirements but still consider a stand-alone server running X. BTW, the server is now installed according to Oracle recommendations, running at over 55MIPS it is now a top5 machine in CPU consumption and 100% in Q3. No, the machine is not in use yet so this is the IDLE load. Our SLES10 with Oracle 10 is a guest with a minimal installation, meaning the absolute minimum required to run a Linux guest and added a few packages such as sudo, sysstat etc. On top of that we've added: cpp, gcc ,gcc-c++ , glibc-devel ,libaio-devel ,libmudflap, libstdc++-devel, java-1_5_0-ibm-devel, expat-32bit, fontconfig-32bit ,freetype2-32bit, glibc-devel-32bit, openmotif, xorg-x11-libs-32bit, zlib-32bit. So this is the actual minimum requirement. Anything more is not required to install or run an Oracle. Also the guest runs 2 oracle databases within 1G. Idle load at about 6MIPS and almost never in Q3. Conclusion, don't trust the requirements from Oracle, they are wrong. On the other hand, if you want to install using X then you indeed need a lot more than this. Regards, Berry. -Original Message- From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU] On Behalf Of Damian Gallagher Sent: vrijdag 16 december 2011 15:47 To: LINUX-390@VM.MARIST.EDU Subject: Re: Required packages on a zLinux server running Oracle vs Put everything on Oh, we can do better than that :-) On the assumption that you have a support contract, all you need is in this article: Note 1086769.1 -Ensure you have prerequisite rpms to install Oracle Database and AS10g(midtier) on IBM: Linux on System z (s390x) This provides an rpm which consists only of prereqs, thus ensuring you have the packages needed for the appropriate product. Run both sets, and you're good for E-Business Suite also. It won't necessarily tell you what you have that's unnecessary, though. Cheers Damian -Original Message- From: Mauro Souza [mailto:thoriu...@gmail.com] Sent: 16 December 2011 10:56 To: LINUX-390@vm.marist.edu Subject: Re: Required packages on a zLinux server running Oracle vs Put everything on There's a RedBook (http://www.redbooks.ibm.com/abstracts/sg247634.html) for installing Oracle on System Z. It contains all the needed packages, so you could install just those packages. Having a lot of superfluous packages can slow your server down, use more memory and disk than it should, and create room for vulnerabilities (for instance on that Apache installed by default and never configured properly). Mauro http://mauro.limeiratem.com - registered Linux User: 294521 Scripture is both history, and a love letter from God. On Fri, Dec 16, 2011 at 1:43 AM, Marcy Cortes marcy.d.cor...@wellsfargo.com wrote: The argument for not having them there is that you are subject to far less security patching. Now, some organizations don't seem to care about that. Some others care more than one can ever imagine. Marcy -Original Message- From: Linux on 390 Port [mailto:LINUX-390@vm.marist.edu] On Behalf Of CHAPLIN, JAMES (CTR) Sent: Thursday, December 15, 2011 3:20 PM To: LINUX-390@vm.marist.edu Subject: [LINUX-390] Required packages on a zLinux server running Oracle vs Put everything on I got into a discussion with a co-worker over packages that are installed on a zLinux oracle server. We are Running RHEL 5.7 at our site, and are using Oracle 10g (about to go to 11g). I noticed that our Oracle servers have an average of 1192 rpm packages installed and 91 define system services compared to our other non-Oracle servers (application, java, MQ Websphere) having only 450 - 480
Re: Required packages on a zLinux server running Oracle vs Put everything on
On Fri, Dec 16, 2011 at 9:47 PM, Damian Gallagher damian.gallag...@oracle.com wrote: There is a difference between the installation requirements and the runtime, as is usual. Installation requires x , but runtime doesn't - and the docs state 4GB as that's the amount needed to get a full install. If you're a min install, you might get away with 2GB without swapping to hard, but there we go. Once you've done the install, of course X isn't needed, but that will be for patching perhaps :-) Once you're into runtime, then YYMV - it's your workload that generates the resource usage. You're a brave man to stand straight like that with the guns pointed... ;-) I think one needs to be very determined to go and uninstall packages after installing Oracle (which AFAIK includes a check on whether you have the proper stuff installed). It's tedious with YAST to say the least, and your suggestion that I'd have to re-install stuff to apply maintenance does not really help. Doing the Oracle install with the GUI over a ssh -X connection to a remote system was far from pleasant. It seems to me that it would be helpful to be able to do the installation with an ncurses client and maybe even a response file. Alternatively, get the web server up early and drive the process through that. -Rob -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/
Re: Required packages on a zLinux server running Oracle vs Put everything on
Installing Oracle doesn't require X. The only reason Oracle guys want X is because they've learned how to do it on Windows and don't (want to) know the silent install method. Even more so, a silent install can be scripted, can be automated by the linux sysadmin, can make *their* install jobs obsolete. We've installed a SLES10/Oracle 10 in 1G, without X using a silent install. And we run 2 DB's in that same 1G even while oracle states that you realy need 1G or more for every DB instance. No swapping involved, or at least no runtime swapping. Linux does have some memory offloaded into swap but that's rarely touched in runtime. A second, more or less the same, Oracle guest has 1G for 1 DB, it's a full production system and it swaps even less. It all boils down to knowing what the requirements are, both for installing and runtime. Don't believe the (red)books or recommendations and scripting from suppliers. These just confirms that they've done it in this setup, not the minimum requirements. The only way is measuring or trail-and-error. Monitor your numbers, increase or decrease when needed. Like you state, the workload determines the requirements. The problem is: up is easy, down is a nightmare. The same is true for software install and remove. Both technical (how to remove software safely?) and for the more is better rule-of-thumb (it's not and we can prove it!). Regards, Berry. Op 16-12-11 21:47, Damian Gallagher schreef: There is a difference between the installation requirements and the runtime, as is usual. Installation requires x , but runtime doesn't - and the docs state 4GB as that's the amount needed to get a full install. If you're a min install, you might get away with 2GB without swapping to hard, but there we go. Once you've done the install, of course X isn't needed, but that will be for patching perhaps :-) Once you're into runtime, then YYMV - it's your workload that generates the resource usage. Cheers Damian -Original Message- From: van Sleeuwen, Berry [mailto:berry.vansleeu...@atos.net] Sent: 16 December 2011 17:09 To: LINUX-390@vm.marist.edu Subject: Re: Required packages on a zLinux server running Oracle vs Put everything on I don't know if that would help too. Our Oracle specialist ran a script from Oracle to determine requirements and demanded that the requirements would be met otherwise he couldn't install Oracle. This is an SLES11 with Oracle 11. So now we have a guest with 4G memory, 2G /tmp and a lot of packages installed, including a full X-windows. Installing Oracle we had proved through measuring the system that he needed only 200M /tmp space and less than 1G memory. X is never being used. So even the Oracle scripts and books do not reflect the actual minimal requirements but still consider a stand-alone server running X. BTW, the server is now installed according to Oracle recommendations, running at over 55MIPS it is now a top5 machine in CPU consumption and 100% in Q3. No, the machine is not in use yet so this is the IDLE load. Our SLES10 with Oracle 10 is a guest with a minimal installation, meaning the absolute minimum required to run a Linux guest and added a few packages such as sudo, sysstat etc. On top of that we've added: cpp, gcc ,gcc-c++ , glibc-devel ,libaio-devel ,libmudflap, libstdc++-devel, java-1_5_0-ibm-devel, expat-32bit, fontconfig-32bit ,freetype2-32bit, glibc-devel-32bit, openmotif, xorg-x11-libs-32bit, zlib-32bit. So this is the actual minimum requirement. Anything more is not required to install or run an Oracle. Also the guest runs 2 oracle databases within 1G. Idle load at about 6MIPS and almost never in Q3. Conclusion, don't trust the requirements from Oracle, they are wrong. On the other hand, if you want to install using X then you indeed need a lot more than this. Regards, Berry. -Original Message- From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU] On Behalf Of Damian Gallagher Sent: vrijdag 16 december 2011 15:47 To: LINUX-390@VM.MARIST.EDU Subject: Re: Required packages on a zLinux server running Oracle vs Put everything on Oh, we can do better than that :-) On the assumption that you have a support contract, all you need is in this article: Note 1086769.1 -Ensure you have prerequisite rpms to install Oracle Database and AS10g(midtier) on IBM: Linux on System z (s390x) This provides an rpm which consists only of prereqs, thus ensuring you have the packages needed for the appropriate product. Run both sets, and you're good for E-Business Suite also. It won't necessarily tell you what you have that's unnecessary, though. Cheers Damian -Original Message- From: Mauro Souza [mailto:thoriu...@gmail.com] Sent: 16 December 2011 10:56 To: LINUX-390@vm.marist.edu Subject: Re: Required packages on a zLinux server running Oracle vs Put everything on There's a RedBook (http://www.redbooks.ibm.com/abstracts/sg247634.html) for installing Oracle on System Z
Required packages on a zLinux server running Oracle vs Put everything on
I got into a discussion with a co-worker over packages that are installed on a zLinux oracle server. We are Running RHEL 5.7 at our site, and are using Oracle 10g (about to go to 11g). I noticed that our Oracle servers have an average of 1192 rpm packages installed and 91 define system services compared to our other non-Oracle servers (application, java, MQ Websphere) having only 450 - 480 installed rpm packages and 53 defined services. I am not an oracle expert. Can anyone point me to a list of required software packages to be installed to support Oracle 10g? If you have any suggestions or personal experiences with oracle and the zLinux base platform, your comments are welcome. Another statement was It does not matter what we have installed, as long as Oracle is working, or don't touch unless it is broken. A sample of the over 600 packages are httpd (apache) and eklogin. Others like squid I believe is needed. I am just looking for a good baseline and argument to clean up these servers from unneeded software. James Chaplin Systems Programmer, MVS, zVM zLinux -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/
Re: Required packages on a zLinux server running Oracle vs Put everything on
The argument for not having them there is that you are subject to far less security patching. Now, some organizations don't seem to care about that. Some others care more than one can ever imagine. Marcy -Original Message- From: Linux on 390 Port [mailto:LINUX-390@vm.marist.edu] On Behalf Of CHAPLIN, JAMES (CTR) Sent: Thursday, December 15, 2011 3:20 PM To: LINUX-390@vm.marist.edu Subject: [LINUX-390] Required packages on a zLinux server running Oracle vs Put everything on I got into a discussion with a co-worker over packages that are installed on a zLinux oracle server. We are Running RHEL 5.7 at our site, and are using Oracle 10g (about to go to 11g). I noticed that our Oracle servers have an average of 1192 rpm packages installed and 91 define system services compared to our other non-Oracle servers (application, java, MQ Websphere) having only 450 - 480 installed rpm packages and 53 defined services. I am not an oracle expert. Can anyone point me to a list of required software packages to be installed to support Oracle 10g? If you have any suggestions or personal experiences with oracle and the zLinux base platform, your comments are welcome. Another statement was It does not matter what we have installed, as long as Oracle is working, or don't touch unless it is broken. A sample of the over 600 packages are httpd (apache) and eklogin. Others like squid I believe is needed. I am just looking for a good baseline and argument to clean up these servers from unneeded software. James Chaplin Systems Programmer, MVS, zVM zLinux -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/ -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/