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

Home -> Community -> Usenet -> c.d.o.server -> Intriguing server connection problems on Windows 2000

Intriguing server connection problems on Windows 2000

From: FC <flavio_at_tin.it>
Date: Tue, 11 Feb 2003 10:42:30 GMT
Message-ID: <qs42a.164382$0v.4612793@news1.tin.it> 





Hi Folks,


I wish to ask for the advice of you gurus before delving into the
reinstallation of the O/S.



I am hitting connection problems when I try to access a freshly installed db
instance (8.1.7.0.0 EE) running on a windows 2000 Pro box. Oracle EE has
been installed yesterday.


The error messages range from 12451 (No listener, while the listener is up
and running) to 12547 (Lost contact, with the db mounted and open).
I can connect to the db locally using CONNECT INTERNAL (using IPC protocol,
I presume) but any attempt to log on specifying a net service name fails
miserably.







# TNSNAMES.ORA Network Configuration File:
E:\oracle\ora81\NETWORK\ADMIN\tnsnames.ora



# Generated by Oracle configuration tools.



EXTPROC_CONNECTION_DATA =




(DESCRIPTION =




   (ADDRESS_LIST =



       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

   )



   (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO))
)



DEV817 =




(DESCRIPTION =




   (ADDRESS_LIST =



       (ADDRESS = (PROTOCOL = TCP)(HOST = amd-k7)(PORT = 1521))
   )


  (CONNECT_DATA =  (SERVICE_NAME = dev817.yocoya.com))
)






# LISTENER.ORA Network Configuration File:
E:\oracle\ora81\network\admin\listener.ora



# Generated by Oracle configuration tools.



LISTENER =




(DESCRIPTION_LIST =




  (DESCRIPTION =


      (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
     (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = amd-k7)(PORT = 1521))
     )




  )


  (DESCRIPTION =


      (PROTOCOL_STACK = (PRESENTATION = GIOP)(SESSION = RAW))
      (ADDRESS = (PROTOCOL = TCP)(HOST = amd-k7)(PORT = 2481))


  )


)



SID_LIST_LISTENER =




(SID_LIST =




  (SID_DESC = (SID_NAME = PLSExtProc)

                          (ORACLE_HOME = E:\oracle\ora81)
                          (PROGRAM = extproc))
  (SID_DESC = (GLOBAL_DBNAME = dev817.yocoya.com)
                         (ORACLE_HOME = E:\oracle\ora81)
                         (SID_NAME = dev817))


)






TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production on 11-FEB-2003
10:37:44



(c) Copyright 1998 Oracle Corporation.  All rights reserved.




System parameter file is E:\oracle\ora81\network\admin\listener.ora
Log messages written to E:\oracle\ora81\network\log\listener.log
Trace information written to E:\oracle\ora81\network\trace\listener.trc
Trace level is currently 0



Listening on:


(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amd-k7)(PORT=1521)))
Listening on:


(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amd-k7)(PORT=2481))(PROTOCOL_STACK

=(PRESENTATION=GIOP)(SESSION=RAW)))



TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

11-FEB-2003 10:46:40 * 12541



TNS-12541: TNS:no listener


 TNS-12560: TNS:protocol adapter error


  TNS-00511: No listener


   32-bit Windows Error: 61: Unknown error








Below you can find the client trace file resulting from a connection test
using Net8 Assistant:






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=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=amd-k7)(PORT=1521)))

(CONNECT_DATA=(SERVICE_NAME=dev817.yocoya.com)(CID=(PROGRAM=C:\Program

Files\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=AMD-K7)(USER=Administrator))))



nscall: entry



nsmal: entry



nsmal: 140 bytes at 0x3239b08



nsmal: normal exit



nscall: connecting...



nladini: entry



nladini: exit



nladget: entry



nladget: exit



nsc2addr: entry



nttbnd2addr: entry



nttbnd2addr: port resolved to 1521



nttbnd2addr: looking up IP addr for host: amd-k7



nttbnd2addr: exit



nsc2addr: normal exit



nsopen: entry



nsmal: entry



nsmal: 420 bytes at 0x32618a0



nsmal: normal exit



nsopenmplx: entry



nsmal: entry



nsmal: 1712 bytes at 0x3261a58



nsmal: normal exit



nsopenmplx: normal exit



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: creating a socket.



nttcnp: exit



nttcni: entry



nttcni: trying to connect to socket 1572.



nttcni: exit



nttcon: NT layer TCP/IP connection has been established.



nttcon: set TCP_NODELAY on 1572



nttcon: exit



nsopen: transport is open



nsnainit: entry



nsnainit: call



nsnadct: entry



nsnadct: normal exit



nsnasvnainfo: entry



nsnasvnainfo: normal exit



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: Found 1 items



nam_gic: exit



nam_gnsp: Reading parameter "sqlnet.authentication_services" from parameter
file



nam_gnsp: Found value "NTS"



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: The following authentication adapter dll does not exist:
orangss8.dll



nau_fad: exit



nau_fad: entry



nau_fad: The following authentication adapter dll does not exist:
oranidx8.dll



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: The following authentication adapter dll does not exist:
oranoss8.dll



nau_fad: exit



nau_fad: entry



nau_fad: exit



nau_tadv: Found at least one invalid entry



nau_tadv: exit



nau_gettab: using authentication adapter table "dynamic table"



nau_gettab: dynamic table contains the following services:



nau_gettab: KERBEROS5



nau_gettab: SECURID



nau_gettab: NDS



nau_gettab: NTS



nau_gettab: RADIUS



nau_gettab: exit



nau_sini: entry



nau_sini: exit



nau_ini: connection type: "standard"



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: These are the encryption algorithms that the client will accept:



naeshow: Choice 0: no algorithm; encryption inactive



naeshow: Choice 1: 'RC4_40' (ID 1)



naeshow: Choice 2: 'RC4_56' (ID 8)



naeshow: Choice 3: 'DES' (ID 2)



naeshow: Choice 4: 'DES40' (ID 3)



naeshow: Choice 5: 'RC4_256' (ID 6)



naeshow: Choice 6: 'RC4_128' (ID 10)



naeshow: Choice 7: '3DES168' (ID 12)



naeshow: Choice 8: '3DES112' (ID 11)



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: These are the checksumming algorithms that the client will accept:



naeshow: Choice 0: no algorithm; checksumming inactive



naeshow: Choice 1: 'SHA1' (ID 3)



naeshow: Choice 2: 'MD5' (ID 1)



naeshow: exit



naecinit: exit



nainit: exit



nagetctxinfo: entry



nagetctxinfo: exit



nsnainit: NS Connection version: 310



nsnainit: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x61



nsnainit: "or" info flags: 0x61 Translations follow:



native service(s) is (are) wanted



nsnainit: "or" info flags: 0x61 Translations follow:



native service(s) is (are) wanted



"and" info flags: 0x61 Translations follow:



native service(s) is (are) wanted



nsnainit: normal exit



nsoptions: entry



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



nsoptions: normal exit



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: entry



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



nsbal: entry



nsbgetfl: entry



nsbgetfl: normal exit



nsmal: entry



nsmal: 44 bytes at 0x321d7c0



nsmal: normal exit



nsbal: normal exit



nsbal: entry



nsbgetfl: entry



nsbgetfl: normal exit



nsmal: entry



nsmal: 44 bytes at 0x323be98



nsmal: normal exit



nsbal: normal exit



nsepcIniCFI: entry



nlidg8: entry



nlidg8: exit



nsepcIniCFI: normal exit



nsdo: nsctxrnk=0



nsdo: normal exit



nsopen: normal exit



nsdo: entry



nsdo: cid=0, opcode=67, *bl=204, *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=2019



nscon: entry



nscon: doing connect handshake...



nscon: sending NSPTCN packet



nspsend: entry



nspsend: plen=262, type=1



nttwr: entry



nttwr: socket 1572 had bytes written=262



nttwr: exit



nspsend: 262 bytes to transport



nspsend: packet dump



nspsend: 01 06 00 00 01 00 00 00 |........|



nspsend: 01 36 01 2C 00 00 08 00 |.6.,....|



nspsend: 7F FF A3 0A 00 00 01 00 |........|



nspsend: 00 CC 00 3A 00 00 02 00 |...:....|



nspsend: 61 61 00 00 00 00 00 00 |aa......|



nspsend: 00 00 00 00 01 94 00 00 |........|



nspsend: 00 0D 00 00 00 00 00 00 |........|



nspsend: 00 00 28 44 45 53 43 52 |..(DESCR|



nspsend: 49 50 54 49 4F 4E 3D 28 |IPTION=(|



nspsend: 41 44 44 52 45 53 53 3D |ADDRESS=|



nspsend: 28 50 52 4F 54 4F 43 4F |(PROTOCO|



nspsend: 4C 3D 54 43 50 29 28 48 |L=TCP)(H|



nspsend: 4F 53 54 3D 61 6D 64 2D |OST=amd-|



nspsend: 6B 37 29 28 50 4F 52 54 |k7)(PORT|



nspsend: 3D 31 35 32 31 29 29 28 |=1521))(|



nspsend: 43 4F 4E 4E 45 43 54 5F |CONNECT_|



nspsend: 44 41 54 41 3D 28 53 45 |DATA=(SE|



nspsend: 52 56 49 43 45 5F 4E 41 |RVICE_NA|



nspsend: 4D 45 3D 64 65 76 38 31 |ME=dev81|



nspsend: 37 2E 79 6F 63 6F 79 61 |7.yocoya|



nspsend: 2E 63 6F 6D 29 28 43 49 |.com)(CI|



nspsend: 44 3D 28 50 52 4F 47 52 |D=(PROGR|



nspsend: 41 4D 3D 43 3A 5C 50 72 |AM=C:\Pr|



nspsend: 6F 67 72 61 6D 20 46 69 |ogram Fi|



nspsend: 6C 65 73 5C 4F 72 61 63 |les\Orac|



nspsend: 6C 65 5C 6A 72 65 5C 31 |le\jre\1|



nspsend: 2E 31 2E 37 5C 62 69 6E |.1.7\bin|



nspsend: 5C 6A 72 65 77 2E 65 78 |\jrew.ex|



nspsend: 65 29 28 48 4F 53 54 3D |e)(HOST=|



nspsend: 41 4D 44 2D 4B 37 29 28 |AMD-K7)(|



nspsend: 55 53 45 52 3D 41 64 6D |USER=Adm|



nspsend: 69 6E 69 73 74 72 61 74 |inistrat|



nspsend: 6F 72 29 29 29 29 00 00 |or))))..|



nspsend: normal exit



nscon: exit (0)



nsdo: nsctxrnk=0



nsdo: normal exit



nsdo: entry



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=2019



nscon: entry



nscon: recving a packet



nsprecv: entry



nsbal: entry



nsbgetfl: entry



nsbgetfl: normal exit



nsmal: entry



nsmal: 44 bytes at 0x3233778



nsmal: normal exit



nsbal: normal exit



nsprecv: reading from transport...



nttrd: entry



ntt2err: entry



ntt2err: soc 1572 error - operation=5, ntresnt[0]=530, ntresnt[1]=53,
ntresnt[2]=0



ntt2err: exit



nttrd: exit



nsprecv: transport read error



nsprecv: error exit



nserror: entry



nserror: nsres: id=0, op=68, ns=12570, ns2=12560; nt[0]=530, nt[1]=53,
nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0



nscon: error exit



nsdo: nsctxrnk=0



nsdo: error exit



nscall: unexpected response



nsclose: entry



nstimarmed: entry



nstimarmed: no timer allocated



nstimarmed: normal exit



nsdo: entry



nsdo: cid=0, opcode=98, *bl=0, *what=0, uflgs=0x440, cflgs=0x2



nsdo: rank=64, nsctxrnk=0



nsdo: nsctx: state=1, flg=0x4201, mvd=0



nsbfr: entry



nsbaddfl: entry



nsbaddfl: normal exit



nsbfr: normal exit



nsbfr: entry



nsbaddfl: entry



nsbaddfl: normal exit



nsbfr: normal exit



nsdo: nsctxrnk=0



nsdo: normal exit



nsclose: closing transport



nttdisc: entry



nttdisc: Closed socket 1572



nttdisc: exit



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



nsnadisc: entry



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



nsnadisc: normal exit



nsbfr: entry



nsbaddfl: entry



nsbaddfl: normal exit



nsbfr: normal exit



nsmfr: entry



nsmfr: 1712 bytes at 0x3261a58



nsmfr: normal exit



nsmfr: entry



nsmfr: 420 bytes at 0x32618a0



nsmfr: normal exit



nsclose: normal exit



nscall: connecting...



nsclose: entry



nsclose: normal exit



nladget: entry



nladget: exit



nsmfr: entry



nsmfr: 204 bytes at 0x3264a60



nsmfr: normal exit



nsmfr: entry



nsmfr: 140 bytes at 0x3239b08



nsmfr: normal exit



nladtrm: entry



nladtrm: exit



nscall: error exit



nioqper: error from nscall



nioqper: nr err code: 0



nioqper: ns main err code: 12570



nioqper: ns (2) err code: 12560



nioqper: nt main err code: 530



nioqper: nt (2) err code: 53



nioqper: nt OS err code: 0



niomapnserror: entry



niqme: entry



niqme: reporting NS-12570 error as ORA-12570



niqme: exit



niomapnserror: returning error 12570



niomapnserror: exit



niotns: Couldn't connect, returning 12570



niotns: exit



nsbfrfl: entry



nsbrfr: entry



nsbrfr: nsbfs at 0x3233778, data at 0x3264b38.



nsbrfr: normal exit



nsbrfr: entry



nsbrfr: nsbfs at 0x323be98, data at 0x3264238.



nsbrfr: normal exit



nsbrfr: entry



nsbrfr: nsbfs at 0x321d7c0, data at 0x3263a10.



nsbrfr: normal exit



nsbfrfl: normal exit



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 Tue Feb 11 2003 - 04:42:30 CST












Original text of this message













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