instead i want to open 11g sql. how to do that?
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:
else delete the oracle 10g path from environment variables and set the path for oracle 11g
C:\Windows\system32>set oracle_sid=orcl C:\Windows\system32>sqlplus SQL*Plus: Release 220.127.116.11.0 Production on Thu May 23 11:45:49 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name:
kindly guide me.
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;
Maahjoor wrote: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%.
i check the link but it was linux related.
instead i try to update my path variable like belowbut still not working.
if i am wrong , kindly correct me.