ORA-12560: TNS:protocol adapter error
575729Jan 26 2008 — edited Jan 27 2008hi
i have oracle installed on linux and trying to connect to database from window. but both client and server are oracle 10g release 2. i can connect to oracle on the linux machine using sqlplus scott/tiger@service. so no problem on linux system. but when i try to conect throught window system to linux. using the same service name i got
ORA-12560: TNS:protocol adapter error
note i have created the service name on window system also. i have a trace file hope some body can help
(1864) [26-JAN-2008 12:36:15:421] nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=169.254.188.233)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)(SERVER=DEDICATED)(CID=(PROGRAM=E:\oracle\product\10.2.0\client_1\jdk\jre\bin\java.exe)(HOST=SPITFIRE)(USER=Administrator))))
(1864) [26-JAN-2008 12:36:15:421] nttbnd2addr: entry
(1864) [26-JAN-2008 12:36:15:421] snlinGetAddrInfo: entry
(1864) [26-JAN-2008 12:36:15:421] snlinGetAddrInfo: exit
(1864) [26-JAN-2008 12:36:15:421] nttbnd2addr: using host IP address: 169.254.188.233
(1864) [26-JAN-2008 12:36:15:421] snlinFreeAddrInfo: entry
(1864) [26-JAN-2008 12:36:15:421] snlinFreeAddrInfo: exit
(1864) [26-JAN-2008 12:36:15:421] nttbnd2addr: exit
(1864) [26-JAN-2008 12:36:15:421] nsmal: 736 bytes at 0x3ac3528
(1864) [26-JAN-2008 12:36:15:421] nsmal: 1644 bytes at 0x3ac3810
(1864) [26-JAN-2008 12:36:15:421] nsmal: 84 bytes at 0x3aa7280
(1864) [26-JAN-2008 12:36:15:421] snsbitts_ts: acquired the bit
(1864) [26-JAN-2008 12:36:15:421] nsopen: opening transport...
(1864) [26-JAN-2008 12:36:15:421] nttcon: entry
(1864) [26-JAN-2008 12:36:15:421] nttcon: toc = 1
(1864) [26-JAN-2008 12:36:15:421] nttcnp: entry
(1864) [26-JAN-2008 12:36:15:421] nttcnp: exit
(1864) [26-JAN-2008 12:36:15:421] nttcni: entry
(1864) [26-JAN-2008 12:36:15:421] nttcni: trying to connect to socket 2348.
(1864) [26-JAN-2008 12:36:36:406] ntt2err: entry
(1864) [26-JAN-2008 12:36:36:406] ntt2err: soc 2348 error - operation=1, ntresnt[0]=538, ntresnt[1]=65, ntresnt[2]=0
(1864) [26-JAN-2008 12:36:36:406] ntt2err: exit
(1864) [26-JAN-2008 12:36:36:515] nttcni: exit
(1864) [26-JAN-2008 12:36:36:515] nttcon: exit
(1864) [26-JAN-2008 12:36:36:515] nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=538, nt[1]=65, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
(1864) [26-JAN-2008 12:36:36:515] nsopen: unable to open transport
(1864) [26-JAN-2008 12:36:36:515] snsbitts_ts: acquired the bit
(1864) [26-JAN-2008 12:36:36:515] snsbitts_ts: acquired the bit
(1864) [26-JAN-2008 12:36:36:515] nsmfr: 1644 bytes at 0x3ac3810
(1864) [26-JAN-2008 12:36:36:515] nsmfr: 736 bytes at 0x3ac3528
(1864) [26-JAN-2008 12:36:36:515] nladget: entry
(1864) [26-JAN-2008 12:36:36:515] nladget: exit
(1864) [26-JAN-2008 12:36:36:515] nsmfr: 212 bytes at 0x3acbcf8
(1864) [26-JAN-2008 12:36:36:515] nladtrm: entry
(1864) [26-JAN-2008 12:36:36:515] nladtrm: exit
(1864) [26-JAN-2008 12:36:36:515] nioqper: error from nscall
(1864) [26-JAN-2008 12:36:36:515] nioqper: ns main err code: 12560
(1864) [26-JAN-2008 12:36:36:515] nioqper: ns (2) err code: 0
(1864) [26-JAN-2008 12:36:36:515] nioqper: nt main err code: 538
(1864) [26-JAN-2008 12:36:36:515] nioqper: nt (2) err code: 65
(1864) [26-JAN-2008 12:36:36:515] nioqper: nt OS err code: 0
(1864) [26-JAN-2008 12:36:36:515] niomapnserror: entry
(1864) [26-JAN-2008 12:36:36:515] niqme: entry
(1864) [26-JAN-2008 12:36:36:515] niqme: reporting NS-12560 error as ORA-12560
(1864) [26-JAN-2008 12:36:36:515] niqme: exit
(1864) [26-JAN-2008 12:36:36:515] niomapnserror: exit
(1864) [26-JAN-2008 12:36:36:515] niotns: Couldn't connect, returning 12560
(1864) [26-JAN-2008 12:36:36:515] niotns: exit
(1864) [26-JAN-2008 12:36:36:515] nsbrfr: nsbfs at 0x3aa7280, data at 0x3ac3f80.
(1864) [26-JAN-2008 12:36:36:515] nigtrm: Count in the NI global area is now 0
(1864) [26-JAN-2008 12:36:36:515] nrigbd: entry
(1864) [26-JAN-2008 12:36:36:515] nrigbd: exit
(1864) [26-JAN-2008 12:36:36:515] nigtrm: Count in the NL global area is now 1
thanks