Upgrade from 8i Standard Edition to Enterprise Causes problems

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 Sun Oct 06 2002 - 20:42:52 CDT