SQLcl on RH6 besides Oracle Thick client

hrascons

I want to install SQLcl on RH6 - it is supported?

I already have installed Oracle Thick Client on RH6.

I want to install SQLcl besides the Thick client, so that I can remove the thick client with touching my SQLcl installation.

What I have to install? and which env variables I have to set?

thx in advance

Rainer

Gary Graham-Oracle

I have not tested specifically on Linux, but it should behave the same as on Windows.  Basically...

0.  You must have a Java 8 JRE (public, standalone) or JDK installed.

1.  If PATH environment variable points to an Oracle client, SQLcl should automatically connect with OCI/Thick driver

2.  If not, then SQLcl connects with Thin driver.

Once connected, you can verify the connection type by running...

show connection 

which will display something like...

CONNECTION [email protected]:oracle:oci8:@ADC122PB

or...

CONNECTION: [email protected]:oracle:thin:@(DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.mycompany.com)(PORT = 1521))    )    (CONNECT_DATA =   (SERVICE_NAME = orcl.mycompany.com)    )  )

If it does not work on Linux as I describe above, then you can try passing the -oci flag when invoking SQLcl.