TNS-12560: TNS:protocol adapter error

From: Hagen Finley <hagen_at_violet.berkeley.edu>
Date: 1996/11/17
Message-ID: <328FEAB7.59DD_at_violet.berkeley.edu>#1/1


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  TNS-12560: TNS:protocol adapter error
  TNS-00530: Protocol adapter error
   WINDOWS 32 Error: 2: No such file or directory Connecting to
(ADDRESS=(COMMUNITY=NMP.world)(PROTOCOL=NMP)(SERVER=SAVOIR)(PIPE=ORAPIPE))
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=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=savoir)(Port=1521))
TNS-12224: TNS:no listener
 TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error
   TNS-00511: No listener
    WINDOWS 32 Error: 61: Unknown system error Connecting to
(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=savoir)(Port=1526))
TNS-12224: TNS:no listener
 TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error
   TNS-00511: No listener
    WINDOWS 32 Error: 61: Unknown system error

        One issue that may be responsible for this mess is that 1) there is a version of PO7 WIN95 2) I have installed the PO7 Workgroup Server and the ORAWeb Server on the NT server machine which has produced redundant Network directories and probably more. I am not sure whether this dual installation on the NT Server is workable - although the PO7 DB is accessable locally on the NT machine.

        Hopefully, someone has a suggestion or two for this situation.

Hagen Finley Received on Sun Nov 17 1996 - 00:00:00 CET

Original text of this message