Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 234 Big Data Appliance
- 1.9K Data Science
- 449.7K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 157 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 386 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
How can I Make SQL Developer Data Modeler Work on MacOS Big Sur?

My Oracle Data Modeler worked fine on my MacOS company laptop. Then the latest MacOS 11.1 (code name Big Sur) was installed and now Data Modeler won't open. Will Oracle provide a fix for SQL Developer Data Modeler to work on the Big Sur OS? Is there any way I can retrieve all my models that were created before the OS update?
Answers
-
Did you check you still have the Java version installed that is expected by Data Modeler? It might be that a BigSur install removes Java. I cannot test unlucky enough, my MBP is just a few months too old to upgrade to BigSur.
-
No I did not check the previous Java. I'll do that now. Thank you.. However, I did download the newest Data Modeler along with its specified Java. When I attempt to launch it, BigSur returns a message stating "'Oracle Data Modeler' can't be opened because Apple cannot check it for malicious software.". That tells me that Data Modeler for MacOS has not yet been upgraded. I'm hoping there will be some way to save/retrieve my models in the future.
-
DataModeler runs as SQL developer on Java, so may have the same solutions. On the SQL Dev discussions several solutions have been mentioned, see e.g.: https://community.oracle.com/tech/developers/discussion/4477890/sql-developer-on-macos-big-sur#latest
-
I have the correct Java, have modified the conf files... got it running, created a very small 1 entity model and tried to save. Get an error saying the fold (/Users/[myname])... anythingunder that is not Accessible.
Datamodeler listed in "All folders" access. Perms onall dirs/folders have been opened up. My is owner etc. etc. (I'm a very experience UNIX etc . admin). Driving me crazy... also going nuts with the latest Windows version and the "Msvcr100.dll" file.
I have a fortune 150 client ready to look at this (and other Oracle products) for ETL/Data profiling, Meta data etc. I have until Monday (12/14) to get this working or they'll be spending on ErWin or ErStudio.
PS 27" iMac, latest Big Sur, 64 GB ram etc. etc
Windows is similar.. It shouldn't be this difficult
Thanks
-
For the problem with missing "Msvcr100.dll" file see this post:
https://community.oracle.com/tech/developers/discussion/comment/15659130#Comment_15659130
-
Ivan,
Thank you for the quick response 'll try it later this afternoon . On the Mac Ios, I will just have to save everything under 'public' until the product is compatible with Big Sur. I shudder to think of the issues looming with Apple's new chipset and compatibility. ;-)
-
Did you get Data Modeler working? I posted on the SQL Developer form but will re-post here for convenience:
I'm still unable to get Data Modeler to launch. I downloaded SQL Developer, in the hopes of figuring it out and sure enough, SQL Developer had the same issue, but with the article you linked to above (@thatJeffSmith-Oracle posted it - I've not been around long enough to post links; great summary and fixed SQL Developer just not Data Modeler), I was able to get it working by changing the SetJavaHome path in the product.conf file.
SetJavaHome /Library/Java/JavaVirtualMachines/jdk-11.0.10.jdk/Contents/Home
I didn't see a hidden directory for Data Modeler at first but after downloading SQL Developer, I saw:
/Users/<username>/.oraclesqldeverloperdatamodeler. In hopes the same fix would work, I changed the SetJavaHome in:
Users/<username>/.oraclesqldeveloperdatamodeler/19.5.0/product.conf
also to
SetJavaHome /Library/Java/JavaVirtualMachines/jdk-11.0.10.jdk/Contents/Home
But that did not work. When I try to run it, I can see it pop up briefly in Force Quit Applications but it immediately disappears.
If I try to run it from the command line, I get this:
➜ MacOS bash datamodeler.sh
/Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home
datamodeler.sh: line 9: cd: datamodeler.sh: Not a directory
In System Preferences / Security & Privacy in the bottom panel under "Allow app from", I have "App Store and identified developers" checked.
I have Java installed:
➜ MacOS java -version
java version "11.0.10" 2021-01-19 LTS
Java(TM) SE Runtime Environment 18.9 (build 11.0.10+8-LTS-162)
Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.10+8-LTS-162, mixed mode)
➜ MacOS /usr/libexec/java_home
/Library/Java/JavaVirtualMachines/jdk-11.0.10.jdk/Contents/Home
Thanks for any help on this!
-
I've been struggling for 2 days now - same bloody error javafx.base not found when I run datamodeler.sh from Applications/OracleDataModeler.app/Contents/Resources/datamodeler on Big SUR.
Discovered the following:
SqlDeveloper 20.4 creates `~/.sqldeveloper/20.4.0/product.conf and works with SetJavaHome set to JDK11 path.
Data Modeler acts differently.
Data Modeler Version 20.4.0.374 build 374.0801 creates ~/.oraclesqldeveloperdatamodeler/19.5.0/product.conf even for version 20.4 at this time.
Could not get JDK 11 to work, dumps java.lang.module.FindException: Module javafx.base not found
Changed SetJavaHome to JDK 8.
SetJavaHome /Library/Java/JavaVirtualMachines/jdk1.8.0_45.jdk/Contents/Home
Voila !!!!
-
user5876769 you are my new favorite person! Changing the JDK from 11 to 8 did the trick. I can even run it normally now by clicking on the icon :)
Thank you!!! Thank you!!! Thank you!!!
To summarize my issue: Oracle data modeler would not open (or open and immediately close; you could see the process immediately quit). I was able to get SQL Developer to work by changing the JDK in the Product.conf file. I changed that same line in the Oracle Data Modeler product.conf file to JDK 11 but it had no effect. But changing to JDK 8 did work.
If you have this problem on Mac OS Big Sur, try this:
Find the JDKs you have installed (download JDK 8 if you don't have it) by listing them here:
/Library/Java/JavaVirtualMachines/
➜ JavaVirtualMachines ls -l
total 0
drwxr-xr-x 3 root wheel 96 Jan 29 07:18 jdk-11.0.10.jdk
drwxr-xr-x 3 root wheel 96 Aug 10 2020 jdk-11.0.8.jdk
drwxr-xr-x 3 root wheel 96 Aug 11 2020 jdk1.8.0_261.jdk
➜ JavaVirtualMachines
Since I have JDK1.8.0_261.jdk installed, I used that in the product.conf file here:
/Users/<username>/.oraclesqldeveloperdatamodeler/19.5.0/product.conf
and uncommented and modified line 20 so it became this:
SetJavaHome /Library/Java/JavaVirtualMachines/jdk1.8.0_261.jdk/Contents/Home
Thanks again user5876769!!
-
Thanks. This worked for me :)
It wasn't working with the jdk-11.0.9.jdk that I use for SQL Developer - so I had to download and install jdk1.8.0_281.jdk.
I changed the product.conf and then it worked.
(Mac Mini M1 with Big Sur)