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

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

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

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Wed, 05 Apr 2006 08:43:03 -0500
Message-ID: <BAY107-F247990BC058EB3067181D597CB0@phx.gbl>


I did an Oracle Client install with the admin option from my desktop. I am connecting from my windows 2000 desktop to a sun server. I am running Oracle client 10g from my desktop to connect.

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Apr 5 08:16:43 2006 <= this banner is from my client correct?

Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL> connect system/user_at_10gdatabase
Connected.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options

SQL> select * from v$version;

BANNER



Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Solaris: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production

SQL> connect system/user_at_9idatabase
Connected.
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

thanks.

>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.



Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 05 2006 - 08:43:03 CDT

Original text of this message

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