Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> multiple Oracle Homes with one Listener 10g and 9i on solaris
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
Any help is appreciated!
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 04 2006 - 15:59:26 CDT