I'm after advice on the best way to proceed, still new to some of this:
I'm looking into deploying a virtual machine solely for handling a copy of oracle database XE on it. Currently we are solely running a virtual windows 2012 R2 server with Microsoft Server SQL with all users running windows 10 pro connecting to it.
I've run into an issue where I'm most likely force to setup a lightweight oracle database. I'm trying to avoid expensive licensing and I'm after recommendations on what OS to use for the VM. I'm not too familiar with linux, but it might be the right avenue?
Users will be running a program that needs to connect to the oracle DB to query it and return results. This database will then be updated weekly having to download external data via oracle .dmp files (hence why I'm forced to use oracle).
Any recommendations, alternatives or pointers to head in the right direction are greatly appreciated, thanks.