Command not found- bash : sqlplus:

Question

I'm trying to use sqlplus in Oracle database docker container (for Windows 10).

Commands given:

"docker run -d -p 8080:8080 -p 1521:1521 --name OracleDB store/oracle/database/enterprise:12.2.0.1"
"docker start OracleDB"
"docker exec -it OracleDB bash"
"sqlplus / as sysdba"

And now I get the error message:

"bash: sqlplus: command not found"

[oracle@fdbf97e3a5fe /]$ ls ORCL boot etc lib media opt root sbin sys u01 u03 usr bin dev home lib64 mnt proc run srv tmp u02 u04 var [oracle@fdbf97e3a5fe /]$ - If this is what you asked? — Qendrim Krasniqi
– Qendrim Krasniqi, Commented Jan 28, 2019 at 11:01
this is not what I am asking... You need ORALE_HOME dir before proceeding to next step. I know what your problem is but I cannot help you without knowing your ORACLE_HOME directory — Derviş Kayımbaşıoğlu
– Derviş Kayımbaşıoğlu, Commented Jan 28, 2019 at 12:22

Derviş Kayımbaşıoğlu · Accepted Answer · 2019-01-28 13:12:10Z

8

Try with this:

"docker run -d -p 8080:8080 -p 1521:1521 --name OracleDB store/oracle/database/enterprise:12.2.0.1"
"docker start OracleDB"
"docker exec -it OracleDB bash"
"/u01/app/oracle/product/12.2.0/dbhome_1/bin/sqlplus / as sysdba"

answered Jan 28, 2019 at 13:12

Derviş Kayımbaşıoğlu

30.9k4 gold badges55 silver badges79 bronze badges

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

Comments

conceptdeluxe · Accepted Answer · 2020-09-16 11:29:33Z

3

While with @dervis answer it is possible to start SQL Plus, it introduced further issues on my side such as ORA-12547: TNS:lost contact or Connected to an idle instance.

What it solved for me is updating the PATH environment variable as shown below:

PATH=$ORACLE_HOME/bin:$PATH
export PATH

See: https://dba.stackexchange.com/questions/112702/bash-sqlplus-command-not-found

Afterwards I was able to start SQL Plus as usual with:

source /home/oracle/.bashrc; sqlplus /nolog

answered Sep 16, 2020 at 11:29

conceptdeluxe

3,9033 gold badges28 silver badges32 bronze badges

Comments

MxWild · Accepted Answer · 2020-12-21 08:15:15Z

0

Try connect to container:

docker exec -u oracle -it OracleDB bash

answered Dec 21, 2020 at 8:15

MxWild

3,8082 gold badges17 silver badges16 bronze badges

Comments

buddemat · Accepted Answer · 2022-09-16 13:01:09Z

0

Try

docker exec -it <container-name> bash -l -c "source /home/oracle/.bashrc; sqlplus /nolog"

edited Sep 16, 2022 at 13:01

buddemat

5,32816 gold badges37 silver badges61 bronze badges

answered Sep 12, 2022 at 13:41

Bhoomi

174 bronze badges

1 Comment

Florin C. Over a year ago

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review

helvete · Accepted Answer · 2023-10-25 15:39:09Z

0

docker exec -it <container-name> bash -l -c "source /home/oracle/.bashrc; sqlplus /nolog"

This is working for me

edited Oct 25, 2023 at 15:39

helvete

2,73915 gold badges38 silver badges42 bronze badges

answered Oct 21, 2023 at 12:21

ayoub elbahti

1

Collectives™ on Stack Overflow

Command not found- bash : sqlplus:

5 Answers 5

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related