Re: Database connection problem from client

Doggus wrote:
> 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.

[oracle_at_csdb01 oracle]$ oerr ora 126
00126, 00000, "connection refused; invalid duplicity"

// *Cause:  The DUPLICITY in the CONNECT_DATA of the TNS address
//          DESCRIPTION is not correct or is not supported.
// *Action: Correct the DUPLICITY specified in the TNS address.

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

That's odd: you try to connect to a local ORCL instance, using java (jrew.exe), and the BEQueth protocol.

>
> 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.

Inline...
Post C:\oracle\ora92\network\admin\tnsnames.ora

-- 

Regards,
Frank van Bortel