4 Replies Latest reply: Jun 25, 2011 8:16 AM by Billy~Verreynne RSS

    how can I connect using named pipes ( NMP ) ?

    588514
      Hi all,

      I'd like to do compare the availablke protocol (TCP, IPC, BEQ, NMP ) connect to my db, but I'm not able to configure named pipes.

      My *.ora files contain:
      tnsnames.ora:
      
      
      ORA10_NMP= 
        (DESCRIPTION =  
          (ADDRESS =   
            (PROTOCOL = NMP)    
            (SERVER = 10.10.1.1)  
            (PIPE = ORApipe)
          )
          (CONNECT_DATA =  
            (SID = ORA10)
          )
        )
      
      listener.ora:
      
      LISTENER_ORA10 =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
            (ADDRESS_LIST=
              (ADDRESS =
             (PROTOCOL = TCP)
             (HOST = 10.10.1.1)
             (PORT = 1522)
           )
              (ADDRESS =
             (PROTOCOL = IPC)
             (KEY = ORA10)
           )
              (ADDRESS =
             (PROTOCOL = NMP)
             (SERVER = 10.0.0.1)
                (PIPE = ORApipe)
           )
            )
          )
        )
      
      
      SID_LIST_LISTENER_ORA10 =
        (SID_LIST=
          (SID_DESC=
            (SID_NAME=ORA10)               
            (ORACLE_HOME=C:\oracle\product\10.2.0\db_1)
          )
        )
      The network adapter used to connect to 10.10.1.1 is a microsoft loopback adapter , and I installed the "microsoft client ".

      When I try to use the ORA10_NMP alias I always get errors like:
      C:\>c:\oracle\product\10.2.0\db_1\bin\TNSPING.EXE ORA10_NMP
      
      TNS Ping Utility for 32-bit Windows: Version 10.2.0.5.0 - Production on 24-JUN-2011 14:06:39
      
      Copyright (c) 1997,  2010, Oracle.  All rights reserved.
      
      Used parameter files:
      C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
      
      
      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = NMP) (SERVER = 10.10.1.1) (PIPE = ORApipe)) (CONNECT_DATA =
      (SID = ORA10)))
      TNS-12560: TNS:protocol adapter error
      
      C:\>c:\oracle\product\10.2.0\db_1\bin\sqlplus system/foo@ORA10_NMP
      
      SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 24 14:06:44 2011
      
      Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
      
      ERROR:
      ORA-12560: TNS:protocol adapter error
      
      
      Enter user-name:
      Any suggestion?
      Thanks,

      Andrea
        • 1. Re: how can I connect using named pipes ( NMP ) ?
          sybrand_b
          Named pipes uses Microsoft Netbeui, and Microsoft has stopped shipping this protocol.
          Also using a hardcoded IP address in the host definition is definitely not correct, it should be the name of your computer.

          I would first find out whether Named Pipes is still supported, as far as I know it isn't. Then I would set up the listener.ora and tnsnames.ora correctly.


          ------------
          Sybrand Bakker
          Senior Oracle DBA
          • 2. Re: how can I connect using named pipes ( NMP ) ?
            Billy~Verreynne
            user585511 wrote:

            I'd like to do compare the availablke protocol (TCP, IPC, BEQ, NMP ) connect to my db, but I'm not able to configure named pipes.
            Why?

            You can run named pipes over TCP/IP, but it is seldom done - mostly for support of legacy stuff that used NetBEUI. The Berkeley socket interface is by far superior. And standard.

            Named pipes are excellent for IPC - inter process communication across process boundaries within the same kernel space. For networking? A poor choice compared to using sockets.

            What are you hoping to check or prove/disprove using named pipes over IP?
            • 3. Re: how can I connect using named pipes ( NMP ) ?
              588514
              I'd like to test and compare the different protocols: I will move a client application from the dbserver to a different server and I'd like to compare the different protocols.

              Andrea
              • 4. Re: how can I connect using named pipes ( NMP ) ?
                Billy~Verreynne
                There is no use for testing named pipes. As I said - it is an excellent method for IPC. It is slow and unscalable for networking, especially WANs.

                A few minutes of googling this subject and doing some bit of research, would highlight this quite clearly.

                BTW - if you think named pipes are better for tcp, then don't you think Oracle would have recommended its use? Heck, Oracle recommends using the RDS protocol for the RAC Interconnect. A protocol not widely known outside the HPC environment. So surely they would have sung the praises of more commonly known named pipes for tcp if it was any good?

                Which again points to the fact that it ain't good and your wasting your time by trying to be "clever" and barking up the wrong tree.