Re: TNS-12560: TNS:protocol adapter error

Hi there Hagan,

One thing you may want to try is issuing the command:

        C> lsnrctl start

This will start the TNS listner service. I found the Oracle installation does not configure the service to start automatically. Note there is some help with the command:

        c> lsnrctl help  

Good luck,

Allan Taunt.
DBA

Hagen Finley <hagen_at_violet.berkeley.edu> wrote in article <328FEAB7.59DD_at_violet.berkeley.edu>...
> I am trying to configure SQL*Net between a WIN95 machine and NT
> Workgroup Server. I've tested the TCP address and name resolution
> between the two machines and the IP network seems to be in order.
> However, SQL*Plus connections to the Workgroup Server fail complaining
> that there is no interface driver connected:
>
> ERROR: ORA-03121: no interface driver connected - function not performed
>
> Power Objects fail for the same reason. I've tried repeatedly to use
> SQL Easy Net configuration to configure the network interface but there
> aren't very many options to get wrong or right there.
>
> C> lsnrctl status returns
>
>
> LSNRCTL for WINDOWS 32: Version 2.2.2.1.0 - Production on 17-NOV-96
> 20:39:28
>
> Copyright (c) Oracle Corporation 1995. All rights reserved.
>
> Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=oracle.world))
> TNS-12203: TNS:unable to connect to destination
> TNS-12560: TNS:protocol adapter error
> TNS-00530: Protocol adapter error
> WINDOWS 32 Error: 2: No such file or directory
> Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ORCL))
> TNS-12203: TNS:unable to connect to destination

----snip

> Hopefully, someone has a suggestion or two for this situation.
>
> Hagen Finley
>
Received on Tue Nov 19 1996 - 00:00:00 CET