ellie-lumen
ellie-lumen

Reputation: 197

Installing Oracle Database (Real Application Cluster) on Windows 10. Confused about Oracle Grid Infrastructure and X Windows requirements

I'm learning Oracle & SQL and I'm doing a project. I'd like it if someone could check the conclusion I've come to as a result of my research and tell me if I'm doing this right.

TL;DR question: i'm using Windows 10 and i want to build a (small) database on someone else's computer that I can access remotely. Do i need to install Linux in order to do this?

My goal: to set up a database on a computer that multiple people (like 3 max including me) can access. I would access it from a different computer that it's installed on.

My reading of the Oracle documentation has lead me to think that I need to do the following steps:

  1. DL Oracle using the Real Application Cluster installation rather than the single instance installation. This is because I want to be able to access the database remotely and possibly use it while another user is using it.

  2. To click that setting, I need to install the Oracle Grid Infrastructure. In order to do that I need to configure the user's environment (source: https://docs.oracle.com/cd/E18248_01/doc/install.112/e16763/pre_install.htm#BABIBGFA) and in order to do that i need X Windows. To use X Windows on my Windows 10 system i need to install X Server.

Am i understanding this right? Why can't Oracle run on Windows?

Upvotes: 0

Views: 293

Answers (1)

Littlefoot
Littlefoot

Reputation: 142743

Uh, I'm certainly not a DBA (perhaps you'd rather ask this question on SE for DBA), but - I think you overcomplicated it.

In my opinion, you don't need anything of what you mentioned. Not a single thing. No RAC / Grid Infrastructure / Linux / X Server. That's just a HUGE overkill.

Any Oracle database would do, even Express Edition (XE) which has the smallest footprint and would serve your needs. Documentation describes how to share your database with other people on the network, but - this short walkthrough will give you idea of what you should be paying attention to.

Upvotes: 2

Related Questions