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_at_yahoo.com>
Sent by: oracle-l-bounce_at_freelists.org
03/18/2004 01:53 PM
Please respond to oracle-l
To: oracle-l_at_freelists.org
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_at_uabmc.edu> 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_at_cybcon.com 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_at_landrum.com>
> > >Reply-To: oracle-l_at_freelists.org
> > >To: <oracle-l_at_freelists.org>
> > >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_at_quadtechworld.com>
> > >To: "ORACLE-L (E-mail)" <oracle-l_at_freelists.org>
> > >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
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Mar 18 2004 - 18:51:20 CST