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 on RH6 besides Oracle Thick client

hrasconsOct 11 2017 — edited Oct 11 2017

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

Comments

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

HR@jdbc:oracle:oci8:@ADC122PB

or...

CONNECTION:

HR@jdbc: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.

1 - 1

Post Details

Added on Oct 11 2017
1 comment
108 views