Where is Oracle sqlplus located?

Background

Coming from a mysql background, I find getting started with Oracle quite a different experience.

Question

Where do I find this command tool for Oracle?

I have checked wikipedia and it only says:

An Oracle programmer in the appropriately configured software environment can launch SQL*Plus

And it's not in the PATH on my Windows:

C:\Users\jeff>sqlplus
'sqlplus' is not recognized as an internal or external command,
operable program or batch file.

Upvotes: 10

Answers (4)

Murat Çelik

Reputation: 31

Problem: For example, Missing files in WINDOWS.X64_193000_db_home folder.

Solve: Reinstall oracle db. The exact solution.

enter image description here

Upvotes: 0

Thomas N

Reputation: 633

If you are running Oracle Server on your local computer you can also find it by right clicking the running Oracle process:

In my case it is in

C:\app\TZNind\virtual\product\12.2.0\dbhome_2\bin

Upvotes: 1

Joshua Huber

Reputation: 3533

You can locate the sqlplus executable in Windows by running in a CMD shell

dir /s /b c:\sqlplus.exe

Suppose you find the file at

c:\oracle\product\11.2.0\client_1\bin\sqlplus.exe

Then you have determined that your ORACLE_HOME is:

c:\oracle\product\11.2.0\client_1

Assuming the above ORACLE_HOME, set your environment variables (Control Panel > System > Environment Variables). Below is example, so modify these to match the ORACLE_HOME you determined above.

ORACLE_HOME=c:\oracle\product\11.2.0\client_1

TNS_ADMIN=c:\oracle\product\11.2.0\client_1\network\admin

PATH=  *(add this below the end of your PATH)*
         ;c:\oracle\product\11.2.0\client_1\bin

Upvotes: 16

Lajos Veres

Reputation: 13725

Usually in $ORACLE_HOME/bin and usually they suggest to run

. oraenv

to prepare your environment.

Upvotes: 1

Where is Oracle sqlplus located?

Answers (4)

Related Questions