Select Page

Never Run Oracle on Windows

Author: Patrick Gates | | June 15, 2015

When should you run Oracle on Windows? Only if you absolutely have to because of skill set. Here’s why.

Ideally, you’ll want to run Oracle products on a supported operating system. If there are any issues, you can get the support as intended.

Although Oracle cites its interoperability with Microsoft, both on the desktop and in the cloud, saying “Oracle Database 12c makes developing and deploying Oracle on Windows and .NET easier, faster, and more cost-effective,” if you run a database on an operating system environment different from the one it was created to run on, it may not run optimally. Oracle was designed to run with UNIX while SQL was created for the Windows platform.

Oracle Can Still Run on Windows, But…

Opinions vary as to whether there’s really any noticeable performance differences based on the user’s operating system choice. Oracle 12c, for example, will run on several different UNIX operating systems as well as some Windows server environments. But, you may want to check the system requirements before plunging ahead.

Niall Litchfield, writing in Expert Oracle Practices: Oracle Database Administration from the Oak Table, by Pete Finnigan et al. offers:

For the most part…the choice of operating system makes absolutely no difference to the effective exploitation of the power of the Oracle database. It can, however, have a significant impact on the database administrator, who will often be interacting at the operating system level directly with the Oracle installation.

Some of the differences include how Oracle uses CPU resources, as well as memory and various scripts. Ironically, after noting these, Litchfield concludes that the implication for running a 32-bit Oracle application on 32-bit Windows is, “don’t do it.”

When you run scripts or execute tasks on Windows, you may need additional steps or scripts. You may also want to consider whether it’s worth the time and effort for you to support workarounds.

The differences associated with operating Oracle in Windows can be pronounced. So much so that Oracle explores many of the differences on its platform guide for 12c. Also, several Oracle products are not supported in Windows, including Java Server Pages. You will need to evaluate your environment and note these exceptions to determine whether or not it makes sense to run Oracle on Windows.

Inheriting an Oracle on Windows Situation

Granted, there may be situations in which you have no option, such as if you inherit another organization’s technologies through an acquisition or merger. For all you know, they could be running Oracle on Windows and SQL on UNIX. Develop a plan for evaluating that system rather than blindly merging resources. What operating systems and databases is it using? What storage or other hardware assets are involved? What licensing is involved and is it transferrable? This will also enable you to identify any redundant technologies and allows your team to become familiar with those data assets.

We have had customers who are facing the same issues when it comes to running Oracle on Windows. Datavail can work with you to support your environment. We’ve previously offered other ideas for working with Oracle, including a webinar with Chuck Ezell on the value of conducting Oracle Health Checks.

To learn more about our remote database services and how our experts can help with your ongoing Oracle operations, please contact Datavail to discuss a custom solution designed for your enterprise.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

Data Types: The Importance of Choosing the Correct Data Type

Most DBAs have struggled with the pros and cons of choosing one data type over another. This blog post discusses different situations.

Craig Mullins | October 11, 2017

How to Recover a Table from an Oracle 12c RMAN Backup

Our database experts explain how to recover and restore a table from an Oracle 12c RMAN Backup with this step-by-step blog. Read more.

Megan Elphingstone | February 2, 2017

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.