Upgrade from 8i Standard Edition to Enterprise Causes problems

Upgrade from 8i Standard Edition to Enterprise Causes problems

Post by Jim Ster » Tue, 08 Oct 2002 10:42:52



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.

 
 
 

Upgrade from 8i Standard Edition to Enterprise Causes problems

Post by Telemachu » Tue, 08 Oct 2002 20:25:45


two things - sqlnet.ora removing AUTHENTICATION_SERVICES = nts solves some
of this
and NT group membership for the new installation

Quote:> 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.


 
 
 

Upgrade from 8i Standard Edition to Enterprise Causes problems

Post by Jim Ster » Thu, 10 Oct 2002 09:02:45


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


> two things - sqlnet.ora removing AUTHENTICATION_SERVICES = nts solves some
> of this
> and NT group membership for the new installation


> > 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.