OraFAQ Forum: Server Administration » TNS error only on large data, please help

Home » RDBMS Server » Server Administration » TNS error only on large data, please help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS error only on large data, please help [message #55221]

Sun, 12 January 2003 00:50

Sunil
Messages: 132
Registered: September 1999

Senior Member

Hi,

I am getting TNS :12560 and sub TNS-00102 from my client systems when I try to pull big invoice and reports which pulls little big data then this error comes.for small invoices and all other small data it is working fine.

How to switch on trace option in SQL net

The client systems are P4 with 256 MB ram ( when I search for this error it is saying due to memory, but I simulated same in our other office there with 128 MB this is working with out any problem) I supsect some proble with some .ora or configuration files. but I am not good in oracle.

The solution is running on oracle 9i (9.2.0.1.0 ) and sql net also from the same vertion. front end is VB. there is no middle layer.

This is the information I get from SQlnet.log

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:UTC.EXE)(HOST=SALES1)(USER=Sales1))))

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
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 12-JAN-2003 09:13:54
Tracing not turned on.
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: 102
TNS-00102: Keyword-Value binding operation error
nt secondary err code: 0
nt OS err code: 0

Thanks in advance, Please help me to solve this, which I am tring for last 1 month

Sunil

Report message to a moderator

Re: TNS error only on large data, please help [message #55225 is a reply to message #55221]

Sun, 12 January 2003 06:08

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

are u sure u are using beq protocol?
there must some unwanted characters in sqlnet.ora or tnsnames.ora.
Copy the SQLNET.ORA & TNSNAMES.ORA from a working machine to this "tomachinewithissues" 
and change the entries.
Define the TNS_ADMIN environment variable to point to the directory where these Oracle networking configuration files will reside. 

Ensure that this client can ping the Oracle database server by both its hostname and ip address. 

Ensure that the Oracle database server can ping this client by both its hostname and ip address.

Report message to a moderator

Re: TNS error only on large data, please help [message #55234 is a reply to message #55221]

Mon, 13 January 2003 06:27

Sunil
Messages: 132
Registered: September 1999

Senior Member

No I am not using benq I think

From all clients this is the same issue so I can't get a clean sqlnet.ora or lissner or tnsnames.ora

How I can know which protocol I am using, I think I am using TCPIP, because I am connecting through IP address, even I am not using the Service name, using direct IP
LISTENER.ORA - server

# LISTENER.ORA Network Configuration File: D:oraclenetworkadminlistener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = UTC)
(ORACLE_HOME = D:oracle)
(SID_NAME = UTC)
)
(SID_DESC =
(GLOBAL_DBNAME = OEMREP.utc.local)
(ORACLE_HOME = D:oracle)
(SID_NAME = OEMREP)
)
)

SQLNET.ORA in the server

NAMES.DEFAULT_DOMAIN = UTC.local

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

# TNSNAMES.ORA - In the server

# TNSNAMES.ORA Network Configuration File: D:oraclenetworkadmintnsnames.ora
# Generated by Oracle configuration tools.

OEMREP.UTC.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMREP.utc.local)
)
)

UTC.UTC.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = UTC)
)
)

INST1_HTTP.UTC.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA.UTC.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Client Systems

# SQLNET.ORA Network Configuration File: c:oracleora92networkadminsqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
TRACE_LEVEL_CLIENT = ADMIN
TRACE_DIRECTORY_ CLIENT = 'c:'

# LISTENER.ORA Network Configuration File: c:oracleora92NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.

TRACE_FILE_LISTENER = LISTENER.trc

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = secretary)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:oracleora92)
(PROGRAM = extproc)
)
)

TRACE_LEVEL_LISTENER = ADMIN

TRACE_DIRECTORY_LISTENER = c:
# TNSNAMES.ORA Network Configuration File: c:oracleora92NETWORKADMINtnsnames.ora
# Generated by Oracle configuration tools.

UTC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 171.12.1.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = UTC)
)
)

In Server

SQLNET.AUTHENTICATION_SERVICES= (NTS) is there but in client systems it is not there. do I need to make it null in server ?

Report message to a moderator

Re: TNS error only on large data, please help [message #55236 is a reply to message #55221]

Mon, 13 January 2003 06:36

Sunil
Messages: 132
Registered: September 1999

Senior Member

This is the trace file information I get
( only the parts with error is given here)

(4294271933) [[12-JAN-2003 16:54:44:850]] nspsend: 17 bytes to transport
(4294271933) [[12-JAN-2003 16:54:44:850]] snsbitts_ts: acquired the bit
(4294271933) [[12-JAN-2003 16:54:44:850]] nsdo: nsctxrnk=0
(4294271933) [[12-JAN-2003 16:54:44:850]] nsdo: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x3
(4294271933) [[12-JAN-2003 16:54:44:850]] snsbitts_ts: acquired the bit
(4294271933) [[12-JAN-2003 16:54:44:850]] nsdo: rank=64, nsctxrnk=0
(4294271933) [[12-JAN-2003 16:54:44:850]] nsdo: nsctx: state=8, flg=0x100420d, mvd=0
(4294271933) [[12-JAN-2003 16:54:44:900]] nsdo: gtn=127, gtc=127, ptn=10, ptc=2047
(4294271933) [[12-JAN-2003 16:54:44:900]] snsbitts_ts: acquired the bit
(4294271933) [[12-JAN-2003 16:54:44:900]] nsdo: switching to application buffer
(4294271933) [[12-JAN-2003 16:54:44:900]] nsrdr: recving a packet
(4294271933) [[12-JAN-2003 16:54:44:900]] nsprecv: reading from transport...
(4294271933) [[12-JAN-2003 16:54:44:900]] nttrd: entry
(4294271933) [[12-JAN-2003 16:54:44:900]] nttrd: socket 2308 had bytes read=15
(4294271933) [[12-JAN-2003 16:54:44:900]] nttrd: exit
(4294271933) [[12-JAN-2003 16:54:44:900]] nsprecv: 15 bytes from transport
(4294271933) [[12-JAN-2003 16:54:44:900]] nsprecv: tlen=15, plen=15, type=6
(4294271933) [[12-JAN-2003 16:54:44:900]] nsrdr: got NSPTDA packet
(4294271933) [[12-JAN-2003 16:54:44:900]] nsrdr: NSPTDA flags: 0x0
(4294271933) [[12-JAN-2003 16:54:44:900]] snsbitts_ts: acquired the bit
(4294271933) [[12-JAN-2003 16:54:44:900]] nsdo: *what=1, *bl=2037
(4294271933) [[12-JAN-2003 16:54:44:900]] snsbitts_ts: acquired the bit
(4294271933) [[12-JAN-2003 16:54:44:900]] nsdo: nsctxrnk=0
(4294271933) [[12-JAN-2003 16:54:44:900]] nioqrc: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nigini: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nigini: Count in NI global area now: 95
(4294274589) [[12-JAN-2003 16:54:44:900]] nigini: Count in NI global area now: 95
(4294274589) [[12-JAN-2003 16:54:44:900]] nigini: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] niqname: Using nnfsn2a() to build connect descriptor for (possibly remote) database.
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfun2a: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nlolgobj: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfgrne: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfgrne: Going though read path adapters
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfgrne: Switching to TNSNAMES adapter
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfgrne: Original name: UTC
(4294274589) [[12-JAN-2003 16:54:44:900]] nnftqnm: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfcagmd: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfcagmd: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfttran: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfttran: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfttran: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nnftqnm: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 171.12.1.10)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = UTC))) for name UTC
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfcraa: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfgrne: Name successfully queried
(4294274589) [[12-JAN-2003 16:54:44:900]] nnftans: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfcran: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfcran: 64 rrs requested, 1 remaining, 1 total
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfcran: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfgrne: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nlolgserv: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfggav: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfggav: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfgfrm: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nnfgfrm: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nlolgserv: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nlolgobj: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nlolfmem: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nlolfmem: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] niotns: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] niotns: niotns: setting up interrupt handler...
(4294274589) [[12-JAN-2003 16:54:44:900]] niotns: Not trying to enable dead connection detection.
(4294274589) [[12-JAN-2003 16:54:44:900]] niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=171.12.1.10)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=UTC)(CID=(PROGRAM=C:PROGRAM FILESUNITEDTRADINGUTC.EXE)(HOST=SECRETARY)(USER=Secratery))))
(4294274589) [[12-JAN-2003 16:54:44:900]] nsmal: 164 bytes at 0x33db5d0
(4294274589) [[12-JAN-2003 16:54:44:900]] nscall: connecting...
(4294274589) [[12-JAN-2003 16:54:44:900]] nladini: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nladini: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nladget: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nladget: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nttbnd2addr: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nttgetport: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nttgetport: port resolved to 1521
(4294274589) [[12-JAN-2003 16:54:44:900]] nttgetport: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nttbnd2addr: using host IP address: 171.12.1.10
(4294274589) [[12-JAN-2003 16:54:44:900]] nttbnd2addr: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nsmal: 492 bytes at 0x33de400
(4294274589) [[12-JAN-2003 16:54:44:900]] nsmal: 2348 bytes at 0xd9d2338
(4294274589) [[12-JAN-2003 16:54:44:900]] snsbitts_ts: acquired the bit
(4294274589) [[12-JAN-2003 16:54:44:900]] nsopen: opening transport...
(4294274589) [[12-JAN-2003 16:54:44:900]] nttcon: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nttcon: toc = 1
(4294274589) [[12-JAN-2003 16:54:44:900]] nttcnp: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] ntvlin: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] ntvlin: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nttcnp: Validnode Table IN use; err 0x0
(4294274589) [[12-JAN-2003 16:54:44:900]] nttcnp: exit
(4294274589) [[12-JAN-2003 16:54:44:900]] nttcni: entry
(4294274589) [[12-JAN-2003 16:54:44:900]] nttcni: trying to connect to socket 2328.
(4294274589) [[12-JAN-2003 16:54:45:890]] nttcni: trying to connect to socket 2328.
(4294274589) [[12-JAN-2003 16:54:47:980]] nttcni: trying to connect to socket 2328.
(4294274589) [[12-JAN-2003 16:54:52:100]] nttcni: trying to connect to socket 2328.
(4294274589) [[12-JAN-2003 16:55:00:120]] nttcni: trying to connect to socket 2328.
(4294274589) [[12-JAN-2003 16:55:00:120]] ntt2err: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] ntt2err: soc 2328 error - operation=1, ntresnt[[0]]=530, ntresnt[[1]]=55, ntresnt[[2]]=0
(4294274589) [[12-JAN-2003 16:55:00:120]] ntt2err: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nttcni: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nttcon: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[[0]]=530, nt[[1]]=55, nt[[2]]=0; ora[[0]]=0, ora[[1]]=0, ora[[2]]=0
(4294274589) [[12-JAN-2003 16:55:00:120]] snsbitts_ts: acquired the bit
(4294274589) [[12-JAN-2003 16:55:00:120]] nsopen: unable to open transport
(4294274589) [[12-JAN-2003 16:55:00:120]] snsbitts_ts: acquired the bit
(4294274589) [[12-JAN-2003 16:55:00:120]] snsbitts_ts: acquired the bit
(4294274589) [[12-JAN-2003 16:55:00:120]] nsmfr: 2348 bytes at 0xd9d2338
(4294274589) [[12-JAN-2003 16:55:00:120]] nsmfr: 492 bytes at 0x33de400
(4294274589) [[12-JAN-2003 16:55:00:120]] nladget: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] nladget: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nsmfr: 164 bytes at 0x33db5d0
(4294274589) [[12-JAN-2003 16:55:00:120]] nladtrm: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] nladtrm: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: error from nscall
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: nr err code: 0
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: ns main err code: 12560
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: ns (2) err code: 0
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: nt main err code: 530
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: nt (2) err code: 55
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: nt OS err code: 0
(4294274589) [[12-JAN-2003 16:55:00:120]] niomapnserror: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] niqme: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] niqme: reporting NS-12560 error as ORA-12560
(4294274589) [[12-JAN-2003 16:55:00:120]] niqme: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] niomapnserror: returning error 12560
(4294274589) [[12-JAN-2003 16:55:00:120]] niomapnserror: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] niotns: Couldn't connect, returning 12560
(4294274589) [[12-JAN-2003 16:55:00:120]] niotns: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nigtrm: Count in the NI global area is now 94
(4294274589) [[12-JAN-2003 16:55:00:120]] nigtrm: Count in the NL global area is now 94
(4294274589) [[12-JAN-2003 16:55:00:120]] nigini: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] nigini: Count in NI global area now: 95
(4294274589) [[12-JAN-2003 16:55:00:120]] nigini: Count in NI global area now: 95
(4294274589) [[12-JAN-2003 16:55:00:120]] nigini: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] niqname: Hst is already an NVstring.
(4294274589) [[12-JAN-2003 16:55:00:120]] niqname: Inserting CID.
(4294274589) [[12-JAN-2003 16:55:00:120]] niotns: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] niotns: niotns: setting up interrupt handler...
(4294274589) [[12-JAN-2003 16:55:00:120]] niotns: Not trying to enable dead connection detection.
(4294274589) [[12-JAN-2003 16:55:00:120]] niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleUTC)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=UTC)(CID=(PROGRAM=C:PROGRAM FILESUNITEDTRADINGUTC.EXE)(HOST=SECRETARY)(USER=Secratery))))
(4294274589) [[12-JAN-2003 16:55:00:120]] nsmal: 164 bytes at 0x33dd390
(4294274589) [[12-JAN-2003 16:55:00:120]] nscall: connecting...
(4294274589) [[12-JAN-2003 16:55:00:120]] nladini: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] nladini: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nladget: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] nladget: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nlpcaini: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] nlpcaini: prg = oracle
(4294274589) [[12-JAN-2003 16:55:00:120]] nlpcaini: arg[[0]] = oracleUTC
(4294274589) [[12-JAN-2003 16:55:00:120]] nlpcaini: arg[[1]] = (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
(4294274589) [[12-JAN-2003 16:55:00:120]] nlpcaini: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nsmal: 492 bytes at 0x33de2b0
(4294274589) [[12-JAN-2003 16:55:00:120]] nsmal: 2348 bytes at 0xd9d3770
(4294274589) [[12-JAN-2003 16:55:00:120]] snsbitts_ts: acquired the bit
(4294274589) [[12-JAN-2003 16:55:00:120]] nsopen: opening transport...
(4294274589) [[12-JAN-2003 16:55:00:120]] ntpcon: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] ntpcon: toc = 1
(4294274589) [[12-JAN-2003 16:55:00:120]] sntpcall: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] sntpsp: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] sntpsp: Failed to load , err = 1157
(4294274589) [[12-JAN-2003 16:55:00:120]] ntpcon: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[[0]]=102, nt[[1]]=0, nt[[2]]=0; ora[[0]]=0, ora[[1]]=0, ora[[2]]=0
(4294274589) [[12-JAN-2003 16:55:00:120]] snsbitts_ts: acquired the bit
(4294274589) [[12-JAN-2003 16:55:00:120]] nsopen: unable to open transport
(4294274589) [[12-JAN-2003 16:55:00:120]] snsbitts_ts: acquired the bit
(4294274589) [[12-JAN-2003 16:55:00:120]] snsbitts_ts: acquired the bit
(4294274589) [[12-JAN-2003 16:55:00:120]] nsmfr: 2348 bytes at 0xd9d3770
(4294274589) [[12-JAN-2003 16:55:00:120]] nsmfr: 492 bytes at 0x33de2b0
(4294274589) [[12-JAN-2003 16:55:00:120]] nladget: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] nladget: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nsmfr: 164 bytes at 0x33dd390
(4294274589) [[12-JAN-2003 16:55:00:120]] nladtrm: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] nladtrm: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: error from nscall
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: nr err code: 0
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: ns main err code: 12560
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: ns (2) err code: 0
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: nt main err code: 102
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: nt (2) err code: 0
(4294274589) [[12-JAN-2003 16:55:00:120]] nioqper: nt OS err code: 0
(4294274589) [[12-JAN-2003 16:55:00:120]] niomapnserror: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] niqme: entry
(4294274589) [[12-JAN-2003 16:55:00:120]] niqme: reporting NS-12560 error as ORA-12560
(4294274589) [[12-JAN-2003 16:55:00:120]] niqme: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] niomapnserror: returning error 12560
(4294274589) [[12-JAN-2003 16:55:00:120]] niomapnserror: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] niotns: Couldn't connect, returning 12560
(4294274589) [[12-JAN-2003 16:55:00:120]] niotns: exit
(4294274589) [[12-JAN-2003 16:55:00:120]] nigtrm: Count in the NI global area is now 94
(4294274589) [[12-JAN-2003 16:55:00:120]] nigtrm: Count in the NL global area is now 94
(4294274665) [[12-JAN-2003 16:55:01:550]] nigini: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nigini: Count in NI global area now: 95
(4294274665) [[12-JAN-2003 16:55:01:550]] nigini: Count in NI global area now: 95
(4294274665) [[12-JAN-2003 16:55:01:550]] nigini: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] niqname: Using nnfsn2a() to build connect descriptor for (possibly remote) database.
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfun2a: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nlolgobj: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfgrne: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfgrne: Going though read path adapters
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfgrne: Switching to TNSNAMES adapter
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfgrne: Original name: UTC
(4294274665) [[12-JAN-2003 16:55:01:550]] nnftqnm: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfcagmd: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfcagmd: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfttran: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfttran: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfttran: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nnftqnm: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 171.12.1.10)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = UTC))) for name UTC
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfcraa: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfgrne: Name successfully queried
(4294274665) [[12-JAN-2003 16:55:01:550]] nnftans: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfcran: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfcran: 64 rrs requested, 1 remaining, 1 total
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfcran: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfgrne: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nlolgserv: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfggav: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfggav: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfgfrm: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nnfgfrm: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nlolgserv: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nlolgobj: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nlolfmem: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nlolfmem: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] niotns: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] niotns: niotns: setting up interrupt handler...
(4294274665) [[12-JAN-2003 16:55:01:550]] niotns: Not trying to enable dead connection detection.
(4294274665) [[12-JAN-2003 16:55:01:550]] niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=171.12.1.10)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=UTC)(CID=(PROGRAM=C:PROGRAM FILESUNITEDTRADINGUTC.EXE)(HOST=SECRETARY)(USER=Secratery))))
(4294274665) [[12-JAN-2003 16:55:01:550]] nsmal: 164 bytes at 0x33dd3b0
(4294274665) [[12-JAN-2003 16:55:01:550]] nscall: connecting...
(4294274665) [[12-JAN-2003 16:55:01:550]] nladini: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nladini: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nladget: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nladget: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nttbnd2addr: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nttgetport: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nttgetport: port resolved to 1521
(4294274665) [[12-JAN-2003 16:55:01:550]] nttgetport: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nttbnd2addr: using host IP address: 171.12.1.10
(4294274665) [[12-JAN-2003 16:55:01:550]] nttbnd2addr: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nsmal: 492 bytes at 0x33de3a0
(4294274665) [[12-JAN-2003 16:55:01:550]] nsmal: 2348 bytes at 0xd9d3770
(4294274665) [[12-JAN-2003 16:55:01:550]] snsbitts_ts: acquired the bit
(4294274665) [[12-JAN-2003 16:55:01:550]] nsopen: opening transport...
(4294274665) [[12-JAN-2003 16:55:01:550]] nttcon: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nttcon: toc = 1
(4294274665) [[12-JAN-2003 16:55:01:550]] nttcnp: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] ntvlin: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] ntvlin: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nttcnp: Validnode Table IN use; err 0x0
(4294274665) [[12-JAN-2003 16:55:01:550]] nttcnp: exit
(4294274665) [[12-JAN-2003 16:55:01:550]] nttcni: entry
(4294274665) [[12-JAN-2003 16:55:01:550]] nttcni: trying to connect to socket 2344.
(4294274665) [[12-JAN-2003 16:55:02:540]] nttcni: trying to connect to socket 2344.
(4294274665) [[12-JAN-2003 16:55:04:510]] nttcni: trying to connect to socket 2344.
(4294274665) [[12-JAN-2003 16:55:08:520]] nttcni: trying to connect to socket 2344.
(4294659741) [[12-JAN-2003 16:55:09:790]] nioqsn: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nioqrc: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: cid=0, opcode=84, *bl=0, *what=1, uflgs=0x20, cflgs=0x3
(4294659741) [[12-JAN-2003 16:55:09:790]] snsbitts_ts: acquired the bit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: rank=64, nsctxrnk=0
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: nsctx: state=8, flg=0x100420d, mvd=0
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: gtn=127, gtc=127, ptn=10, ptc=2047
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdofls: DATA flags: 0x0
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdofls: sending NSPTDA packet
(4294659741) [[12-JAN-2003 16:55:09:790]] nspsend: plen=13, type=6
(4294659741) [[12-JAN-2003 16:55:09:790]] nttwr: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nttwr: socket 708 had bytes written=13
(4294659741) [[12-JAN-2003 16:55:09:790]] nttwr: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] nspsend: 13 bytes to transport
(4294659741) [[12-JAN-2003 16:55:09:790]] snsbitts_ts: acquired the bit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: nsctxrnk=0
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x3
(4294659741) [[12-JAN-2003 16:55:09:790]] snsbitts_ts: acquired the bit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: rank=64, nsctxrnk=0
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: nsctx: state=8, flg=0x100420d, mvd=0
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: gtn=127, gtc=127, ptn=10, ptc=2047
(4294659741) [[12-JAN-2003 16:55:09:790]] snsbitts_ts: acquired the bit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: switching to application buffer
(4294659741) [[12-JAN-2003 16:55:09:790]] nsrdr: recving a packet
(4294659741) [[12-JAN-2003 16:55:09:790]] nsprecv: reading from transport...
(4294659741) [[12-JAN-2003 16:55:09:790]] nttrd: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nttrd: socket 708 had bytes read=15
(4294659741) [[12-JAN-2003 16:55:09:790]] nttrd: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsprecv: 15 bytes from transport
(4294659741) [[12-JAN-2003 16:55:09:790]] nsprecv: tlen=15, plen=15, type=6
(4294659741) [[12-JAN-2003 16:55:09:790]] nsrdr: got NSPTDA packet
(4294659741) [[12-JAN-2003 16:55:09:790]] nsrdr: NSPTDA flags: 0x0
(4294659741) [[12-JAN-2003 16:55:09:790]] snsbitts_ts: acquired the bit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: *what=1, *bl=2037
(4294659741) [[12-JAN-2003 16:55:09:790]] snsbitts_ts: acquired the bit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: nsctxrnk=0
(4294659741) [[12-JAN-2003 16:55:09:790]] nioqrc: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] nioqds: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nioqds: disconnecting...
(4294659741) [[12-JAN-2003 16:55:09:790]] nstimarmed: no timer allocated
(4294659741) [[12-JAN-2003 16:55:09:790]] snsbitts_ts: acquired the bit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: cid=0, opcode=66, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
(4294659741) [[12-JAN-2003 16:55:09:790]] snsbitts_ts: acquired the bit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: rank=64, nsctxrnk=0
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: nsctx: state=8, flg=0x1004209, mvd=0
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: cid=0, opcode=67, *bl=0, *what=1, uflgs=0x0, cflgs=0x1
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: nsctx: state=8, flg=0x1004209, mvd=0
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: gtn=127, gtc=127, ptn=10, ptc=2047
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdofls: DATA flags: 0x40
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdofls: sending NSPTDA packet
(4294659741) [[12-JAN-2003 16:55:09:790]] nspsend: plen=10, type=6
(4294659741) [[12-JAN-2003 16:55:09:790]] nttwr: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nttwr: socket 708 had bytes written=10
(4294659741) [[12-JAN-2003 16:55:09:790]] nttwr: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] nspsend: 10 bytes to transport
(4294659741) [[12-JAN-2003 16:55:09:790]] snsbitts_ts: acquired the bit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsdo: nsctxrnk=0
(4294659741) [[12-JAN-2003 16:55:09:790]] nsclose: closing transport
(4294659741) [[12-JAN-2003 16:55:09:790]] nttdisc: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nttdisc: Closed socket 708
(4294659741) [[12-JAN-2003 16:55:09:790]] nttdisc: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] snsbitts_ts: acquired the bit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsclose: global context check-out (from slot 0) complete
(4294659741) [[12-JAN-2003 16:55:09:790]] nadisc: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nacomtm: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nacompd: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nacompd: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] nacompd: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nacompd: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] nacomtm: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] nas_dis: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nas_dis: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] nau_dis: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nau_dis: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] naeetrm: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] naeetrm: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] naectrm: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] naectrm: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] nagbltrm: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nagbltrm: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] nadisc: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] snsbitts_ts: acquired the bit
(4294659741) [[12-JAN-2003 16:55:09:790]] snsbitts_ts: acquired the bit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsmfr: 2348 bytes at 0x7dfc800
(4294659741) [[12-JAN-2003 16:55:09:790]] nsmfr: 204 bytes at 0x3338080
(4294659741) [[12-JAN-2003 16:55:09:790]] nsmfr: 164 bytes at 0x3337620
(4294659741) [[12-JAN-2003 16:55:09:790]] nladtrm: entry
(4294659741) [[12-JAN-2003 16:55:09:790]] nladtrm: exit
(4294659741) [[12-JAN-2003 16:55:09:790]] nsmfr: 492 bytes at 0x3338ae0
(4294659741) [[12-JAN-2003 16:55:09:790]] nioqds: exit

Thanks

Sunil

Report message to a moderator

Re: TNS error only on large data, please help [message #55238 is a reply to message #55221]

Mon, 13 January 2003 06:50

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

[i]
SQLNET.ORA in the server

NAMES.DEFAULT_DOMAIN = UTC.local

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

[/i]
comment all these three in serverside.
you are using default_domain.
is that a valid one.
try to comment it off
reload the listner.ora
try again

Report message to a moderator

Previous Topic:	Re: download free ocp dumps,papers,ocp kits...
Next Topic:	ORACLE 9I INSTALLATION ON LINUX

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 28 07:49:03 CST 2024