How to use sqlplus on Oracle database inside a docker container?

Question

I installed oracle db version 12c in my docker environment. I used the following command:

docker run -d --name oracle -p 8080:8080 -p 1521:1521 quay.io/maksymbilenko/oracle-12c

I connected to the DB and everything went well but I wanted to enable unified audit. In order to do that, at first you must shutdown the Database and in all the instructions that I found it says to use sqlplus as following:

sqlplus / as sysoper
SQL> shutdown immediate
SQL> exit

I connected successfully to the DB using the next command:

docker exec -it oracle "bash"

and then I ran the sqlplus command and I received "command not found"

[root@f30cc670f85f /]#   sqlplus / as sysoper
bash: sqlplus: command not found

Am I doing it wrong? What should I do in order to have sqlplus on my oracle DB? I looked for it and didn't find anything that helped me.

I have mac if its relevant

jumping_monkey · Accepted Answer · 2023-05-07 07:26:12Z

6

I think that Docker image is just the database and enough of the OS to run the database. I don't think it includes client software such as SQL*Plus.

You need to have SQL*Plus installed on your Mac. If you haven't already, download the Oracle Instant Client for MacOS including the SQL*Plus extension. Or why not treat yourself and install the new-fangled sqlCL tool? It is easier to install and has all the SQL*Plus capabilities and a whole bunch more features. Find it here.

Whatever client you choose, once it's installed on your Mac you run it like any other app: when prompted for connection you give the string Maksym provides:

sqlplus user/password@ip:port/service-name
sqlplus system/oracle@//localhost:1521/xe

If you need to connect as sys that would look like this:

sqlplus sys/oracle@//localhost:1521/xe as sysdba

edited May 7, 2023 at 7:26

jumping_monkey

8,1152 gold badges60 silver badges75 bronze badges

answered Nov 14, 2019 at 14:08

APC

147k20 gold badges180 silver badges289 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tal Levi Over a year ago

ok, so I download sqlplus to my mac and I ran your command and it worked! I received the "SQL>" as I wanted. by any chance do you know how to continue from here and enable unified audit on my oracle db?

orellabac Over a year ago

As mentioned on the answers below. The docker images does contain the SQL plus. Just run source /home/oracle/.bashrc; and then you can run sql plus

Guillermo Solana · Accepted Answer · 2021-09-17 14:26:43Z

5

with this, you enter the image:

docker exec -it oracle /bin/bash

after that, you can use:

sqlplus sys as sysdba

answered Sep 17, 2021 at 14:26

Guillermo Solana

2473 silver badges4 bronze badges

1 Comment

Rafael Andrade Over a year ago

Also, if you use the CLI, you can navigate to the bin folder in root and run the command "exec bash"

JayDP123 · Accepted Answer · 2020-06-22 23:12:38Z

3

Sourcing the .bashrc should work to connect to sqlplus as sysdba. docker-compose exec db bash -c "source /home/oracle/.bashrc; sqlplus sys/Oradoc_db1@ORCLCDB as sysdba;"

answered Jun 22, 2020 at 23:12

JayDP123

717 bronze badges

Comments

szachMati · Accepted Answer · 2023-03-26 14:43:25Z

2

For Windows OS:

Type docker ps in command line to show running containers and check container id.

Type docker exec -it container_id //bin/bash

Login via sqlplus command

Or the simplest way

docker exec -it container_id bash -c "source /home/oracle/.bashrc; sqlplus sys/Oradoc_db1@ORCLCDB as sysdba;"

More info is here: https://docs.oracle.com/en/database/oracle/oracle-database/21/deeck/index.html#DEEDK-GUID-EDA557B2-B0D6-45E1-8FBD-C1D756803982

edited Mar 26, 2023 at 14:43

answered Feb 18, 2022 at 11:25

szachMati

2263 silver badges13 bronze badges

2 Comments

David Cobb Over a year ago

This link is no longer valid, possibly due to the Docker Hub corporatization. Is there a current version of this guidance?

szachMati Over a year ago

@DavidCobb I think you can find some info in official Oracle page docs.oracle.com/en/database/oracle/oracle-database/21/deeck/…

EdStevens · Accepted Answer · 2019-11-14 13:15:02Z

1

I don't have any experience with docker, but it looks for all the world like you are getting to a bash environment, so there we are on solid ground. The returned error ("bash: sqlplus: command not found") simply means that the executable (sqlplus) was not found in any directory listed in your PATH environment variable, as it exists within your shell environment. You actually need to set three variables: ORACLE_SID needs to be set to the value of your database name. ORACLE_HOME needs to be set to the value of the directory where your oracle binaries are installed. And PATH needs to have $ORACLE_HOME/bin added to it:

export PATH=$ORACLE_HOME/bin:$PATH

Obviously, since you are using the value of ORACLE_HOME in setting PATH, ORACLE_HOME needs to be set first.

answered Nov 14, 2019 at 13:15

EdStevens

3,9203 gold badges12 silver badges19 bronze badges

3 Comments

Tal Levi Over a year ago

How do I know where my oracle binaries are installed?

APC Over a year ago

@edstevens - I think for this question it is rather important to understand Docker. Docker is a platform for running containerised software, in this case an image of an installed Oracle database. The container has just enough OS to run Oracle; it's not a full-fledged environment. It's already configured to run Oracle and it's probably not a good idea to fiddle with the environment settings unless we understand both Oracle and Docker.

EdStevens Over a year ago

@APC - point taken. I did say going in that I had not experience with docker, but I should have added more caveats. I see from your provided answer that enviornment changes wouldn't have helped any way, as the docker image (?) doesn't have sqlplus at all. Thanks for the feedback. :-)

Filip Jonckers · Accepted Answer · 2021-02-11 16:59:31Z

1

When using the docker image store/oracle/database-enterprise:12.2.0.1-slim sqlplus and sqlldr tools are only available after the container has started. You can't do the following in a Dockerfile:

RUN sqlplus sys/password AS SYSDBA @create_database.sql

The container images can be configured to run scripts after setup and on startup. Currently sh and sql extensions are supported.

In your Dockerfile, copy the SQL script into the startup directory:

COPY create_database.sql  /opt/oracle/scripts/setup/01_create_database.sql

The database will be created on first startup of the container.

answered Feb 11, 2021 at 16:59

Filip Jonckers

111 bronze badge

Comments

Andromeda · Accepted Answer · 2023-03-27 09:19:52Z

0

You should connect with oracle account

su -oracle
sqlplus / as sysdba

edited Mar 27, 2023 at 9:19

Andromeda

1,4992 gold badges18 silver badges26 bronze badges

answered Mar 21, 2023 at 16:41

Mohsen Taheri

12 bronze badges

Collectives™ on Stack Overflow

How to use sqlplus on Oracle database inside a docker container?

7 Answers 7

2 Comments

1 Comment

Comments

2 Comments

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

2 Comments

1 Comment

Comments

2 Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related