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: Jason Heinrich <jheinrich_at_pcci.edu>
Date: Wed, 05 Apr 2006 10:22:11 -0500
Message-ID: <C0594AD3.10B73%jheinrich@pcci.edu>


Based on the information you provided, everything looks exactly as I'd expect.

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

Correct. You shouldn't have any trouble using the 10g version of SQL*Plus with a 9i database; in fact, this is my normal setup.

On 4/5/06 8:43 AM, Joe Smith wrote:

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



Jason Heinrich
Oracle Database Administrator
Pensacola Christian College
(850) 478-8496 x2509
jheinrich_at_pcci.edu
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 05 2006 - 10:22:11 CDT

Original text of this message

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