Thanks for the question, Santhosh.
Asked: April 20, 2018 - 6:51 pm UTC
Last updated: May 14, 2018 - 12:58 am UTC
Version: 11g and 12c
Viewed 1000+ times
You Asked
Hi,
I have two versions of Oracle Databses(12C,11G) installed on my personal computer running on Windows 8.
When i execute below command its connecting to 12C instance.
sqlplus system/welcome;
i would like to know how can i connect to 11G instance.
and Connor said...
By default I think it will pick whichever occurs your path, so if you path has 12c first, then it will find the 12c sqlplus, which will by default, bind to the 12c oracle installation.
Options:
1) Use to the explicit path
c:\oracle\abc\xyz\11.2\bin\sqlplus
2) Move that path to the front. For example, I have several versions on my laptop with batch files for each, eg
sql12.bat
=========
set PATH=c:\oracle\abc\xyz\12.2\bin;%PATH%
sqlplus blah/blah
3) Use the 12c sqlplus for all environments and use sqlnet, eg
sqlplus blah/blah@db11
where 'db11' is a tnsnames.ora entry that points to the 11g instance
Is this answer out of date? If it is, please let us know via a Comment