SQLcl is not a drop-in-replacement for SqlPlus

user2976118

I was excited to learn that there is finally a better CL interface for the ORACLE database.

The video tutorial and docs said it supports all the command line options that SqlPlus does, so I downloaded SQLcl and tried myself:

Can not even login. Works fine with SqlPlus and SqlDeveloper but not with SQLcl. Tried the different syntaxes (EasyConnect, TNS) but no joy.

=> Confirmed my opinion that with ORACLE to get anything working is never easy.

=> Spent a few hours trying to simplify my work but now time is up: That's it for me, SQLcl deleted.

Erik van Roon

It's a shame that you have such negative experience with SQLcl.

Pesonally I have never ever had any issues connecting with any of the versions.

But that doesn't mean you can't have.

What I think is most unfortunate, however, is that your first 'cry for help' is "it doesn't work, I quit".

There are some awesomely knowledgeable people active on this forum.

A post that listed what you tried and showed the exact responses might have triggered someone to hint you towards a solution. No guarantees of course. But you are very unlikely to get any helpfull response if you try on your own until you've passed the point of no return, give up frustrated and even then only share your frustration without any information to work with.

Turloch O'Tierney-Oracle

Connection/startup issues

Getting started issues - make sure JDK/JRE is recent oracle (not open jdk) 1.8

UNIX

Try unsetting ORACLE_HOME - older Oracle (11?) causes issues conflict with shipped with the database oci/JDBC'thick' driver. - or try remote login from another machine with no ORACLE_HOME  (not sure how to hide 'baked into the registry' ORACLE_HOME in Windows)

Windows sql.exe

(Looks in one 1 default place for jdk/jre if that fails) tries in 'Program Files' for jdk jre (rather than PATH)

Strange terminals might confuser (cygwin etc).