Re: 9i listener for 8i DB not recommended???
- From: Paul Drake <discgolfdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 18 Mar 2004 13:53:02 -0800 (PST)
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
> where I've
> > > > heard that. That and the fact that we haven't
> been using the
> ORA_NLSxx
> > > > variable since it starting cauing problems
> when we migrated from
> 7.3 to
> > >8.0,
> > > > which accoring to this doc, is a no-no.
> > > >
> > > > Comments?
> > > > Rich
> > > >
> > > > Rich Jesse
> System/Database Administrator
> > > > rich.jesse@xxxxxxxxxxxxxxxxx QuadTech,
> Sussex, WI USA
> > > >
>
----------------------------------------------------------------
> > > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > >
>
----------------------------------------------------------------
> > > > To unsubscribe send email to:
> oracle-l-request@xxxxxxxxxxxxx
> > > > put 'unsubscribe' in the subject line.
> > > > --
> > > > Archives are at
> //www.freelists.org/archives/oracle-l/
> > > > FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
>
> > > >
>
-----------------------------------------------------------------
> > > >
> > >
> >
>
>----------------------------------------------------------------
> > >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >
>
>----------------------------------------------------------------
> > >To unsubscribe send email to:
> oracle-l-request@xxxxxxxxxxxxx
> > >put 'unsubscribe' in the subject line.
> > >--
> > >Archives are at
> //www.freelists.org/archives/oracle-l/
> > >FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
>
> >
>
>-----------------------------------------------------------------
> >
> >
> >
>
----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >
>
----------------------------------------------------------------
> > To unsubscribe send email to:
> oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> //www.freelists.org/archives/oracle-l/
> > FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
>
> >
>
-----------------------------------------------------------------
>
>
----------------------------------------------------------------
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
----------------------------------------------------------------
> To unsubscribe send email to:
> oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> //www.freelists.org/archives/oracle-l/
> FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
>
>
-----------------------------------------------------------------
>
----------------------------------------------------------------
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
----------------------------------------------------------------
> To unsubscribe send email to:
> oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> //www.freelists.org/archives/oracle-l/
> FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
>
-----------------------------------------------------------------
=== message truncated ===
__________________________________
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
