Getting started in Linux

partlycloudy

sqlcl looks very interesting so I went to the download page and unzipped the folder on a Linux server. This server currently has the Oracle 12.1 client installed, tnsnames.ora is used to locate databases, sqlplus works.

But I can't figure out how to get bin/sql to work

Help? Thanks

$echo $0-bash$type javajava is hashed (/app/oracle/client/product/12.2.0/client_1/jdk/bin/java)$java -versionjava version "1.8.0_91"Java(TM) SE Runtime Environment (build 1.8.0_91-b14)Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)./sql $./sqlException in thread "main" java.lang.UnsatisfiedLinkError: Could not load library. Reasons: [no jansi in java.library.path, /tmp/libjansi-64-2291100768859576172.so: /tmp/libjansi-64-2291100768859576172.so: failed to map segment from shared object: Operation not permitted]        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:42)        at org.fusesource.jansi.AnsiConsole.wrapOutputStream(AnsiConsole.java:48)        at org.fusesource.jansi.AnsiConsole.<clinit>(AnsiConsole.java:38)        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:435)

floo_bar

Maybe you could use a "workaround" to get version 18.1, from a previous version of SQL Developer, as explained in SQLcl FAQ :

Will SQLcl ship with Oracle Database?
  SQLcl is included with SQL Developer, and SQL Developer ships with all Oracle Database installs. So, yes.

floo_bar

Hello @partlycloudy,

Are you experiencing the same problem described in this thread : ?

The last message of this thread describes a possible solution, related to permissions on "/tmp". Maybe you are experiencing the same problem, judging by the error message you copied in your message.

Floo_bar

partlycloudy

Not exactly, that thread talks about a Access is denied error and I am getting /tmp/libjansi-64-2291100768859576172.so: failed to map segment from shared object: Operation not permitted] error

Oracle Support Note Doc ID 2407415.1 says

Product Packaging issue. Problem with jline.jar file:

Bug 28086841 - SQLCL COMMAND FAILS TO START WITH ERROR JANSI (NOT FOUND IN JAVA.LIBRARY.PATH)

marked to be fixed by 18.2, However due to deadline of release 18.2 it has been fixed in 18.3 and will be release by Oct-18

but I just downloaded sqlcl 18.3 and I am still encountering the error.

floo_bar

Hi,

Yes sorry, I missed this part of the error message.

However, Bug 28086841 does not appear in the "Bug fixes" list of 18.3 : https://www.oracle.com/technetwork/developer-tools/sqlcl/downloads/sqlcl-relnotes-183-5112172.html

partlycloudy

Good point. The Support note says a easy fix would be to simply copy lib/jline.jar from sqlcl 18.1 or earlier but I can't seem to find a download page for older versions, all attempts to Google it up lead to the download page for the latest version.

floo_bar

Maybe you could use a "workaround" to get version 18.1, from a previous version of SQL Developer, as explained in SQLcl FAQ :

Will SQLcl ship with Oracle Database?
  SQLcl is included with SQL Developer, and SQL Developer ships with all Oracle Database installs. So, yes.

partlycloudy

Ah, good catch, didn't realize that the SQL Developer download page includes sqlcl.  The recommended workaround solves this issue. Hopefully it will be fixed in the next release.

Thanks

floo_bar

Great