Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

wrong version of sqlplus is opening

MaahjoorMay 23 2013 — edited May 23 2013
Dear all,

i have installed oracle 11g R2 on windows 7 64 bit.
recently i un-installed oracle database 10g from my system.

now when i open the cmd, and type sqlplus, it is opening the 10g version of sql plus. like below
C:\Users\Administrator>sqlplus

SQL*Plus: Release 10.1.0.4.2 - Production on Thu May 23 10:07:29 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name:
instead i want to open 11g sql. how to do that?

Thanks
This post has been answered by John Stegeman on May 23 2013
Jump to Answer

Comments

Gaurav_91
use 
C:\Windows\system32>set oracle_sid=orcl

C:\Windows\system32>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 23 11:45:49 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name:
else delete the oracle 10g path from environment variables and set the path for oracle 11g

like: D:\......\oracle\product\11.2.0\dbhome_1\bin;
1 person found this helpful
Sunny kichloo
Try to set your PATH environment variables with correct value of sqlplus bin utility.

Refer this link.Error mentioned in below link is different But PATH setting is mentioned here

2512093
1 person found this helpful
Maahjoor
hi,
i do the same as you said,

but result is the same, no change.
my path variable is below 
C:\Program Files\Java\jdk1.7.0_15\bin;
C:\DevSuiteHome_1\jdk\jre\bin\classic;
C:\DevSuiteHome_1\jdk\jre\bin;
C:\DevSuiteHome_1\jdk\jre\bin\client;
C:\DevSuiteHome_1\jlib;
C:\DevSuiteHome_1\bin;
C:\DevSuiteHome_1\jre\1.4.2\bin\client;
C:\DevSuiteHome_1\jre\1.4.2\bin;
C:\app\Administrator\product\11.2.0\dbhome_1
;%SystemRoot%\system32;%SystemRoot%;
%SystemRoot%\System32\Wbem;
C:\Program Files (x86)\Intel\Services\IPT\;
%systemroot%\System32\WindowsPowerShell\v1.0\;
%systemroot%\System32\WindowsPowerShell\v1.0\;
C:\app\Administrator\product\11.2.0\dbhome_1\bin;
kindly guide me.
Maahjoor
hi,
thanks,

i check the link but it was linux related.
instead i try to update my path variable like below 
$ORACLE_HOME/bin;
but still not working.
if i am wrong , kindly correct me.

Regards
John Stegeman
Answer
I'd be willing to bet 2 cents that there is a sqlplus.exe in C:\DevSuiteHome_1\bin;
Marked as Answer by Maahjoor · Sep 27 2020
Maahjoor
well done john!!

great show, i am surprised why not i think that!!

i just remove that line C:\DevSuiteHome_1\bin; from path variable.
you did great john, i was really stucked since i was going to un-install and re-install APEX, and
for that i was compelled to got to the apx directory and run sqlplus from there.

you just make me happy.
thank you so much john.
EdStevens
Maahjoor wrote:
hi,
thanks,

i check the link but it was linux related.
instead i try to update my path variable like below 
$ORACLE_HOME/bin;
but still not working.
if i am wrong , kindly correct me.

Regards
I see you already have the solution, but as an aside, you need to realize that the "$variable_name" syntax is for unix. The shell processor take the "$" as a delimiter indicating that the string that follows is the name of an environment variable, and the processor is to substitute the value of that variable. In Windows (which is where you are) the equivalent syntax is %variable_name%.
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 20 2013
Added on May 23 2013
#general-database-discussions
7 comments
6,206 views