Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLcl.exe giving Java error Exception in thread "main" java.lang.UnsatisfiedLinkError: Could not loa

1002330Jan 30 2018 — edited Aug 17 2018

Hello Folks,

I am trying to connect sqlcl to our database but its giving me the error below -

Exception in thread "main" java.lang.UnsatisfiedLinkError: Could not load library. Reasons: [no jansi in java.library.path, Access is denied]

        at org.fusesource.hawtjni.runtime.Library.doLoad(Library.java:182)

        at org.fusesource.hawtjni.runtime.Library.load(Library.java:140)

        at org.fusesource.jansi.internal.CLibrary.<clinit>(CLibrary.java:37)

        at oracle.dbtools.raptor.console.clone.DbtoolsConsoleReader.<init>(DbtoolsConsoleReader.java:245)

        at oracle.dbtools.raptor.console.clone.DbtoolsConsoleReader.<init>(DbtoolsConsoleReader.java:238)

        at oracle.dbtools.raptor.console.SQLPlusConsoleReader.<init>(SQLPlusConsoleReader.java:35)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startConsole(SqlCli.java:235)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.<init>(SqlCli.java:216)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:427)

I have jre1.8.0_161 folder in the sqlcl folder. I have got the Java_Home link to sqlcl/jre1.8.0_161 and I in my path variable i have added %JAVA_HOME%\bin. I am lost at why its giving me this error. Any help is appreciated. Thank you!

Comments

Nik

Hi.

What  Solaris version you use ? ( 11 ; 11.3 11.4 ? )

Show result of command:   pkg info entire

What version STB you install and what is source ?

Standart path for explorer is :   /opt/SUNWexplo/bin/explorer

Check also this docs:

How to Install/Upgrade Explorer in Solaris 11.3 and 11.4 (Doc ID 2122392.1)

Oracle Services Tools Bundle (STB) - RDA/Explorer, SNEEP, ACT (Doc ID 1153444.1)

Regards,

Nik

Chris W Beal-Oracle

As Nik suggests, knowing which version of Solaris 11 you are using and where you're installing explorer from is key. From 11.3 it's installed by default with most default group packages. /usr/sbin/explorer is a link to /usr/lib/explorer/bin/explorer so either should work

Chris

1 - 2

Post Details

Added on Jan 30 2018
12 comments
2,797 views