Home » RDBMS Server » Networking and Gateways » Assistance needed...
Assistance needed... [message #66150] Tue, 18 December 2001 20:37 Go to next message
Mihail
Messages: 1
Registered: December 2001
Junior Member
I am getting this error message when I try to connect from a client to an orac database ?
For the oracle server I use a translation from 153.56.126.3 (real address) ->10.11.20.132(nat-ed address. I am not an Oracle person.....
Any ideas ?

--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is "f:logtt.log.trc"
New trace level is 4
--- TRACE CONFIGURATION INFORMATION ENDS ---
nigini: Count in NI global area now: 1
nigini: Count in NI global area now: 1
nrigbni: Unable to get data from navigation file tnsnav.ora
nncpmlf_make_local_addrfile: construction of local names file failed
nncpmsf_make_sys_addrfile: system names file is F:OracleOra81networkadmintnsnames.ora
niotns: niotns: setting up interrupt handler...
niotns: Not trying to enable dead connection detection.
niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.20.132)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=newone)(CID=(PROGRAM=F:OracleOra81BINSQLPLUSW.EXE)(HOST=SSG3)(USER=Administrator))))
nscall: connecting...

nttbnd2addr: port resolved to 1521
nttbnd2addr: using host IP address: 10.11.20.132
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 208.
nsopen: transport is open
nsnainit: inf->nsinfflg[[0]]: 0x1 inf->nsinfflg[[1]]: 0x1
nsopen: global context check-in (to slot 0) complete
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nscon: got NSPTRD packet
nscall: redirected
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 0) complete
nscall: connecting...
nttbnd2addr: port resolved to 1043

nttbnd2addr: using host IP address: 156.51.126.3
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 220.
ntt2err: soc 220 error - operation=1, ntresnt[[0]]=505, ntresnt[[1]]=60, ntresnt[[2]]=0
nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[[0]]=505, nt[[1]]=60, nt[[2]]=0
nsopen: unable to open transport
nioqper: error from nscall
nioqper: nr err code: 0
nioqper: ns main err code: 12535
nioqper: ns (2) err code: 12560
nioqper: nt main err code: 505
nioqper: nt (2) err code: 60
nioqper: nt OS err code: 0
niqme: reporting ns (2) error: (12535) as rdbms err (12535)
niotns: Couldn't connect, returning 12535
nigtrm: Count in the NI global area is now 0
nigtrm: Count in the NL global area is now 0

----------------------------------------------------------------------
Re: Assistance needed... [message #66158 is a reply to message #66150] Wed, 26 December 2001 21:17 Go to previous message
Gloria Zhao
Messages: 11
Registered: October 2001
Junior Member
Hi,

Ensure that you can ping and tnsping both addresses. If you can, contact your DBA to do the following...

> niotns: Couldn't connect, returning 12535

oerr ora 12535:
12535, 00000, "TNS:operation timed out"
// *Cause: The requested connection could not be completed within the timeout
// period specified by the CONNECT_TIMEOUT parameter in listener.ora. This
// error arises from the tnslsnr.
// *Action: Either reconfigure CONNECT_TIMEOUT to be 0, which means
// wait indefinitely, or reconfigure CONNECT_TIMEOUT to be some higher
// value. Or, if the timeout is unacceptably long, turn on tracing
// for further information.


Best regards

Frank Naude

----------------------------------------------------------------------
Previous Topic: can i change the machine name after installation ?
Next Topic: Slow data accessing
Goto Forum:
  


Current Time: Wed Feb 28 12:54:11 CST 2024