OraFAQ Forum: Windows » how to check where has been installed sql*plus in my system drive

Home » Infrastructure » Windows » how to check where has been installed sql*plus in my system drive

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to check where has been installed sql*plus in my system drive [message #618732]

Tue, 15 July 2014 02:32

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

I have been installed in our PC Oracle 10g sql*plus, but how to find where is sqllplus/nolog file in our pc drive.

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618738 is a reply to message #618732]

Tue, 15 July 2014 02:38

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In your Oracle home, BIN directory.

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618765 is a reply to message #618732]

Tue, 15 July 2014 05:41

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

aaditya321 wrote on Tue, 15 July 2014 13:02

how to find where is sqllplus/nolog file in our pc drive.

Always remember to mention the OS details for such questions.

In Windows 7, it is easy to locate the sqlplus.exe using following steps :

1. Go to START.
2. Type SQLPLUS /NOLOG in "Search Programs and files"
3.
/forum/fa/12025/0/

4. Right click on the icon, select "open file location".
5. It should open a new window directing you to the directory having the sqlplus.exe.

For me it is ORACLE\product\11.2.0\dbhome_1\BIN

Rehards,
Lalit

Attachment: sqlplus_loc.jpg
(Size: 23.11KB, Downloaded 3880 times)

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618769 is a reply to message #618765]

Tue, 15 July 2014 06:14

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Umm, I doubt that you'll find sqlplus /nolog anywhere on your disk. NOLOG is the argument to the SQLPLUS command which starts a command line session that doesn't connect to the database; it is not the command itself.

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618781 is a reply to message #618769]

Tue, 15 July 2014 08:39

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

In Windows its probably an icon which gets displayed in search result as SQLPLUS / NOLOG, however, it points to the sqlplus executable client in the BIN folder.
It is the same as searching for sqlplus.exe.

@OP, if you want to simply open sqlplus then you could just type it in Run.

Note : All the above mentioned steps are only applicable for Win OS. Of course, the client exe file would reside in BIN folder inside oracle home for any OS.

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618789 is a reply to message #618781]

Tue, 15 July 2014 10:47

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Lalit Kumar B

Note : All the above mentioned steps are only applicable for Win OS

That's probably why we discuss it in Windows forum.

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618791 is a reply to message #618789]

Tue, 15 July 2014 10:54

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Littlefoot wrote on Tue, 15 July 2014 21:17

Lalit Kumar B

Note : All the above mentioned steps are only applicable for Win OS

That's probably why we discuss it in Windows forum.

LF, sorry that I didn't realize that the topic is in Windows forum therefore implictly means OP's OS is Windows, hence I kept stressing about the OS, and that my suggested steps are only for Win 7 OS. My bad.

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618796 is a reply to message #618765]

Tue, 15 July 2014 12:37

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Lalit Kumar B wrote on Tue, 15 July 2014 05:41

aaditya321 wrote on Tue, 15 July 2014 13:02
how to find where is sqllplus/nolog file in our pc drive.

Always remember to mention the OS details for such questions.

In Windows 7, it is easy to locate the sqlplus.exe using following steps :

1. Go to START.
2. Type SQLPLUS /NOLOG in "Search Programs and files"
3.

4. Right click on the icon, select "open file location".
5. It should open a new window directing you to the directory having the sqlplus.exe.

For me it is ORACLE\product\11.2.0\dbhome_1\BIN

Rehards,
Lalit

Hi Laltit,

Whenever we search SQLPLUS then show path in our system as D:\Oracle\product\10.2.0\db_1\bin

But now I am facing some problems here when ever we use it command prompt then some issue is coming like

Code: [Select all] [Show/ hide]

D:\Oracle\product\10.2.0\db_1\bin>sqlplus/nolog
The system cannot find the path specified.




D:\Oracle\product\10.2.0\db_1\bin>sqlplus
'Oracle\product\10.2.0\db_1\bin' is not recognized as 
an internal or external command,
operable program or batch file

How to resolve it.

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618797 is a reply to message #618796]

Tue, 15 July 2014 12:43

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do you know how to execute a command in Windows?
You should first learn Windows before Oracle on Windows.
"D:\Oracle\product\10.2.0\db_1\bin>" is NOT a command it is the prompt you have when you are in this directory.

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618799 is a reply to message #618797]

Tue, 15 July 2014 13:23

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Hi Michel,

Please let me know how to use prompt here for "D:\Oracle\product\10.2.0\db_1\bin>"

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618801 is a reply to message #618799]

Tue, 15 July 2014 13:30

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

aaditya321 wrote on Tue, 15 July 2014 13:23

Hi Michel,

Please let me know how to use prompt here for "D:\Oracle\product\10.2.0\db_1\bin>"

We've been down this road before ..

http://www.orafaq.com/forum/mv/msg/191743/609072/#msg_609072

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618803 is a reply to message #618801]

Tue, 15 July 2014 13:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You can lead some folks to knowledge, but you can't make them think!

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618804 is a reply to message #618801]

Tue, 15 July 2014 13:42

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

EdStevens wrote on Tue, 15 July 2014 13:30

aaditya321 wrote on Tue, 15 July 2014 13:23
Hi Michel,

Please let me know how to use prompt here for "D:\Oracle\product\10.2.0\db_1\bin>"

We've been down this road before ..

http://www.orafaq.com/forum/mv/msg/191743/609072/#msg_609072

Hello EdStevens,

We could not get from your given refer links, while refer link had been discussed by me, where we asked there about how to create directory.

But we are not creating directory here just checking file in command prompt.

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618806 is a reply to message #618804]

Tue, 15 July 2014 13:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

dir /?

Report message to a moderator

Re: how to check where has been installed sql*plus in my system drive [message #618808 is a reply to message #618804]

Tue, 15 July 2014 14:26

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

aaditya321 wrote on Tue, 15 July 2014 13:42

Hello EdStevens,

We could not get from your given refer links, while refer link had been discussed by me, where we asked there about how to create directory.

But we are not creating directory here just checking file in command prompt.

No, I was referring to the more fundamental question of not knowing how to enter a command at a command prompt; of looking at an example that includes the command prompt as well as the actual command and thinking that the command prompt IS the command. In short, of not understanding the fundamentals of using a command prompt. Also exhibited in http://www.orafaq.com/forum/m/618667/#msg_618667

Report message to a moderator