Re: Problem connecting to 8i on same machine

Thanks for your reactions. I tried the suggested solutions before. But still the same
TNS No such protocol adapter error. If these weren't set correctly the error would be
something like TNS Could not resolve service name. I finally found the cause of the error.
The Oracle 8i installation has added a entry to the autoexec.bat

'set oracle_home = f:\oracle\ora81'. (Why use autoexec.bat on an NT machine ??????? ).

This entry overrules all other registry settings and, as it seems, causes the SQLNET 8.04
interface to look for the protocol adapters in the Oracle 8.1.5 home. These probably are
of the wrong type or verion, and cause the protocol adapter error. Removing the oracle_home
line in autoexec.bat fixes things completely.

"Peter" <P.Slingerland_at_IMN.nl> wrote in message news:8uo97j$r1l$1_at_nereid.worldonline.nl...
> Hello all,
>
> I'm having trouble connecting to my Oracle 8i (8.1.5) database on NT
> from Enternprise Manager client applications and WebDB on the same
> machine.
>
> I've installed Oracle 8i (default install). The database is running fine.
> Then I
> install the Enterprise Manager client applications (storage manager,
> security
> manager etc.) on the same machine. This installation creates a new Oracle
> home (as expected) Then when I'm trying to configure sqlnet for this new
> Oracle Home I get the TNS-12203 Error (TNS:unable to connect to
 destination)
> message. I can still connect to the database using sqlplus in the 8i
> home\bin directory.
> Similar problems occur when installing WebDB.
>
> When I perfom the same client installation steps on another NT machine,
 and
> try to
> connect to 8i on the first machine things work fine.
>
> Is there anyone who experienced the same problems and solved them? Please
> inform
> me.
>
> Thanks,
>
>
> Peter.
>
>
>
>
Received on Thu Nov 16 2000 - 08:58:17 CST