Re: Net8-Problem

In article <8uu4ct$42v$1_at_nnrp1.deja.com>,   michaelbogen_at_my-deja.com wrote:
> Hi,
>
> I have installed Oracle Developer (C:\orant) and Oracle 8i
 (c:\orant8i)
> on Windows NT 4.0. Basicly everything works, except of the following:
> Beeing logged in as NT-administrator and trying to connect to the
> database (via net8) I always get a tns-12538 Error (TNS:no such
 protocol
> adapter). tnsping80 also does not work. However, as a normal user I
> don't have that problem. In sqlnet.ora I set the trace level to 16
 and saw
> in the tracefile that tnsnames.ora is not found, altough both
> ORACLE_HOME and TNS_ADMIN are set properly.
> Any ideas? Thanks for any help!!
>

I've had this problem in several forms.

The one time I had it was because I'd removed my Lan adaptor and thus the TCP/IP stack hadn't initialized at all, I was still able to get in using a Beqeath connection

However I usually get it oncem I've got multiple Oracle homes, especially when they've been set-up accidentally

What I usually do is go into DOS and do

C:\ set ORACLE_SID=prod
C:\ svrmgr30

(where prod is your SID)

I've fixed it by going into the registry and removing the other Oracle homes

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 15 2000 - 09:32:27 CST