Re: Upgrade from 8i Standard Edition to Enterprise Causes problems

Thanks for the idea, but the issue is NLS_LANG was not set in the registry. Matched the database setting in the Oracle registry keys, and bam, the apps started functioning.

Little note... If you have an application running locally with the DB server, besure that the NLS_LANG is set correctly, the errors and traces will make the issue look like a networking problem, but it is a configuration issue.

Jim

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:Zaeo9.19953$zX3.53835_at_news.indigo.ie...
>
>
> two things - sqlnet.ora removing AUTHENTICATION_SERVICES = nts solves some
> of this
> and NT group membership for the new installation
> "Jim Stern" <jdstern_at_k2services.com> wrote in message
> news:anqor0$1ef$1_at_news.utelfla.com...
> > Okay gang here's the issue.
> >
> > Have an NT 4.0 server w/SP6, which is running a: third party app, a
> license
> > manager daemon (Flexlm) and Oracle 8.1.7.4.1 SE. Have both local users
> (on
> > the NT server), and remote users via OCI and a webserver (calling a
> cgi-bin,
> > to execute a local app). Needed to replicate to another Oracle
instance,
> > and SE, does not have any of the adv. replication functions. So, I
> > deinstalled SE (left the database files), clear the registry, and
> installed
> > Enterprise Edition and the appropriate patches. Now the problem. The
> none
> > of the apps run locally on the server can logon to the Oracle instance,
> and
> > remote users accessing via the webserver (remember it runs a local app,
> via
> > cgi-bin). But the remote users can access the database via their local
> > apps.
> >
> > I turned on tracing, and noticed that when a remote user access the
> system,
> > they do not interact with Oracle's advance security, but when locally
> > executed (on the NT server), the trace log is littered with security
> > checking/handshaking.
> >
> > Any ideas, on what Oracle is doing?, and how to fix this local logon
> issue.
> >
> > Jim Stern
> > Snr. DBA
> > FedEx.
> >
> >
>
>
Received on Tue Oct 08 2002 - 19:02:45 CDT