From: Uwe Teichmann (uwe.teichmann@oracle.com)
Date: Mon Sep 01 2003 - 09:29:09 CEST
From: Uwe Teichmann <uwe.teichmann@oracle.com> Date: Mon, 1 Sep 2003 09:29:09 +0200 Message-Id: <200309010929.09362.uwe.teichmann@oracle.com> Subject: Re: [suse-oracle] 8i and 9iR2 on same box?
Hi,
I run into a problem, when using the utl_file_dir
of 8i via sqlplus of 9i over a 9i listener connecting to
a 8i database. Problem: The Oracle8i server inherits
the NLS settings of the 9i listener, what causes
an error by the Oracle8i server when opening a NLS
file. Solution was to specify the ORA_NLS33 variable
inside the listener.ora specific for the version:
...
(SID_DESC =
(SID_NAME =CDRUAT)
(ORACLE_HOME = /opt/oracle/8.1.7)
(ENVS="ORA_NLS33=/opt/oracle/8.1.7/ocommon/nls/admin/data")
)
...
Ciao,
Uwe
On Monday 01 September 2003 00:10, Hollis, Les wrote:
> oops....guess i should include the cut/paste
>
>
>
> LIS_UAT =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = rydsup02)
> (Port = 1522)
> )
> )
> #STARTUP_WAIT_TIME_LISTENER = 0
> #CONNECT_TIMEOUT_LISTENER = 20
> SID_LIST_LIS_UAT =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME =CDRUAT)
> (ORACLE_HOME = /opt/oracle/8.1.7)
> )
> (SID_DESC =
> (SID_NAME =DP2UAT)
> (ORACLE_HOME = /opt/oracle/7.3.4)
> )
> (SID_DESC =
> (SID_NAME =DMUAT)
> (ORACLE_HOME = /opt/oracle/7.3.4)
> )
> (SID_DESC =
> (SID_NAME =IRUAT)
> (ORACLE_HOME = /opt/oracle/7.3.4)
> )
> (SID_DESC =
> (SID_NAME =LPSSUAT)
> (ORACLE_HOME = /opt/oracle/7.3.4)
> )
> (SID_DESC =
> (SID_NAME =MM2UAT)
> (ORACLE_HOME = /opt/oracle/8.1.7)
> )
> (SID_DESC =
> (SID_NAME =MPUAT)
> (ORACLE_HOME = /opt/oracle/7.3.4)
> )
> (SID_DESC =
> (SID_NAME =PYRUAT)
> (ORACLE_HOME = /opt/oracle/7.3.4)
> )
> (SID_DESC =
> (SID_NAME =ROUTUAT)
> (ORACLE_HOME = /opt/oracle/7.3.4)
> )
> (SID_DESC =
> (SID_NAME =TRAUAT)
> (ORACLE_HOME = /opt/oracle/9.2)
> )
> (SID_DESC =
> (SID_NAME =YMUAT)
> (ORACLE_HOME = /opt/oracle/7.3.4)
> )
> )
> LIS_TRN =
>
> -----Original Message-----
> From: Montefinese, Joseph [mailto:joseph.montefinese@bankofamerica.com]
> Sent: Saturday, August 30, 2003 10:45 PM
> To: suse-oracle@suse.com
> Subject: RE: [suse-oracle] 8i and 9iR2 on same box?
>
>
> Indeed. Barring any incompatibilities (or jamming the port), you only need
> one listener on a single port for all databases regardless of versions.
>
> -----Original Message-----
> From: john [mailto:jtkelly@adelphia.net]
> Sent: Saturday, August 30, 2003 1:20 PM
> To: dohse@werum.de
> Cc: suse-oracle@suse.com
> Subject: RE: [suse-oracle] 8i and 9iR2 on same box?
>
>
> Martin,
>
> Just to clear things up for me, you are saying that one default
> listener can handle more then on registered service name and route a
> connection to the appropiate database on one port?
>
> Thanks in advance,
> John
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
> For additional commands, e-mail: suse-oracle-help@suse.com
> Please see http://www.suse.com/oracle/ before posting
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
> For additional commands, e-mail: suse-oracle-help@suse.com
> Please see http://www.suse.com/oracle/ before posting
-- Uwe Teichmann "The mind sees what it needs to see, Oracle Premium Services the soul sees what the soul sees." +41 79 2906567 --------------------------------------------------------------------- To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com For additional commands, e-mail: suse-oracle-help@suse.com Please see http://www.suse.com/oracle/ before posting
This archive was generated by hypermail 2.1.7 : Mon Sep 01 2003 - 09:29:05 CEST