Hi, Connor
I found
2 good solutions for connecting oracle db server via
SQLcl 18.1.1.
(1) I've created other two SHELL script files
".sqlcl1811" and
".sqlcl1811_out" on directory "/home/oracle/" on oracle user.
[oracle@test ~]$ cat .sqlcl1811
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export ORACLE_BASE=
export ORACLE_HOME=
export ORACLE_SID=
export SQLCL_HOME=/home/oracle/sqlcl
export CLASSPATH=$SQLCL_HOME/lib:$CLASSPATH
export PATH=$SQLCL_HOME/bin:$PATH
[oracle@test ~]$ cat .sqlcl1811_out
#!/bin/bash
. ~/.bash_profile;
export SQLCL_HOME=
export CLASSPATH=
[oracle@test ~]$ . .sqlcl1811
[oracle@test ~]$
[oracle@test ~]$ sql test/test@test
SQLcl: Release 18.1.1 Production on Thu Jun 07 14:45:15 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> show java
Java Detail
-----------
java.home= /usr/java/jdk1.8.0_172-amd64/jre
java.vendor= Oracle Corporation
java.vendor.url= http://java.oracle.com/
java.version= 1.8.0_172
-----------------------------------------------------------------------------------------------------------------------
os.arch= amd64
os.name= Linux
os.version= 2.6.32-504.el6.x86_64
path.separator= :
file.separator= /
line.separator=
user.dir= /home/oracle
user.home= /home/oracle
user.name= oracle
-----------------------------------------------------------------------------------------------------------------------
Classpath=
/home/oracle/sqlcl/lib/dbtools-sqlcl.jar:/home/oracle/sqlcl/../rdbms/jlib/xdb6.jar:/home/oracle/sqlcl/../jdbc/lib/ojdbc
8.jar:/home/oracle/sqlcl/../jlib/orai18n-utility.jar:/home/oracle/sqlcl/../jlib/orai18n-mapping.jar:/home/oracle/sqlcl/
../jlib/orai18n.jar:/home/oracle/sqlcl/../modules/oracle.xdk/xmlparserv2.jar:/home/oracle/sqlcl/lib/javax.json.jar:/hom
e/oracle/sqlcl/lib/xmlparserv2.jar:/home/oracle/sqlcl/lib/commons-logging.jar:/home/oracle/sqlcl/lib/orai18n.jar:/home/
oracle/sqlcl/lib/xmlparserv2-sans-jaxp-services.jar:/home/oracle/sqlcl/lib/orai18n-collation.jar:/home/oracle/sqlcl/lib
/jackson-databind.jar:/home/oracle/sqlcl/lib/xdb6.jar:/home/oracle/sqlcl/lib/jackson-core.jar:/home/oracle/sqlcl/lib/st
ringtemplate.jar:/home/oracle/sqlcl/lib/oraclepki.jar:/home/oracle/sqlcl/lib/jackson-annotations.jar:/home/oracle/sqlcl
/lib/osdt_core.jar:/home/oracle/sqlcl/lib/httpmime.jar:/home/oracle/sqlcl/lib/osdt_cert.jar:/home/oracle/sqlcl/lib/http
core.jar:/home/oracle/sqlcl/lib/orajsoda.jar:/home/oracle/sqlcl/lib/httpclient.jar:/home/oracle/sqlcl/lib/orai18n-utili
ty.jar:/home/oracle/sqlcl/lib/ojdbc8.jar:/home/oracle/sqlcl/lib/dbtools-sqlcl.jar:/home/oracle/sqlcl/lib/dbtools-net.ja
r:/home/oracle/sqlcl/lib/dbtools-http.jar:/home/oracle/sqlcl/lib/dbtools-common.jar:/home/oracle/sqlcl/lib/orai18n-serv
let.jar:/home/oracle/sqlcl/lib/jsch.jar:/home/oracle/sqlcl/lib/commons-codec.jar:/home/oracle/sqlcl/lib/jdbcrest.jar:/h
ome/oracle/sqlcl/lib/orai18n-mapping.jar:/home/oracle/sqlcl/lib/jline.jar:/home/oracle/sqlcl/lib/antlr-runtime.jar:/hom
e/oracle/sqlcl/lib:
-----------------------------------------------------------------------------------------------------------------------
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
[oracle@test ~]$
[oracle@test ~]$ . .sqlcl1811_out
######################################################################################
# #
# +-------+ +------- + +-------/ + +-------/ (R) #
# ( ) | ) / \ ( | ( #
# ( ) | ) / \ ( | ( #
# ( ) |------ / \ ( | (-------/ #
# ( ) | \ / ----- \ ( | ( #
# ( ) | \ | | ( | / ( #
# +-------+ - -- - - +-------/ +-------+ +-------/ #
# #
# #
# +----------------------------------+ #
# | Applications & Platform Services | #
# +----------------------------------+ #
# #
######################################################################################
(2) I've created another user
"sqlcl" on Linux system and added a series of
"export" command on
".bash_profile" (sqlcl's environment configuration file). Of course I've installed
SQLcl 18.1.1 on sqlcl user.
[oracle@test ~]$ su - sqlcl
Password:
[sqlcl@test ~]$ id sqlcl
uid=501(sqlcl) gid=503(sqlcl) groups=503(sqlcl)
[sqlcl@test ~]$
[sqlcl@test ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export SQLCL_HOME=/home/sqlcl/sqlcl
export CLASS_PATH=$SQLCL_HOME/lib:$CLASS_PATH
export PATH=$SQLCL_HOME/bin:$PATH
[sqlcl@test ~]$ sql test/test@test
SQLcl: Release 18.1.1 Production on Thu Jun 07 16:12:11 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> show java
Java Detail
-----------
java.home= /usr/java/jdk1.8.0_172-amd64/jre
java.vendor= Oracle Corporation
java.vendor.url= http://java.oracle.com/
java.version= 1.8.0_172
-----------------------------------------------------------------------------------------------------------------------
os.arch= amd64
os.name= Linux
os.version= 2.6.32-504.el6.x86_64
path.separator= :
file.separator= /
line.separator=
user.dir= /home/sqlcl
user.home= /home/sqlcl
user.name= sqlcl
-----------------------------------------------------------------------------------------------------------------------
Classpath=
/home/sqlcl/sqlcl/lib/dbtools-sqlcl.jar:/home/sqlcl/sqlcl/../rdbms/jlib/xdb6.jar:/home/sqlcl/sqlcl/../jdbc/lib/ojdbc8.j
ar:/home/sqlcl/sqlcl/../jlib/orai18n-utility.jar:/home/sqlcl/sqlcl/../jlib/orai18n-mapping.jar:/home/sqlcl/sqlcl/../jli
b/orai18n.jar:/home/sqlcl/sqlcl/../modules/oracle.xdk/xmlparserv2.jar:/home/sqlcl/sqlcl/lib/javax.json.jar:/home/sqlcl/
sqlcl/lib/xmlparserv2.jar:/home/sqlcl/sqlcl/lib/commons-logging.jar:/home/sqlcl/sqlcl/lib/orai18n.jar:/home/sqlcl/sqlcl
/lib/xmlparserv2-sans-jaxp-services.jar:/home/sqlcl/sqlcl/lib/orai18n-collation.jar:/home/sqlcl/sqlcl/lib/jackson-datab
ind.jar:/home/sqlcl/sqlcl/lib/xdb6.jar:/home/sqlcl/sqlcl/lib/jackson-core.jar:/home/sqlcl/sqlcl/lib/stringtemplate.jar:
/home/sqlcl/sqlcl/lib/oraclepki.jar:/home/sqlcl/sqlcl/lib/jackson-annotations.jar:/home/sqlcl/sqlcl/lib/osdt_core.jar:/
home/sqlcl/sqlcl/lib/httpmime.jar:/home/sqlcl/sqlcl/lib/osdt_cert.jar:/home/sqlcl/sqlcl/lib/httpcore.jar:/home/sqlcl/sq
lcl/lib/orajsoda.jar:/home/sqlcl/sqlcl/lib/httpclient.jar:/home/sqlcl/sqlcl/lib/orai18n-utility.jar:/home/sqlcl/sqlcl/l
ib/ojdbc8.jar:/home/sqlcl/sqlcl/lib/dbtools-sqlcl.jar:/home/sqlcl/sqlcl/lib/dbtools-net.jar:/home/sqlcl/sqlcl/lib/dbtoo
ls-http.jar:/home/sqlcl/sqlcl/lib/dbtools-common.jar:/home/sqlcl/sqlcl/lib/orai18n-servlet.jar:/home/sqlcl/sqlcl/lib/js
ch.jar:/home/sqlcl/sqlcl/lib/commons-codec.jar:/home/sqlcl/sqlcl/lib/jdbcrest.jar:/home/sqlcl/sqlcl/lib/orai18n-mapping
.jar:/home/sqlcl/sqlcl/lib/jline.jar:/home/sqlcl/sqlcl/lib/antlr-runtime.jar:
-----------------------------------------------------------------------------------------------------------------------
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
[sqlcl@test ~]$ exit
logout
[oracle@test ~]$
Best Regards
Quanwen Zhao