Oracle 在 Windows 或 Linux 上工作得更好吗？根据你的经验给出你的答案

Oracle works better with Windows or Linux? give your answer based on your experience

提问by AXheladini

In most cases I am used to work with Windows, some weeks ago I started to work with Oracle, I have experience with other DBMS like SQL and MySql and I have worked with them in Windows.

在大多数情况下，我习惯使用 Windows，几周前我开始使用 Oracle，我有使用其他 DBMS（如 SQL 和 MySql）的经验，并且我在 Windows 中使用过它们。

Now I am learning Oracle and I don't know in which OS oracle works better. I have installed it in windows but not in Linux. I also downloaded the Oracle Enterprise Linux which is an Linux OS for Oracle (similar with RedHat).

现在我正在学习 Oracle，我不知道oracle 在哪个 OS 中效果更好。我已经在 Windows 中安装了它，但在 Linux 中没有安装。我还下载了 Oracle Enterprise Linux，它是适用于 Oracle 的 Linux 操作系统（类似于 RedHat）。

I want to know if Oracle Enterprise Linux is the only one Linux OS where Oracle can be installedor we can install Oracle even in RedHat, Ubuntu etc.

我想知道Oracle Enterprise Linux 是否是唯一一个可以安装 Oracle 的Linux 操作系统，或者我们甚至可以在 RedHat、Ubuntu 等中安装 Oracle。

Also if someone has experience with this issue please let us know in which OS Oracle works better. I am confused with this problem and an answer from a profesional DBA will be very helpful for me.

此外，如果有人对此问题有经验，请告诉我们 Oracle 在哪个操作系统中运行得更好。我对这个问题感到困惑，专业 DBA 的回答对我很有帮助。

---

---

So who can tell us which version of Oracle 11 is for linux, since i want to install Oracle on RedHat it will be good if some one let me know what is the Oracle version for Linux (redhat). Also it will be good if i have some link where it shows step by step Oracle installation on redhat. Thanks for your answer. You helped me to make the decision in which os to run Oracle.

那么谁能告诉我们哪个版本的 Oracle 11 适用于 linux，因为我想在 RedHat 上安装 Oracle，如果有人让我知道 Linux (redhat) 的 Oracle 版本是什么，那将会很好。如果我有一些链接显示在 redhat 上的 Oracle 安装步骤，那也很好。感谢您的回答。您帮助我决定在哪个操作系统上运行 Oracle。

采纳答案by Jonathan

Here you can download the Oracle 11 instalation files for linux. 32 and bits are available. RedHat is one of the easiest distros for installing oracle, but there are some differences between the different versions of RedHat (and the different versions of Fedora core too) so search for the right "step by step" document of you don't have any experience in the setup process.

在这里您可以下载适用于 linux 的 Oracle 11 安装文件。32位和位可用。RedHat 是安装 oracle 的最简单的发行版之一，但是不同版本的 RedHat（以及不同版本的 Fedora 核心）之间存在一些差异，因此搜索正确的“逐步”文档您没有任何安装过程中的经验。

http://www.oracle.com/technology/software/products/database/index.html

http://www.oracle.com/technology/software/products/database/index.html

Good Luck ;)

祝你好运 ;）

回答by Adam Paynter

At our company, we administer dozens of databases. They are split pretty much 50/50 between Windows servers and *nix (UNIX or Linux). Both of which are running significant applications (health and financial sectors). I suppose it's a matter of personal preference (and licensing fees!). You should be safe going with either. Note that Oracle Enterprise Linux is pretty much a re-packaged version of Red Hat. If you want to try a Red Hat derivative out for cheapfree, try CentOS. However, CentOS is not officially supported by Oracle.

在我们公司，我们管理着数十个数据库。它们在 Windows 服务器和 *nix（UNIX 或 Linux）之间的比例几乎为 50/50。两者都在运行重要的应用程序（卫生和金融部门）。我想这是个人喜好的问题（和许可费！）。你应该是安全的。请注意，Oracle Enterprise Linux 几乎是 Red Hat 的重新打包版本。如果您想尝试红帽衍生出廉价的自由，尝试的CentOS。但是，Oracle 并未正式支持 CentOS。

回答by Anthony

In my experience, the main issues with Oracle on Windows are a result of Windows file locking. For example, if the database was running and the data files for Oracle were locked by another process (i.e. a file system backup agent), we've had occurrences where the file has become corrupt.

根据我的经验，Windows 上的 Oracle 的主要问题是 Windows 文件锁定的结果。例如，如果数据库正在运行并且 Oracle 的数据文件被另一个进程（即文件系统备份代理）锁定，我们就会发生文件损坏的情况。

Unix/Linux on the other hand doesn't seem to have those issues (according to our DBA).

另一方面，Unix/Linux 似乎没有这些问题（根据我们的 DBA）。

In general, I've had no major issues with Oracle on a Windows Platform if steps are taken to ensure files are not locked by other processes. We now use RMAN to perform online backups and exclude all Oracle data files from the file system backup. It has been very stable for over 2 years now.

一般而言，如果采取措施确保文件不被其他进程锁定，我在 Windows 平台上使用 Oracle 时不会出现重大问题。我们现在使用 RMAN 执行在线备份并从文件系统备份中排除所有 Oracle 数据文件。它已经非常稳定了 2 年多。

回答by Catherine Devlin

I've used Oracle on both for several years. I prefer Linux because:

我已经在这两者上使用 Oracle 好几年了。我更喜欢 Linux 因为：

1. Oracle releases patches, new versions, and sometimes security updates for Linux significantly before they are available for Windows - there's usually about a two month lag for Windows.
2. Our Windows servers have crashed or locked up occasionally, and very frequently require reboots for patch installation. Oracle itself stays up very nicely, but Oracle can't keep running on a machine that is down. This hasn't been a problem for me on Linux.
3. Oracle's interaction with Vista's User Access Control is a nightmare. I'm constantly finding that the dedicated Oracle user account, which was used to install Oracle, nonetheless lacks permission to edit or even see Oracle-generated files - like newly generated logfiles. It could be that I'm making some mistake, but permissions shouldn't be confusing; and on Linux, they aren't. (Most servers don't run Vista, but I'm afraid of what this forebodes for future versions of Windows Server.)
4. Thanks to the Windows Registry, cleanly removing an installation of Oracle from Windows is tricky and tedious. The Oracle Installer has gotten better at this since version 10g, though.
5. Better tools. Linux findis infinitely better than any native Windows search tool. Also, Oracle uses and generates plenty of plain-text files, and Linux comes with better tools for handling text files - good text editors (unlike Notepad), shell commands like grep. You can try to catch Windows up by installing Geanie, Cygwin, Google Desktop, etc. on a Windows machine, but it's better not to have to (especially since Cygwin installation is not completely newbie-friendly).

1. Oracle 会在 Linux 的补丁、新版本和安全更新可用于 Windows 之前就发布显着的更新——Windows 通常会有大约两个月的延迟。
2. 我们的 Windows 服务器偶尔会崩溃或锁定，并且经常需要重新启动才能安装补丁。Oracle 本身可以很好地保持运行状态，但是 Oracle 无法在停机的机器上继续运行。在 Linux 上这对我来说不是问题。
3. Oracle 与 Vista 的用户访问控制的交互是一场噩梦。我不断发现用于安装 Oracle 的专用 Oracle 用户帐户仍然缺乏编辑甚至查看 Oracle 生成文件的权限 - 例如新生成的日志文件。可能是我犯了一些错误，但权限不应该令人困惑；而在 Linux 上，它们不是。（大多数服务器不运行 Vista，但我担心这对 Windows Server 的未来版本预示着什么。）
4. 多亏了 Windows 注册表，从 Windows 干净地删除 Oracle 的安装既棘手又乏味。不过，自 10g 版以来，Oracle 安装程序在这方面做得更好。
5. 更好的工具。Linux find比任何原生 Windows 搜索工具都要好得多。此外，Oracle 使用并生成大量纯文本文件，Linux 提供了更好的处理文本文件的工具——好的文本编辑器（不像记事本），像 grep 这样的 shell 命令。您可以尝试通过在 Windows 机器上安装 Geanie、Cygwin、Google Desktop 等来赶上 Windows，但最好不要这样做（尤其是因为 Cygwin 安装不是完全适合新手的）。

I can only think of one Windows advantage over Linux:

我只能想到一个 Windows 相对于 Linux 的优势：

1. In Oracle's command-line tools like sqlplus, rman, etc., you can scroll through and re-run past commands using the up- and down- arrow keys - but only on Windows. You can fix this on Linux by installing rlwrapand always invoking the Oracle tools under rlwrap: "rlwrap sqlplus me/mypassword@myinstance".

1. 在 Oracle 的命令行工具（如 sqlplus、rman 等）中，您可以使用向上和向下箭头键滚动浏览并重新运行过去的命令——但仅限于 Windows。您可以在 Linux 上通过安装rlwrap并始终调用 rlwrap 下的 Oracle 工具来解决此问题：“rlwrap sqlplus me/mypassword@myinstance”。

回答by Erich Kitzmueller

I've experienced Oracle installations on both Windows and Linux, all of them work as expected. Technically, you can install Oracle on almost every version of Linux, but if you want official support, you have to stick to Oracle's list of supported distros.

我在 Windows 和 Linux 上都安装过 Oracle，它们都按预期工作。从技术上讲，您几乎可以在每个版本的 Linux 上安装 Oracle，但是如果您想要官方支持，则必须坚持使用 Oracle 支持的发行版列表。

回答by Aaron

CSC researcher Steve Ries wrote a paper on this subject "Head To Head: A Comparison Between Windows and Linux as an Oracle Database Platform" back in 2008.

早在 2008 年，CS​​C 研究员 Steve Ries 就该主题撰写了一篇论文“头对头：Windows 和 Linux 作为 Oracle 数据库平台的比较”。

Essentially, he built two servers on identical hardware (Dell 6800's, 16 GB of RAM, four 3166 MHz processors with hyper threading), installed Windows Server 2003 and RHEL 3 (update 4). After installing Oracle 10g and importing identical data sets, he ran a series of experiments designed to test throughput and resource utilization.

本质上，他在相同的硬件（戴尔 6800、16 GB 内存、四个具有超线程的 3166 MHz 处理器）上构建了两台服务器，安装了 Windows Server 2003 和 RHEL 3（更新 4）。在安装 Oracle 10g 并导入相同的数据集后，他运行了一系列旨在测试吞吐量和资源利用率的实验。

His findings indicated that Oracle on Linux experienced:

他的发现表明 Linux 上的 Oracle 经历了：

• SQL transformation statements that ran 30% faster with 6% less CPU
• High I/O insert/selects that ran 160% faster
• Statements that utilize parallelism with almost linear scalability resulting in twice the performance
• Exports that ran 300% faster

• 运行速度提高 30% 且 CPU 减少 6% 的 SQL 转换语句
• 运行速度提高 160% 的高 I/O 插入/选择
• 利用具有几乎线性可扩展性的并行性的语句导致性能翻倍
• 运行速度提高 300% 的导出

Of course, that experiment was run 5 years ago with software that was already (at the time) 4 or 5 years old. So take that for what it's worth, but it at least gives you some indicators to watch for to ascertain how well 11g would perform on more-recent versions of each OS today.

当然，该实验是在 5 年前使用已经（当时）4 或 5 年历史的软件进行的。因此，就其价值而言，它至少为您提供了一些指标供您观察，以确定 11g 在当今每个操作系统的更新版本上的表现如何。

回答by cagcowboy

When I was working in Development + Support for Oracle (albeit over 7 years ago now), everything I was aware of ran on Solaris. I understand that they now run a Solaris/Linux mix.

当我在 Oracle 的开发 + 支持部门工作时（尽管现在已经超过 7 年了），我所知道的一切都在 Solaris 上运行。我知道他们现在运行的是 Solaris/Linux 组合。

I would expect that Oracle would chose the most suitable O/S to run their own systems to run on....

我希望 Oracle 会选择最合适的 O/S 来运行他们自己的系统来运行......

回答by yetanotherdave

will you also be the DBA? Or is it a case of developing an app that will hit Oracle and somebody else has to worry of administration duties?

你也会成为 DBA 吗？还是开发一个应用程序会影响 Oracle 而其他人不得不担心管理职责？

If it is the former, then you'd get up and running faster with Oracle on windows.

如果是前者，那么在 Windows 上使用 Oracle 可以更快地启动和运行。

If the latter, then go with Oracle on linux. You'll have to get used to the command line but once you do it will be much easier and more powerful to administer your db on linux. The day to day tasks in keeping it running smoothly, archiving data, importing data - all of it is made easier through the command line.

如果是后者，则在 linux 上使用 Oracle。您必须习惯命令行，但是一旦您习惯了，在 linux 上管理您的数据库将变得更加容易和强大。保持其平稳运行、存档数据、导入数据的日常任务 - 所有这些都通过命令行变得更容易。

We have over 100 servers to administer on my team, a mix of SQL, Sybase and Oracle on windows and unix variants. Oracle on linux gives us the least amount of problems by far.

我们的团队有 100 多台服务器需要管理，Windows 和 unix 变体上混合了 SQL、Sybase 和 Oracle。到目前为止，Linux 上的 Oracle 给我们带来的问题最少。

回答by Jonathan

I my last work, we migrate from windows to OpenSuse 11.

我的最后一份工作是从 Windows 迁移到 OpenSuse 11。

I spend a day in the instalation process (4 hours only to make appear the first screen of the oracle setup) but now the users confirm me that the time of all the querys are now better, so I recomend it.

我在安装过程中花了一天时间（4 小时只出现在 oracle 设置的第一个屏幕）但现在用户确认我所有查询的时间现在更好，所以我推荐它。

回答by cletus

You can install Oracle on any flavour of Linux. There's just a version that comes in RPM (RedHat Package Manager) for easy installation. For other variants, the installation is slightly more manual.

您可以在任何版本的 Linux 上安装 Oracle。RPM (RedHat Package Manager) 中只有一个版本，便于安装。对于其他变体，安装稍微手动一些。

The other thing I'll mention is that unless you need the full-blown Oracle, just stick with Oracle XE (Express Edition). You can actually use that one commercially within the limitations (eg I think it only uses one core and up to 4GB of data). But for Windows in particular it comes with an easy installation process and HTML based admin tools (somewhat similar to MySQLAdmin).

我要提到的另一件事是，除非您需要成熟的 Oracle，否则只需坚持使用 Oracle XE（快速版）。您实际上可以在限制范围内将其用于商业用途（例如，我认为它仅使用一个内核和最多 4GB 的数据）。但特别是对于 Windows，它带有一个简单的安装过程和基于 HTML 的管理工具（有点类似于 MySQLAdmin）。

For high end platforms, Linux/Unix tends to be preferred over Windows but that's probably not an issue for you. If you're just developing and aren't yet comfortable with Oracle, make it as easy on yourself as possible and stick with Windows and Oracle XE.

对于高端平台，Linux/Unix 往往比 Windows 更受欢迎，但这对您来说可能不是问题。如果您只是在进行开发并且对 Oracle 还不满意，请尽可能让自己轻松并坚持使用 Windows 和 Oracle XE。

My experience has been that we've only ever used Windows as a server platform because we've had to (eg to run SQL Server, Exchange or whatever), not because we've wanted to. This applies equally well to Oracle where every Oracle installation I've ever used has been on Solaris or a Linux variant (primarily Red Hat but also Ubuntu).

我的经验是，我们使用 Windows 作为服务器平台只是因为我们不得不这样做（例如运行 SQL Server、Exchange 或其他任何东西），而不是因为我们想要这样做。这同样适用于 Oracle，我使用过的每个 Oracle 安装都在 Solaris 或 Linux 变体（主要是 Red Hat，但也有 Ubuntu）上。

The cost of the operating system is only reason to do this.

操作系统的成本是这样做的唯一原因。