Oracle doesn't have sqlplus client in the package managers of most linux systems. Easiest is to just build this dockerfile and use it.
Download Dockerfile and build it using
podman build -t sqlplus .
And then you can run it using
podman run -it --rm sqlplus sqlplus user@ip:port/service
| FROM ubuntu:22.04 | |
| RUN apt-get update && apt-get install -y libaio1 wget unzip | |
| WORKDIR /opt/oracle | |
| RUN wget https://download.oracle.com/otn_software/linux/instantclient/1927000/instantclient-basic-linux.x64-19.27.0.0.0dbru.zip && wget https://download.oracle.com/otn_software/linux/instantclient/1927000/instantclient-sqlplus-linux.x64-19.27.0.0.0dbru.zip | |
| RUN unzip instantclient-basic-linux.x64-19.27.0.0.0dbru.zip && unzip -o instantclient-sqlplus-linux.x64-19.27.0.0.0dbru.zip | |
| RUN sh -c "echo /opt/oracle/instantclient_19_27 > /etc/ld.so.conf.d/oracle-instantclient.conf" && ldconfig | |
| ENV LD_LIBRARY_PATH=/opt/oracle/instantclient_19_27:$LD_LIBRARY_PATH | |
| ENV PATH=/opt/oracle/instantclient_19_27:$PATH |