Re: 9i listener for 8i DB not recommended???
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 18 Mar 2004 16:53:50 -0800
No, I never set ORACLE_BASE or ORACLE_HOME on Windows.
In fact, I have to delete it when I catch someone else doing it.
Jared
Paul Drake <discgolfdba@xxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
03/18/2004 01:53 PM
Please respond to oracle-l
To: oracle-l@xxxxxxxxxxxxx
cc:
Subject: Re: 9i listener for 8i DB not recommended???
please forgive me for top-posting, but that seems to
be the norm on this thread.
When Oracle issued a security alert for the TNS
Listener that was fixed at the time in 9.2, but not
fixed in 8.1.7.4.x, we established a best practice of
installing a 9.2 home and using its listener.
I have seen no issues with this practice.
We had been using the 9.2 client on desktops anyways,
as the 9.2 OUI handled P IV issues and was certified
for Win XP.
As far as note 77442.1
I can confirm that a sqlnet 2.3.2 client does not work
well against UTF8 database character sets.
(as far as why I would know this, I am embarrased to
say, but it matters for our environment).
"Please do NOT define ORA_NLSxx as (system) ENVIROMENT
variable on windows."
"Please do NOT define ORACLE_HOME and/or ORACLE_BASE
as (system) ENVIROMENT variable on windows as this
will invalidate the working of ORA_NLSxx."
Jared,
Did you set environment variable values for
ORACLE_HOME or ORACLE_BASE?
Paul
--- James Howerton <jhowerton@xxxxxxxxx> wrote:
> I use the 9i listener(9.2.0.x) on several Solaris
> boxes with 8.1.6.2,
> 8.1.7.X,9.0.1, and 9.2.0 databases with no problems
>
> ...JIM...
>
> >>> jkstill@xxxxxxxxxx 3/18/04 9:57:39 AM >>>
> I recently installed a 9i database on an NT server
> that
> already has 8i on it. The listener for both was
> setup
> to be 9i, disabling the 8i listener.
>
> It has proved to be somewhat cranky. I've noticed
> that
> even though the service starts automatically, it
> sometimes
> will not work correctly unless it is manually
> started
> via lsnrctl.
>
> Could be a version problem. Or it could just be an
> NT
> thing, which is good at not starting services
> correctly anyway.
>
> Jared
>
> On Thu, 2004-03-18 at 05:06, Martin Brown wrote:
> > I had some trouble like this way-back-when 8i was
> released. I found
> out that
> > 8i listener couldn't service 8.0.5 (8.0.6 was OK).
> I had to set up
> named
> > listeners and that worked OK in my environment.
> >
> >
> > >From: "Darrell Landrum" <darrell@xxxxxxxxxxx>
> > >Reply-To: oracle-l@xxxxxxxxxxxxx
> > >To: <oracle-l@xxxxxxxxxxxxx>
> > >Subject: Re: 9i listener for 8i DB not
> recommended???
> > >Date: Wed, 17 Mar 2004 23:37:27 -0600
> > >
> > >I'm with you, Rich. I don't know where I got it,
> but I've believed
> it to
> > >be
> > >appropriate if not recommended to run the
> listener from the latest
> release
> > >you have installed for that release and each one
> prior that you may
> have on
> > >that system (unless you need a special listener
> for some reason.).
> We
> > >currently do that. The only problem I've
> encountered is running a
> 9i
> > >listener from a 64 bit install and using that for
> an 8i, 32 bit
> instance.
> > >The listener crashed a lot.
> > >
> > >
> > >----- Original Message -----
> > >From: "Jesse, Rich"
> <Rich.Jesse@xxxxxxxxxxxxxxxxx>
> > >To: "ORACLE-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
> > >Sent: Wednesday, March 17, 2004 3:29 PM
> > >Subject: 9i listener for 8i DB not recommended???
> > >
> > >
> > > > Hey all,
> > > >
> > > > While trying to debug a particularly nasty old
> app, I ran across
> this on
> > >doc
> > > > 77442.1 on MetaLink:
> > > >
> > > > Please note that we don't advise to use a
> version 9 listener for
> a
> > >version
> > > > 8 database
> > > > or a version 10 listener for a version 9 or 8
> database seen there
> where
> > >many
> > > > changes
> > > > to the NLS layers between those versions.
> > > >
> > > > As Moe Syzlak says, "WHAAAAAA??!?" This is
> exactly opposite
> from
> > >everything
> > > > else I've heard, although to be fair, I can't
> recall exactly
Other related posts:
