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