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@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!
-- //www.freelists.org/webpage/oracle-l