Re: containers

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 10 Jun 2019 23:50:36 -0400
Message-ID: <235086fd-58ad-657b-df9d-d24cfa627f29_at_gmail.com>

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_at_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_at_gmail.com
> <mailto:backseatdba_at_gmail.com>> 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
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 11 2019 - 05:50:36 CEST