CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
pawarchinmay27
pawarchinmay27

Reputation: 33

SQL Developer does not open in macOs?

I am facing an issue with SQL Developer whenever I start SQL Developer it simply keeps on loading and does not open enter image description here I tried running the sqldeveloper executable in the path SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin and I got this exception 

**Exception in thread "main" java.lang.OutOfMemoryError: Direct buffer memory
at java.nio.Bits.reserveMemory(Bits.java:694)
at java.nio.DirectByteBuffer.<init>(DirectByteBuffer.java:123)
at java.nio.ByteBuffer.allocateDirect(ByteBuffer.java:311)
at org.netbeans.Stamps.asByteBuffer(Stamps.java:218)
at org.netbeans.Stamps.asByteBuffer(Stamps.java:186)
at org.netbeans.Archive.<init>(Archive.java:120)
at org.netbeans.JarClassLoader.initializeCache(JarClassLoader.java:108)
at org.netbeans.MainImpl$BootClassLoader.run(MainImpl.java:343)
at org.netbeans.CLIHandler.initialize(CLIHandler.java:598)
at org.netbeans.CLIHandler.initialize(CLIHandler.java:384)
at org.netbeans.MainImpl.execute(MainImpl.java:193)
at org.netbeans.MainImpl.main(MainImpl.java:85)
at org.netbeans.Main.main(Main.java:83)
at oracle.ide.osgi.boot.OracleIdeLauncher.launchNbMain(OracleIdeLauncher.java:446)
at oracle.ide.osgi.boot.OracleIdeLauncher.main(OracleIdeLauncher.java:322)**

What is the issue here and can some one help me debug this.

Upvotes: 0

Views: 5376

Answers (3)

user1181858
user1181858

Reputation: 47

SetJavaHome to right java_home at .sqldeveloper/21.4.1/product.info

Upvotes: 0

Harsh
Harsh

Reputation: 21

Go to $HOME/.sqldeveloper keep backup [.sqldevelper keeps all ur queries and connection information] and delete this folder to free up SQL Developer Memory issue.

  1. After Cleanup Start SQLDeveloper
  2. To Retrieve all your connection Go to : ~/.sqldeveloper/system21.4.2.018.1706/o.jdeveloper.db.connection\connections.json
  3. Got to Oracle Connection Import Navigation
  4. Import all connection by passing connections.json file

Upvotes: 0

Harish
Harish

Reputation: 21

When you are working with a lot of worksheets and reports or try to open large SQL files, you may run into “Java Heap Space” errors.

To fix this problem you need to increase the Xmx (maximum heap size).

Here is how:

  • Close all open SQL-Developer instances.
  • Find the sqldeveloper.conf file

Windows:

goto the directory where the SQL-Developer program is installed.

goto the subdirectory sqldeveloper\bin

Mac OS X:

  1. goto your applications folder (/Applications)
  2. open the SQLDeveloper-App via context menu (right mouse click)
  3. goto the subdirectory Contents/Resources/sqldeveloper/sqldeveloper/bin
  4. Open the file sqldeveloper.conf with the text editor of your choice.
  5. Add a new line with the following text to the file: AddVMOption -Xmx1024M
  6. Save the file.

Upvotes: 2

Related Questions