9 Replies Latest reply on Mar 1, 2012 2:26 AM by TheHades0210

    Oracle 11g R2 32bit installation on Oracle Linux Ent 5

    TheHades0210
      Aloha!

      I am scheduled to install ORACLE LINUX 5 on HP Proliant box with 8GB RAM and Intel Xeon resources.
      Is there any detail i need to consider before and after the installation of 11g R2 and OLE5 so that I can maximize the operation of the said machine.

      I had seem some document saying some config file. Can someone be kind to explain to me the following;

      *oracle-validate
      *sysctl.conf
      *" sysctl -p "
      *xhost +<machine-name>

      Thanks in advance.

      Hades
        • 1. Re: Oracle 11g R2 32bit installation on Oracle Linux Ent 5
          819493
          Hi,

          First of all, since your on a Intel Xeon, I'd suggest that you install 64-bit versions of the OS as well as the db. That will help performance.

          Secondly, to your questions:

          *sysctl.conf
          *" sysctl -p "

          These files control various system resource limits on the OS, meaning how much memory, how many threads etc each process can allocate. The limits specified in the readme/installation documentation shall be followed, and the limits are to be considered minimum requirements, not exact values. If you have a parameter that has a higher value, that doesn't break things.

          *xhost +<machine-name>

          This will, after being run on your local host, give the machine <machine-name> permission to connect to your local x-server, giving you the GUI of the oracle installation. This is not needed if you're on the console of the Oracle-server. It is generally not needed either if you use ssh X-forwarding (-X) when connecting to the server.

          HtH
          Johan
          • 2. Re: Oracle 11g R2 32bit installation on Oracle Linux Ent 5
            TheHades0210
            Aloha!

            If i have 8GB of RAM and INTEL Xeon quad.

            for the sysctl.conf. If this is in the document and i have this said resources, do i need to edit the details below.

            fs.suid_dumpable = 1
            fs.aio-max-nr = 1048576
            fs.file-max = 6815744
            kernel.shmall = 2097152
            kernel.shmmax = 536870912
            kernel.shmmni = 4096
            # semaphores: semmsl, semmns, semopm, semmni
            kernel.sem = 250 32000 100 128
            net.ipv4.ip_local_port_range = 9000 65500
            net.core.rmem_default=4194304
            net.core.rmem_max=4194304
            net.core.wmem_default=262144
            net.core.wmem_max=1048586

            oracle soft nproc 2047
            oracle hard nproc 16384
            oracle soft nofile 4096
            oracle hard nofile 65536
            oracle soft stack 10240

            Thanks,
            • 3. Re: Oracle 11g R2 32bit installation on Oracle Linux Ent 5
              819493
              Hi,

              For a 24GB RHEL5-box, with 5GB allocated to Oracle 10, I have:

              kernel.msgmnb = 65536
              kernel.msgmax = 65536
              kernel.shmmax = 4294967296
              kernel.shmall = 4294967296
              kernel.shmmni = 4096
              kernel.sem = 250 32000 100 128
              fs.aio-max-nr = 65536
              fs.file-max = 65536
              net.ipv4.ip_local_port_range = 1024 65000
              net.core.rmem_default = 262144
              net.core.rmem_max = 262144
              net.core.wmem_default = 262144
              net.core.wmem_max = 262144
              net.ipv4.tcp_wmem = 262144 262144 262144
              net.ipv4.tcp_rmem = 262144 262144 262144

              oracle soft nproc 2047
              oracle hard nproc 16384
              oracle soft nofile 1024
              oracle hard nofile 65536

              and this works just fine.

              The only thing I see in your config that I suspect Oracle is going to whine about, is the net.ipv4.ip_local_port_range, which Oracle wants to be set to 1024.

              Good luck with your install!

              //Johan
              • 4. Re: Oracle 11g R2 32bit installation on Oracle Linux Ent 5
                TheHades0210
                One last question... Do i need to pay if i use OLE 5?


                Thanks a lot!
                • 5. Re: Oracle 11g R2 32bit installation on Oracle Linux Ent 5
                  819493
                  TheHades0210 wrote:
                  One last question... Do i need to pay if i use OLE 5?
                  Not completely sure... but as I understand the licensing agreement on the eDelivery portal, OLE is licensed under GNU 2, but support isn't included...
                  I.e. you can use it, but if you need support, you'll have to pay...

                  Brgds
                  Johan
                  1 person found this helpful
                  • 6. Re: Oracle 11g R2 32bit installation on Oracle Linux Ent 5
                    TheHades0210
                    I'm installing right now. Thanks a lot man! Great help.
                    • 7. Re: Oracle 11g R2 32bit installation on Oracle Linux Ent 5
                      819493
                      You're welcome!

                      Please mark your question as answered to keep the forum nice and tidy...:-)

                      Brgds
                      Johan
                      • 8. Re: Oracle 11g R2 32bit installation on Oracle Linux Ent 5
                        Dude!
                        You could have made things much easier by simply installing the "oracle-validated" package, which will setup your system for the Oracle database installation, including the installation of prerequisite software, oracle account and kernel parameters.

                        The oracle-validated package is included on the OS installation DVD or online using the Oracle public yum software repository (http://public-yum.oracle.com)

                        For instance:
                        $ su - root
                        # cd /etc/yum.repos.d
                        # wget http://public-yum.oracle.com/public-yum-el5.repo
                        
                        - Then edit above file and set enabled=1 in the section
                          corresponding to your OS version, eg. ol5_u7_base
                        
                        # yum install oracle-validated
                        Then proceed with your installation of Oracle 11g.

                        There is also an article on OTN, which describes the oracle-validated package in more details
                        How I Simplified Oracle Database Installation on Oracle Linux:
                        http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html
                        • 9. Re: Oracle 11g R2 32bit installation on Oracle Linux Ent 5
                          TheHades0210
                          Hi Dude!

                          Thanks for such helpful information :)

                          Rgrds