That is strange. SQLcl can be installed anywhere where there is Java
1.8. Also, instant client works flawlessly on Ubuntu:
oci8
OCI8 Support enabled
OCI8 DTrace Support disabled
OCI8 Version 2.2.0
Oracle Run-time Client Library Version 19.3.0.0.0
Oracle Compile-time Instant Client Version 19.3
Directive Local Value Master Value
oci8.connection_class /no value/ /no value/
oci8.default_prefetch 100 100
oci8.events Off Off
oci8.max_persistent -1 -1
oci8.old_oci_close_semantics Off Off
oci8.persistent_timeout -1 -1
oci8.ping_interval 60 60
oci8.privileged_connect Off Off
oci8.statement_cache_size 20 20
Statistics
Active Persistent Connections 0
Active Connections 0
Environment
Variable Value
LD_LIBRARY_PATH /usr/lib/instantclient_19_3
APACHE_RUN_DIR /var/run/apache2
APACHE_PID_FILE /var/run/apache2/apache2.pid
JOURNAL_STREAM 9:30210
TNS_ADMIN /usr/local/tns
PATH
/usr/lib/instantclient_19_3:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
INVOCATION_ID 949db926ff3f4bdd95741810bf5ba87c
APACHE_LOCK_DIR /var/lock/apache2
LANG C
ORACLE_HOME /usr/lib/instantclient_19_3
APACHE_RUN_USER www-data
APACHE_RUN_GROUP www-data
APACHE_LOG_DIR /var/log/apache2
PWD /
mgogala@umajor:~$ perl -e 'use DBD::Oracle; print
"$DBD::Oracle::VERSION\n";'
1.76
Ubuntu is infamous for not supporting Oracle installations and yet I
didn't have to resort to docker, qubernettes or anything of that nature.
Please note that the library used is the latest and the greatest Oracle
19.3.
On 6/8/19 10:18 PM, Jared Still wrote:
Here is a couple examples of using Docker as a way to get versions of SqlPlus/Oracle client that I could not otherwise install--
https://blog.pythian.com/how-to-use-oracle-instant-client-docker-images/
https://blog.pythian.com/how-to-create-an-oracle-18c-client-image-in-docker/
These docker images are configured is such a way that they work just like sqlplus.
Well, it is sqlplus, but in docker.
I also use it to package and distribute an extension for orachk/exachk.
It could be done without docker, but it SO much easier with docker.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
Github: https://github.com/jkstill
On Tue, May 28, 2019 at 4:21 PM Jeff Chirco <backseatdba@xxxxxxxxx <mailto:backseatdba@xxxxxxxxx>> wrote:
Anybody using docker or some kind of application containerization
environment in their production systems. We don't have any but
just trying to understand it and how to use it. We are having
trouble figuring out how the database fits into all of this. Is
your database in a container? I don't see how you could with a 1tb
database. So is the application just under a container and they
all point to a traditional database?
Thanks,
Jeff
