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

From: Paula Stankus <paulastankus_at_yahoo.com>
Date: Tue, 4 Apr 2006 14:13:13 -0700 (PDT)
Message-ID: <20060404211313.23958.qmail@web33208.mail.mud.yahoo.com>

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

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

Received on Tue Apr 04 2006 - 16:13:13 CDT