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 -> Database connection problem from client

Database connection problem from client

From: Doggus <D0ggus_at_hotmail.com>
Date: 27 Jul 2004 14:59:11 -0700
Message-ID: <2248d2c1.0407271359.45180f61@posting.google.com> 





We are developing on Oracle 9i.  Databases are set up on a seperate
server while all developers have Oracle 9i client installed on
workstation.  For some reason I cannot connect to the server.  I have
turned on trace on the client and I am getting a couple of errors that
don't seem to make sense.  Of interest are theses errors which appear
in the trace later on...


nioqper:    nt main err code: 530


nioqper:    nt (2)  err code: 126



530 is a standard error that doesn't tell me sqaut.  error 126 as
follows:



TNS-00126 Missing Connection Manager name and address in TNSNET.ORA
Cause: The Interchange name specified in INTCHG.ORA is not defined in
the TNSNET.ORA file.


Action: Define one Connection Manager name and set of addresses for
each Interchange in the network. Regenerate the SQL*Net configuration
files using the configuration tool.



===>  On my coworkers machine which is working flawlessly, he does not
have a TNSNET.ORA or INTCHG.ORA file and neither do I.






===> When I try to connect from SQLPlus I get:



sqlplus dev/password_at_MTCDB


SQL*Plus: Release 9.2.0.1.0 - Production on Tue Jul 27 15:08:37 2004
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
ERROR:



ORA-03113: end-of-file on communication channel




===> sqlnet.log has the following:


v***********************************************************************


Fatal NI connect error 12560, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program
Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=DEV1)(USER=emp1))))



  VERSION INFORMATION:


	TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version


9.2.0.1.0 - Production


  Time: 27-JUL-2004 16:30:33


  Tracing to file: C:\temp\sqlnettrace_1540_1.trc
  Tns error struct:


    nr err code: 0


    ns main err code: 12560


    TNS-12560: TNS:protocol adapter error
    ns secondary err code: 0


    nt main err code: 530


    TNS-00530: Protocol adapter error


    nt secondary err code: 126


    nt OS err code: 0





===> trace file following:



[27-JUL-2004 16:30:33:164] 




--- TRACE CONFIGURATION INFORMATION FOLLOWS ---



[27-JUL-2004 16:30:33:164] New trace stream is

C:\temp\sqlnettrace_1540_1.trc


[27-JUL-2004 16:30:33:164] New trace level is 16

[27-JUL-2004 16:30:33:164] --- TRACE CONFIGURATION INFORMATION ENDS



---


[27-JUL-2004 16:30:33:164] 

--- PARAMETER SOURCE INFORMATION FOLLOWS ---


[27-JUL-2004 16:30:33:164] Attempted load of system pfile source

C:\oracle\ora92\network\admin\sqlnet.ora


[27-JUL-2004 16:30:33:164] Parameter source loaded successfully

[27-JUL-2004 16:30:33:164] 

[27-JUL-2004 16:30:33:164] Attempted load of local pfile source

C:\oracle\ora92\bin\sqlnet.ora


[27-JUL-2004 16:30:33:179] Parameter source was not loaded

[27-JUL-2004 16:30:33:179] 

[27-JUL-2004 16:30:33:179]  -> PARAMETER TABLE LOAD RESULTS FOLLOW <-

[27-JUL-2004 16:30:33:179] Successful parameter table load

[27-JUL-2004 16:30:33:179]  -> PARAMETER TABLE HAS THE FOLLOWING

CONTENTS <-


[27-JUL-2004 16:30:33:179]   TRACE_UNIQUE_CLIENT = ON

[27-JUL-2004 16:30:33:179]   NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES,

HOSTNAME)


[27-JUL-2004 16:30:33:179]   TRACE_DIRECTORY_CLIENT = C:\temp

[27-JUL-2004 16:30:33:179]   SQLNET.AUTHENTICATION_SERVICES = (NTS)

[27-JUL-2004 16:30:33:179]   TRACE_TIMESTAMP_CLIENT = ON

[27-JUL-2004 16:30:33:179]   TRACE_LEVEL_CLIENT = 16

[27-JUL-2004 16:30:33:179]   TRACE_FILE_CLIENT = SQLNetTrace

[27-JUL-2004 16:30:33:179]   NAMES.DEFAULT_DOMAIN = ITS.com

[27-JUL-2004 16:30:33:179] --- PARAMETER SOURCE INFORMATION ENDS ---

[27-JUL-2004 16:30:33:179] 

--- LOG CONFIGURATION INFORMATION FOLLOWS ---


[27-JUL-2004 16:30:33:179] Log stream will be

"C:\oracle\ora92\bin\sqlnet.log"


[27-JUL-2004 16:30:33:179] Log stream validation not requested

[27-JUL-2004 16:30:33:179] --- LOG CONFIGURATION INFORMATION ENDS ---




[27-JUL-2004 16:30:33:179] nigini: entry

[27-JUL-2004 16:30:33:179] nigini: Count in NI global area now: 1

[27-JUL-2004 16:30:33:179] nigini: Count in NI global area now: 1

[27-JUL-2004 16:30:33:179] nrigbi: entry

[27-JUL-2004 16:30:33:179] nrigbni: entry

[27-JUL-2004 16:30:33:179] nrigbni: Unable to get data from navigation

file tnsnav.ora


[27-JUL-2004 16:30:33:179] nrigbni: exit

[27-JUL-2004 16:30:33:179] nrigbi: exit

[27-JUL-2004 16:30:33:179] nigini: exit

[27-JUL-2004 16:30:33:179] niqname: Hst is already an NVstring.

[27-JUL-2004 16:30:33:179] niqname: Inserting CID.

[27-JUL-2004 16:30:33:179] niotns: entry

[27-JUL-2004 16:30:33:179] niotns: niotns: setting up interrupt

handler...


[27-JUL-2004 16:30:33:179] niotns: Not trying to enable dead

connection detection.


[27-JUL-2004 16:30:33:179] niotns: Calling address:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program
Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=DEV1)(USER=emp1))))


[27-JUL-2004 16:30:33:179] nscall: entry

[27-JUL-2004 16:30:33:179] nsmal: entry

[27-JUL-2004 16:30:33:179] nsmal: 164 bytes at 0x2e98638

[27-JUL-2004 16:30:33:179] nsmal: normal exit

[27-JUL-2004 16:30:33:179] nscall: connecting...

[27-JUL-2004 16:30:33:179] nladini: entry

[27-JUL-2004 16:30:33:179] nladini: exit

[27-JUL-2004 16:30:33:179] nladget: entry

[27-JUL-2004 16:30:33:179] nladget: exit

[27-JUL-2004 16:30:33:179] nsc2addr: entry

[27-JUL-2004 16:30:33:179] nlpcaini: entry

[27-JUL-2004 16:30:33:179] nlpcaini: prg = oracle

[27-JUL-2004 16:30:33:179] nlpcaini: arg[0] = oracleORCL

[27-JUL-2004 16:30:33:179] nlpcaini: arg[1] =

(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))


[27-JUL-2004 16:30:33:179] nlpcaini: exit

[27-JUL-2004 16:30:33:179] nsc2addr: normal exit

[27-JUL-2004 16:30:33:179] nsopen: entry

[27-JUL-2004 16:30:33:179] nsmal: entry

[27-JUL-2004 16:30:33:179] nsmal: 492 bytes at 0x1c0c598

[27-JUL-2004 16:30:33:179] nsmal: normal exit

[27-JUL-2004 16:30:33:179] nsopenmplx: entry

[27-JUL-2004 16:30:33:179] nsmal: entry

[27-JUL-2004 16:30:33:179] nsmal: 2348 bytes at 0x2f3d138

[27-JUL-2004 16:30:33:179] nsmal: normal exit

[27-JUL-2004 16:30:33:179] nsopenmplx: normal exit

[27-JUL-2004 16:30:33:179] nsopen: opening transport...

[27-JUL-2004 16:30:33:179] ntpcon: entry

[27-JUL-2004 16:30:33:179] ntpcon: toc = 1

[27-JUL-2004 16:30:33:179] sntpcall: entry

[27-JUL-2004 16:30:33:179] snlpcss: entry

[27-JUL-2004 16:30:33:179] sntpcall: exit

[27-JUL-2004 16:30:33:179] ntpcon: exit

[27-JUL-2004 16:30:33:179] nserror: entry

[27-JUL-2004 16:30:33:179] nserror: nsres: id=0, op=65, ns=12560,

ns2=0; nt[0]=530, nt[1]=126, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0


[27-JUL-2004 16:30:33:179] nsopen: unable to open transport

[27-JUL-2004 16:30:33:179] nsbfr: entry

[27-JUL-2004 16:30:33:179] nsbfr: normal exit

[27-JUL-2004 16:30:33:179] nsbfr: entry

[27-JUL-2004 16:30:33:179] nsbfr: normal exit

[27-JUL-2004 16:30:33:179] nsmfr: entry

[27-JUL-2004 16:30:33:179] nsmfr: 2348 bytes at 0x2f3d138

[27-JUL-2004 16:30:33:179] nsmfr: normal exit

[27-JUL-2004 16:30:33:179] nsmfr: entry

[27-JUL-2004 16:30:33:179] nsmfr: 492 bytes at 0x1c0c598

[27-JUL-2004 16:30:33:179] nsmfr: normal exit

[27-JUL-2004 16:30:33:179] nsopen: error exit

[27-JUL-2004 16:30:33:179] nsclose: entry

[27-JUL-2004 16:30:33:179] nsclose: normal exit

[27-JUL-2004 16:30:33:179] nladget: entry

[27-JUL-2004 16:30:33:179] nladget: exit

[27-JUL-2004 16:30:33:179] nsmfr: entry

[27-JUL-2004 16:30:33:179] nsmfr: 164 bytes at 0x2e98638

[27-JUL-2004 16:30:33:179] nsmfr: normal exit

[27-JUL-2004 16:30:33:179] nladtrm: entry

[27-JUL-2004 16:30:33:179] nladtrm: exit

[27-JUL-2004 16:30:33:179] nscall: error exit

[27-JUL-2004 16:30:33:179] nioqper:  error from nscall

[27-JUL-2004 16:30:33:179] nioqper:    nr err code: 0

[27-JUL-2004 16:30:33:179] nioqper:    ns main err code: 12560

[27-JUL-2004 16:30:33:179] nioqper:    ns (2)  err code: 0

[27-JUL-2004 16:30:33:179] nioqper:    nt main err code: 530

[27-JUL-2004 16:30:33:179] nioqper:    nt (2)  err code: 126

[27-JUL-2004 16:30:33:179] nioqper:    nt OS   err code: 0

[27-JUL-2004 16:30:33:179] niomapnserror: entry

[27-JUL-2004 16:30:33:179] niqme: entry

[27-JUL-2004 16:30:33:179] niqme: reporting NS-12560 error as

ORA-12560


[27-JUL-2004 16:30:33:179] niqme: exit

[27-JUL-2004 16:30:33:179] niomapnserror: returning error 12560

[27-JUL-2004 16:30:33:179] niomapnserror: exit

[27-JUL-2004 16:30:33:179] niotns: Couldn't connect, returning 12560

[27-JUL-2004 16:30:33:211] niotns: exit

[27-JUL-2004 16:30:33:211] nsbfrfl: entry

[27-JUL-2004 16:30:33:211] nsbfrfl: normal exit

[27-JUL-2004 16:30:33:211] nigtrm: Count in the NI global area is now

0


[27-JUL-2004 16:30:33:211] nrigbd: entry

[27-JUL-2004 16:30:33:211] nrigbd: exit

[27-JUL-2004 16:30:33:211] nigtrm: Count in the NL global area is now

0


====>  Can someone make any sense of this please?  Thanks!  Respond
here as I don't use the email provided.


Received on Tue Jul 27 2004 - 16:59:11 CDT












Original text of this message













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