Forum Stats

  • 3,750,551 Users
  • 2,250,192 Discussions
  • 7,867,005 Comments

Discussions

SQLcl on RH6 besides Oracle Thick client

hrascons
hrascons Member Posts: 7
edited Oct 11, 2017 3:22PM in SQLcl

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

Answers

  • Gary Graham-Oracle
    Gary Graham-Oracle Member Posts: 3,256 Bronze Crown
    edited Oct 11, 2017 3:22PM

    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.