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
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
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.