Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Pb err: 12560 TNS protocol adapter error

Pb err: 12560 TNS protocol adapter error

From: Eulfurax <eulfurax_at_wanadoo.fr>
Date: Fri, 10 Jan 2003 11:40:20 +0100
Message-ID: <avm7uu$9o1$1@news-reader10.wanadoo.fr> 





Hi,



I can't connect Oracle 8i client ( on NT2K ) to the Oracle server 8i on NT
2K



when i try to test the service via NET8 assistant i get :



Err: 12560 TNS Protocol adapter error



trace above ,



I am puzzled.....



Thanks all



Philippe








Attempted load of local pfile source


D:\Oracle\Ora81\network\tools\sqlnet.ora
Parameter source was not loaded



 -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load


 -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
  TRACE_DIRECTORY_SERVER = c:


  TRACE_DIRECTORY_CLIENT = c:


  SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf

  TRACE_FILE_CLIENT = trace
  TRACE_FILE_SERVER = traceserveur
  TRACE_UNIQUE_CLIENT = on
  TRACE_LEVEL_CLIENT = ADMIN
  TRACE_LEVEL_SERVER = ADMIN




--- PARAMETER SOURCE INFORMATION ENDS ---






nigini: entry
nigini: Count in NI global area now: 1
nigini: Count in NI global area now: 1
nrigbi: entry
nrigbni: entry




nrigbni: Unable to get data from navigation file tnsnav.ora
nrigbni: exit


nrigbi: exit


nigini: exit


niqname: Hst is already an NVstring.


niqname: Inserting CID.

niotns: entry
niotns: niotns: setting up interrupt handler...
niotns: Not trying to enable dead connection detection.
niotns: Calling address:




(DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=se
rveurnt)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ASCLEPIO)(CID=(PROGRAM=C:\P
rogram


Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=EDI3)(USER=Administrateur))))
nsmal: 140 bytes at 0x345a490


nscall: connecting...

nladini: entry
nladini: exit
nladget: entry
nladget: exit
nttbnd2addr: entry
nttbnd2addr: port resolved to 1521




nttbnd2addr: looking up IP addr for host: serveurnt
nttbnd2addr: exit


nsmal: 428 bytes at 0x3225d48


nsmal: 1712 bytes at 0x34738a0

nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvllt: entry
ntvllt: No PROTOCOL.ORA file is found
ntvllt: exit
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 1560.
nttcni: exit
nttcon: exit
nsopen: transport is open




nsnainit: call


nainit: entry


nagblini: entry

nau_gin: entry
nau_gparams: entry
nam_gbp: Reading parameter "sqlnet.authentication_required" from parameter


file

nam_gbp: Parameter not found
nau_gparams: Using default value "FALSE"
nau_gslf: entry
nam_gic: entry
nam_gic: Counting # of items in "sqlnet.authentication_services" parameter
nam_gic: Parameter not found
nam_gic: Found 0 items
nam_gic: exit
nau_gslf: Using default value "all available adapters"


nauss_set_state: entry


nauss_set_state: exit

nau_gslf: exit
nau_gparams: exit
nau_gin: exit




nagblini: exit


na_saveprot: entry


na_saveprot: exit


nacomin: entry

nas_init: entry
nas_init: exit
nau_ini: entry




naugcp_get_connect_parameters: entry


nauss_set_state: entry


nauss_set_state: exit


naugcp_get_connect_parameters: exit

nau_gettab: entry
nau_tadv: entry
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_tadv: exit
nau_gettab: exit
nau_sini: entry
nau_sini: exit
nau_ini: exit




naeeinit: entry

nam_gbp: Reading parameter "SQLNET.FIPS_140" from parameter file
nam_gbp: Parameter not found
nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_CLIENT" from parameter file
nam_gnsp: Parameter not found
naequad: Using default value "ACCEPTED"
nam_gic: entry
nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_CLIENT" parameter


nam_gic: Parameter not found


nam_gic: exit


naesno: Using default value "all available algorithms"
naeshow: entry


naeshow: exit

naeeinit: exit
naecinit: entry
nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_CLIENT" from parameter


file


nam_gnsp: Parameter not found

naequad: Using default value "ACCEPTED"
nam_gic: entry
nam_gic: Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT"


parameter


nam_gic: Parameter not found


nam_gic: exit


naesno: Using default value "all available algorithms"
naeshow: entry


naeshow: exit


naecinit: exit


nainit: exit


nagetctxinfo: entry


nagetctxinfo: exit

nsnainit: NS Connection version: 310
nsnainit: inf->nsinfflg[0]: 0x41 inf->nsinfflg[1]: 0x41
nsnainit: "or" info flags: 0x41 Translations follow:


 native service(s) is (are) wanted



nsnainit: "or" info flags: 0x41 Translations follow:
 native service(s) is (are) wanted


"and" info flags: 0x41 Translations follow:
 native service(s) is (are) wanted



nsoptions: lcl[0]=0x0, lcl[1]=0x100000, gbl[0]=0x0, gbl[1]=0x0, cha=0x0
nsoptions: lcl[0]=0x1fefff, lcl[1]=0x100000, gbl[0]=0xf83f, gbl[1]=0x0
nsopen: global context check-in (to slot 0) complete
nsopen: lcl[0]=0x1fefff, lcl[1]=0x100000, gbl[0]=0xf83f, gbl[1]=0x0,
tdu=32767, sdu=2048

nsdo: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=7, flg=0x4201, mvd=0




nsmal: 44 bytes at 0x3429e28


nsmal: 44 bytes at 0x33eb4a8


nlidg8: entry


nlidg8: exit

nsdo: nsctxrnk=0
nsdo: cid=0, opcode=67, *bl=215, *what=8, uflgs=0x0, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=14, flg=0x4205, mvd=0
nsdo: gtn=0, gtc=0, ptn=10, ptc=2023




nscon: doing connect handshake...


nscon: sending NSPTCN packet


nspsend: plen=273, type=1

nttwr: entry
nttwr: socket 1560 had bytes written=273
nttwr: exit




nspsend: 273 bytes to transport

nsdo: nsctxrnk=0
nsdo: cid=0, opcode=68, *bl=512, *what=9, uflgs=0x0, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=2, flg=0x4205, mvd=0
nsdo: gtn=0, gtc=0, ptn=10, ptc=2023




nscon: recving a packet


nsmal: 44 bytes at 0x33eb5e8


nsprecv: reading from transport...

nttrd: entry
nttrd: socket 1560 had bytes read=60
nttrd: exit




nsprecv: 60 bytes from transport


nsprecv: tlen=60, plen=60, type=5


nscon: got NSPTRD packet


nscon: got 50 bytes connect data


nsdo: nsctxrnk=0


nscall: redirected


nstimarmed: no timer allocated

nsdo: cid=0, opcode=98, *bl=0, *what=0, uflgs=0x440, cflgs=0x2
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=3, flg=0x4201, mvd=0
nsdo: nsctxrnk=0
nsclose: closing transport
nttdisc: entry
nttdisc: Closed socket 1560




nttdisc: exit


nsclose: global context check-out (from slot 0) complete
nadisc: entry

nacomtm: entry
nacompd: entry
nacompd: exit
nacompd: entry
nacompd: exit
nacomtm: exit
nas_dis: entry
nas_dis: exit
nau_dis: entry
nau_fad: exit
nau_dis: exit
naeetrm: entry
naeetrm: exit
naectrm: entry
naectrm: exit




nagbltrm: entry


nau_gtm: entry


nau_gtm: exit


nagbltrm: exit


nadisc: exit


nsmfr: 1712 bytes at 0x34738a0


nsmfr: 428 bytes at 0x3225d48


nscall: connecting...

nttbnd2addr: entry
nttbnd2addr: port resolved to 1602
nttbnd2addr: using host IP address: 1.1.1.20
nttbnd2addr: exit




nsmal: 428 bytes at 0x3225d48


nsmal: 1712 bytes at 0x34738a0

nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 1600.


ntt2err: entry


ntt2err: soc 1600 error - operation=1, ntresnt[0]=538, ntresnt[1]=65,
ntresnt[2]=0


ntt2err: exit


nttcni: exit


nttcon: exit


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


nsopen: unable to open transport

nsmfr: 1712 bytes at 0x34738a0
nsmfr: 428 bytes at 0x3225d48
nsmfr: 215 bytes at 0x3226008
nsmfr: 140 bytes at 0x345a490
nladtrm: entry
nladtrm: exit
nioqper:  error from nscall
nioqper:    nr err code: 0
nioqper:    ns main err code: 12560
nioqper:    ns (2)  err code: 0
nioqper:    nt main err code: 538




nioqper:    nt (2)  err code: 65


nioqper:    nt OS   err code: 0


niomapnserror: entry

niqme: entry
niqme: reporting NS-12560 error as ORA-12560
niqme: exit




niomapnserror: returning error 12560


niomapnserror: exit

niotns: Couldn't connect, returning 12560
niotns: exit
nsbrfr: nsbfs at 0x33eb5e8, data at 0x346b600.
nsbrfr: nsbfs at 0x33eb4a8, data at 0x3473f88.
nsbrfr: nsbfs at 0x3429e28, data at 0x34747b0.
nigtrm: Count in the NI global area is now 0


nnfgdei: entry

nrigbd: entry
nrigbd: exit
nigtrm: Count in the NL global area is now 0


Received on Fri Jan 10 2003 - 04:40:20 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US