Home » Infrastructure » Windows » how to check where has been installed sql*plus in my system drive
how to check where has been installed sql*plus in my system drive [message #618732] Tue, 15 July 2014 02:32 Go to next message
aaditya321
Messages: 166
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59158
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In your Oracle home, BIN directory.

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 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2361
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.
./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
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 Go to previous messageGo to next message
Littlefoot
Messages: 19633
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.
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 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2361
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.
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 Go to previous messageGo to next message
Littlefoot
Messages: 19633
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.
icon10.gif  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 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2361
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.
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 Go to previous messageGo to next message
aaditya321
Messages: 166
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.
./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



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

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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59158
Registered: March 2007
Location: Nanterre, France, http://...
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.

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 Go to previous messageGo to next message
aaditya321
Messages: 166
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>"
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 Go to previous messageGo to next message
EdStevens
Messages: 282
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
You can lead some folks to knowledge, but you can't make them think!
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 Go to previous messageGo to next message
aaditya321
Messages: 166
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.
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 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
dir /?
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 Go to previous messageGo to next message
EdStevens
Messages: 282
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
Re: how to check where has been installed sql*plus in my system drive [message #618860 is a reply to message #618808] Wed, 16 July 2014 03:33 Go to previous messageGo to next message
javed.khan
Messages: 308
Registered: November 2006
Location: Banglore
Senior Member

Are we trying to find a directory [app or oracle ]here?
Re: how to check where has been installed sql*plus in my system drive [message #618862 is a reply to message #618860] Wed, 16 July 2014 03:48 Go to previous message
Michel Cadot
Messages: 59158
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No, the directory is found, the problem for him is to go into it! Razz

Previous Topic: My Command Prompt directory not changed
Next Topic: Time stamp of Start and Stop the Oracle Services
Goto Forum:
  


Current Time: Mon Sep 22 07:16:14 CDT 2014

Total time taken to generate the page: 0.08439 seconds