Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> multiple Oracle Homes with one Listener 10g and 9i on solaris

multiple Oracle Homes with one Listener 10g and 9i on solaris

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Tue, 04 Apr 2006 15:59:26 -0500
Message-ID: <BAY107-F26C6DDD3D62519A11EDB6897CA0@phx.gbl>


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
Received on Tue Apr 04 2006 - 15:59:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US