Home » RDBMS Server » Networking and Gateways » looking help with TNS 12540
looking help with TNS 12540 [message #67179] Mon, 19 January 2004 16:53 Go to next message
Sharon
Messages: 10
Registered: February 2001
Junior Member
it seems simple problem,Icoudnt connect  to startup DB(connect / as sysdba) on Winxp,following error message appears:TNS 12540 internal limit restriction exceeded. Can anyone tell me whats wrong and what should I do to solve it.

Thanks in advance. Here is my tracing file:

19-JAN-2004 21:41:12:140]] nigini: entry
[[19-JAN-2004 21:41:12:140]] nigini: Count in NI global area now: 1
[[19-JAN-2004 21:41:12:140]] nigini: Count in NI global area now: 1
[[19-JAN-2004 21:41:12:140]] nrigbi: entry
[[19-JAN-2004 21:41:12:140]] nrigbni: entry
[[19-JAN-2004 21:41:12:140]] nrigbni: Unable to get data from navigation file tnsnav.ora
[[19-JAN-2004 21:41:12:140]] nrigbni: exit
[[19-JAN-2004 21:41:12:140]] nrigbi: exit
[[19-JAN-2004 21:41:12:140]] nigini: exit
[[19-JAN-2004 21:41:12:140]] niqname: Hst is already an NVstring.
[[19-JAN-2004 21:41:12:140]] niqname: Inserting CID.
[[19-JAN-2004 21:41:12:140]] niotns: entry
[[19-JAN-2004 21:41:12:140]] niotns: niotns: setting up interrupt handler...
[[19-JAN-2004 21:41:12:140]] niotns: Not trying to enable dead connection detection.
[[19-JAN-2004 21:41:12:140]] niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclecrdb)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=crdb)(CID=(PROGRAM=D:OraHomebinsqlplusw.exe)(HOST=SHARON)(USER=Haiyan?Guo))))
[[19-JAN-2004 21:41:12:140]] nscall: entry
[[19-JAN-2004 21:41:12:140]] nsmal: entry
[[19-JAN-2004 21:41:12:140]] nsmal: 164 bytes at 0xe8e300
[[19-JAN-2004 21:41:12:140]] nsmal: normal exit
[[19-JAN-2004 21:41:12:140]] nscall: connecting...
[[19-JAN-2004 21:41:12:140]] nladini: entry
[[19-JAN-2004 21:41:12:140]] nladini: exit
[[19-JAN-2004 21:41:12:140]] nladget: entry
[[19-JAN-2004 21:41:12:140]] nladget: exit
[[19-JAN-2004 21:41:12:140]] nsc2addr: entry
[[19-JAN-2004 21:41:12:140]] nlpcaini: entry
[[19-JAN-2004 21:41:12:140]] nlpcaini: prg = oracle
[[19-JAN-2004 21:41:12:140]] nlpcaini: arg[[0]] = oraclecrdb
[[19-JAN-2004 21:41:12:140]] nlpcaini: arg[[1]] = (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[[19-JAN-2004 21:41:12:140]] nlpcaini: exit
[[19-JAN-2004 21:41:12:140]] nsc2addr: normal exit
[[19-JAN-2004 21:41:12:140]] nsopen: entry
[[19-JAN-2004 21:41:12:140]] nsmal: entry
[[19-JAN-2004 21:41:12:140]] nsmal: 492 bytes at 0xe92428
[[19-JAN-2004 21:41:12:140]] nsmal: normal exit
[[19-JAN-2004 21:41:12:140]] nsopenmplx: entry
[[19-JAN-2004 21:41:12:140]] nsmal: entry
[[19-JAN-2004 21:41:12:140]] nsmal: 2348 bytes at 0xec7008
[[19-JAN-2004 21:41:12:140]] nsmal: normal exit
[[19-JAN-2004 21:41:12:140]] nsopenmplx: normal exit
[[19-JAN-2004 21:41:12:140]] nsopen: opening transport...
[[19-JAN-2004 21:41:12:140]] ntpcon: entry
[[19-JAN-2004 21:41:12:140]] ntpcon: toc = 1
[[19-JAN-2004 21:41:12:140]] sntpcall: entry
[[19-JAN-2004 21:41:12:140]] snlpcss: entry
[[19-JAN-2004 21:41:12:140]] sntpcall: exit
[[19-JAN-2004 21:41:12:140]] ntpcon: exit
[[19-JAN-2004 21:41:12:140]] nserror: entry
[[19-JAN-2004 21:41:12:140]] nserror: nsres: id=0, op=65, ns=12540, ns2=12560; nt[[0]]=510, nt[[1]]=8, nt[[2]]=0; ora[[0]]=0, ora[[1]]=0, ora[[2]]=0
[[19-JAN-2004 21:41:12:140]] nsopen: unable to open transport
[[19-JAN-2004 21:41:12:140]] nsbfr: entry
[[19-JAN-2004 21:41:12:140]] nsbfr: normal exit
[[19-JAN-2004 21:41:12:140]] nsbfr: entry
[[19-JAN-2004 21:41:12:140]] nsbfr: normal exit
[[19-JAN-2004 21:41:12:140]] nsmfr: entry
[[19-JAN-2004 21:41:12:140]] nsmfr: 2348 bytes at 0xec7008
[[19-JAN-2004 21:41:12:140]] nsmfr: normal exit
[[19-JAN-2004 21:41:12:140]] nsmfr: entry
[[19-JAN-2004 21:41:12:140]] nsmfr: 492 bytes at 0xe92428
[[19-JAN-2004 21:41:12:140]] nsmfr: normal exit
[[19-JAN-2004 21:41:12:140]] nsopen: error exit
[[19-JAN-2004 21:41:12:140]] nsclose: entry
[[19-JAN-2004 21:41:12:140]] nsclose: normal exit
[[19-JAN-2004 21:41:12:140]] nladget: entry
[[19-JAN-2004 21:41:12:140]] nladget: exit
[[19-JAN-2004 21:41:12:140]] nsmfr: entry
[[19-JAN-2004 21:41:12:140]] nsmfr: 164 bytes at 0xe8e300
[[19-JAN-2004 21:41:12:140]] nsmfr: normal exit
[[19-JAN-2004 21:41:12:140]] nladtrm: entry
[[19-JAN-2004 21:41:12:140]] nladtrm: exit
[[19-JAN-2004 21:41:12:140]] nscall: error exit
[[19-JAN-2004 21:41:12:140]] nioqper:  error from nscall
[[19-JAN-2004 21:41:12:140]] nioqper:    nr err code: 0
[[19-JAN-2004 21:41:12:140]] nioqper:    ns main err code: 12540
[[19-JAN-2004 21:41:12:140]] nioqper:    ns (2)  err code: 12560
[[19-JAN-2004 21:41:12:140]] nioqper:    nt main err code: 510
[[19-JAN-2004 21:41:12:140]] nioqper:    nt (2)  err code: 8
[[19-JAN-2004 21:41:12:140]] nioqper:    nt OS   err code: 0
[[19-JAN-2004 21:41:12:140]] niomapnserror: entry
[[19-JAN-2004 21:41:12:140]] niqme: entry
[[19-JAN-2004 21:41:12:140]] niqme: reporting NS-12540 error as ORA-12540
[[19-JAN-2004 21:41:12:140]] niqme: exit
[[19-JAN-2004 21:41:12:140]] niomapnserror: returning error 12540
[[19-JAN-2004 21:41:12:140]] niomapnserror: exit
[[19-JAN-2004 21:41:12:140]] niotns: Couldn't connect, returning 12540
[[19-JAN-2004 21:41:12:140]] niotns: exit
[[19-JAN-2004 21:41:12:140]] nsbfrfl: entry
[[19-JAN-2004 21:41:12:140]] nsbfrfl: normal exit
[[19-JAN-2004 21:41:12:140]] nigtrm: Count in the NI global area is now 0
[[19-JAN-2004 21:41:12:140]] nrigbd: entry
[[19-JAN-2004 21:41:12:140]] nrigbd: exit
[[19-JAN-2004 21:41:12:140]] nigtrm: Count in the NL global area is now 0

Report message to a moderator

Re: looking help with TNS 12540 [message #67182 is a reply to message #67179] Wed, 21 January 2004 02:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try to reduce your SGA

Report message to a moderator

Re: looking help with TNS 12540 [message #67188 is a reply to message #67182] Fri, 23 January 2004 15:26 Go to previous messageGo to next message
Sharon
Messages: 10
Registered: February 2001
Junior Member
Thanks Mahesh for your reply.I tried it, but didn't work,and there is also another problem,anyone can tell me what's difference when I use service to startup DB on winxp and use commands to startup the DB(sqlplus,connect / as sysdba)?
Your reply would be appreciated.

Sharon

Report message to a moderator

Re: looking help with TNS 12540 [message #124612 is a reply to message #67188] Mon, 20 June 2005 08:45 Go to previous message
goach
Messages: 1
Registered: June 2005
Junior Member
I had the same problem when installing Oracle 9i on Windows XP.
My experience was that hostname was not resolved to expected IP-Adress (192.168.0.1) but to ppp-Adapter's address (XP-Problem?).
Deactivating ppp-Adapter helped - try "ping <yourhostname>" afterwards then connect to DB.
Smile good luck

Report message to a moderator

Previous Topic: TNS Listener drops after every login.
Next Topic: how to start sqlplus instantclient
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 09 17:00:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.