Home » SQL & PL/SQL » Client Tools » SQLPLUS not exist (oracle 10.2.0.1.0 - windows XP)
SQLPLUS not exist [message #494607] Wed, 16 February 2011 00:30 Go to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi All,

1) I mistakenly changed my 'oracle_home' some days ago, as below:
my computer --> environment variable ...

2) Then i realised that and edit the oracle home and saved as below:
C:\oracle\product\10.2.0\db_1

Question:
--------
But i am now not able to open sqlplus. it shows me the below error.

'sqlplus' is not recognized as internal or external command.

please help me out.

regards:
muktha
Re: SQLPLUS not exist [message #494611 is a reply to message #494607] Wed, 16 February 2011 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You know: copy and paste.

Regards
Michel
Re: SQLPLUS not exist [message #494630 is a reply to message #494611] Wed, 16 February 2011 02:23 Go to previous messageGo to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi Michel,

1) I guess, all the utilities (SQLPLUS, RMAN...) will find the default location.

2) As i had mentioned the ORACLE_HOME path - C:\oracle\product\10.2.0\db_1
Why it is not able to find it out.

3) As per your guidance, where do you want me to copy and past?

please help me on this.

Regards:
Muktha
Re: SQLPLUS not exist [message #494631 is a reply to message #494630] Wed, 16 February 2011 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
COPY AND PASTE:

set
sqlplus ...

Regards
Michel

[Updated on: Wed, 16 February 2011 02:35]

Report message to a moderator

Re: SQLPLUS not exist [message #494632 is a reply to message #494607] Wed, 16 February 2011 02:37 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
instead of explaining things

Quote:
COPY AND PASTE.

Regards
Michel


so everyone knows what you see
Re: SQLPLUS not exist [message #495168 is a reply to message #494632] Thu, 17 February 2011 15:13 Go to previous message
Quetzalcoatl1
Messages: 33
Registered: January 2011
Member
muktha_22,

You can also take a look at the following earlier post as it might help you (hope so):

http://www.orafaq.com/forum/t/165069/159625/
Previous Topic: PL*SQL - Which users are ACTIVE ?
Next Topic: repeat last series commands in SQL PLUS
Goto Forum:
  


Current Time: Tue Oct 16 01:47:57 CDT 2018