>You configure the listener to use the correct ORACLE_HOME on the >server-side (the database and network binaries), what version of the client >you are running is handled through your path. You need to ensure that you >are using oraenv and setting your ORACLE_HOME correctly before using the >client tools. When you "echo $ORACLE_HOME" each time what do you get?>> That would be the first place to start. :)>>Joe Smith <joe_dba_at_hotmail.com> wrote:> I have a solaris 8 server with 2 oracle homes. One is 9.2.0.6.0 and the>other 10.2.0.1.0.>When I go to my client (from my desk) and login with SQL*Plus I can't get >it>to use the "SQL*Plus Release 9i..." from the 9i instance.>>It wants to use the 10g version of sqlplus! How do I configure my>listener.ora to use the 9i sqlplus>with the 9i instance and the 10g sqlplus with the 10g instance?>>Below is the Listener.ora definition:>>[oracle_at_host] /apps/oracle/tns$ more listener.ora># listener.ora Network Configuration File: /apps/oracle/tns/listener.ora># Generated by Oracle configuration tools.>>LISTENER =>(DESCRIPTION_LIST =>(DESCRIPTION =>(ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = port))>(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))>)>)>>SID_LIST_LISTENER =>(SID_LIST =>(SID_DESC =>(SID_NAME = PLSExtProc)>(ORACLE_HOME = /apps/oracle/product/10.2.0)>(PROGRAM = extproc)>)>(SID_DESC =>(ORACLE_HOME=/apps/oracle9i/product/9.2.0)>(SID_NAME=orcl9i)>)>)>>>Here is an example of me logging in from my client with sqlplus:>>>SQL*Plus: Release 10.1.0.2.0 - Production on Tue Apr 4 15:48:57 2006>>Copyright (c) 1982, 2004, Oracle. All rights reserved.>>Connected to:>Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production>With the Partitioning, OLAP and Oracle Data Mining options>JServer Release 9.2.0.6.0 - Production>>SQL> select * from v$version;>>BANNER>---------------------------------------------------------------->Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production>PL/SQL Release 9.2.0.6.0 - Production>CORE 9.2.0.6.0 Production>TNS for Solaris: Version 9.2.0.6.0 - Production>NLSRTL Version 9.2.0.6.0 - Production>>>>Any help is appreciated!>>_________________________________________________________________>Donít just search. Find. Check out the new MSN Search!>http://search.msn.click-url.com/go/onm00200636ave/direct/01/>>-->http://www.freelists.org/webpage/oracle-l>>>>>>--------------------------------->Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates >starting at 1&cent;/min.