February 2, 2021 at 4:09 pm
I have a development box running SQL 2016 (soon to be 2019) and I am thinking of installing Oracle XE on the same box. I am not concerned about resources or space or anything like that; the box has plenty under the hood, and Oracle will have it's own 2TB drive. Was just wondering if anyone had experience with this and could let me know about any potential problems that might arise. Do the two play well together? Is there anything I need to watch out for when installing?
I've searched some other forums and I'm getting mixed messages; some are saying it's good, others are giving vague warnings.
February 2, 2021 at 6:49 pm
No issues from a compatibility point of view for having both running on same box - obviously resource sharing is where one may impact the other but if both are configured correctly it should not be an issue.
I have a few machines with both installed for a few years and no issues.
as you are installing XE just a bit of advise - if you do not need UTF data on your database change the database charset to be a single byte after installation
there is another command line for it but could not find it at the moment - but see these 2 links.
https://www.youtube.com/watch?v=xBIM6m6sb8k
and 2 TB for oracle XE is way too much - it will not use more than 12GB
https://www.oracle.com/database/technologies/appdev/xe.html
Up to 12 GB of user data
Up to 2 GB of database RAM
Up to 2 CPU threads
Up to 3 Pluggable Databases
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply