6 Replies Latest reply: Jun 1, 2010 7:01 AM by Fahd.Mirza RSS

    Windows Server 2003 vs Windows XP

      is there an advantage of running an oracle server in a server OS compared to running it in a regular windows?

      for example:

      I want to install database11g.

      whats the advantage of running it in a windows server 2003 machine with intel xeon 3065 (dual core) and 2 GB RAM
      compared to
      windows xp 2003 machine with intel core 2 duo and 2 GB RAM?

      Edited by: mkdgroup on Jun 1, 2010 3:00 PM
        • 1. Re: Windows Server 2003 vs Windows XP
          For gaming and other purpose windows server 2003 is not supported so your CPU and RAM will be used more efficiently. But for small database which is less in size and transaction both the OS won't be a issue. You can use any one of them. For large database and higher transaction windows server 2003 is better.

          Asif Kabir
          • 3. Re: Windows Server 2003 vs Windows XP

            Asif Kabir
            • 4. Re: Windows Server 2003 vs Windows XP
              Actually Windows XP is desupported by Microsoft and Win2003 isn't.

              Sybrand Bakker
              Senior Oracle DBA
              • 5. Re: Windows Server 2003 vs Windows XP
                Charles Hooper
                You did not specify which of the Core 2 CPUs are in the Windows XP box.

                Xeon processor specifications:

                Core 2 Duo processor specifications (same speed as the Xeon):

                In addition to the information provided by Sybrand regarding support, there are a couple of important differences between the two operating systems:
                * Windows XP is limited to 10 simultaneous external connections. It is easy to reach that limit even when other computers are not attempting to remotely connect to the Windows XP computer. The System event log will display a message "TCP/IP has reached the security limit imposed on the number of concurrent TCP connect attempts." when the 10 connection limit is attempted to be exceeded. No such limit exists on Windows 2003.
                * Memory handling algorithms are different between the two operating systems. There are memory limits in the operating systems that are independent of the amount of physical memory installed. For example, what do you do if the following message appears in the System event log: "The server was unable to allocate a work item 2 times in the last 60 seconds." On Windows 2003, the problem can be fixed by creating a MaxWorkItems entry in the Windows registry.
                * The Home and Home Starter (I am not sure if that is the correct name) versions of Windows XP do not fully support Oracle Database, because those versions of the operating system do not permit user controlled/configurable local user groups, user permissions (logon as batch), nor file level permissions (file permissions/file ownership are there - they just cannot be modified through the user interface).
                * Yes, there are other differences, even though the two operating systems share the same kernel. The R2 version of Windows 2003 is preferred over the original release.

                Charles Hooper
                Co-author of "Expert Oracle Practices: Oracle Database Administration from the Oak Table"
                IT Manager/Oracle DBA
                K&M Machine-Fabricating, Inc.
                • 6. Re: Windows Server 2003 vs Windows XP
                  Very nice Charles, even Microsoft never described the difference so lucidly.

                  best regards