carloscastillo/docker-sqlplus repository overview

⁠SQL*Plus Docker image

Forked from guywithnose/docker-sqlplus⁠ and inspired by thriqon/docker-sqlplus⁠.

This is a modified SQL*Plus docker image i've done in order to be enable to use my own tnsnames.ora⁠ and a dir where I could put some scripts.

Build it like this: docker build . -t carloscastillo/docker-sqlplus

Connect to a running Oracle database like this

docker run -it --rm -e USERNAME=username -e NET_SERVICE_NAME=XE -v /host/scripts/dir:/usr/workdir -v /host/oracle_home/network/admin:/usr/network/admin --net="host" carloscastillo/docker-sqlplus:spanish_spain

If the target database is inside another container you can link it: docker run -it --rm --link database_container_name:name_of_database_host_in_tnsnames_dot_ora -e USERNAME=username -e NET_SERVICE_NAME=XE -v /host/scripts/dir:/usr/workdir -v /host/oracle_home/network/admin:/usr/network/admin carloscastillo/docker-sqlplus:spanish_spain

Where:

• username is your user name.
• XE is the net service name for the target database in your tnsnames.ora.
• /host/scripts/dir is your local dir where you have the scripts that you need to be visibles by sqlplus.
• /host/oracle_home/network/admin is your local $ORACLE_HOME/network/admin or the dir where you have your tnsnames.ora.

In order to avoid the presence of password in your history commands i've intentionally omitted the password param so you will be prompted for it by sqlplus.

⁠Locale and language settings

This version has NLS_LANG setted to SPANISH_SPAIN.WE8MSWIN1252 and session timezone to Europe/Madrid.