This content has been marked as final. Show 4 replies
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.
Senior Oracle DBA
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.
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?
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.