Re: AW: not able to connect to the database

From: Turloch O'Tierney <>
Date: Fri, 28 Nov 2008 17:01:01 +0000
Message-ID: <>

Hi Drumil,

1/What is the client?
2/Was it working before?

[They gather lots of informationwatch you do not fill up your disk...]
1/Turn sqlnet tracing on:
in sqlnet.ora

#ie have a seperate trace file for each session TRACE_LEVEL_CLIENT = 16
#16 is the highest trace level (biggest trace files) 0 - lowest TRACE_DIRECTORY_CLIENT = d:/totierne/admin/dump #where to put the trace file not that you can also trace on the server side ...

[SERVER tracing is also available by replacing CLIENT with SERVER]
[could do an alter session set sqltrace in a onlogon trigger]

2/ trace via TCP packet grabber.

And basically look for an ORA error (ORA-nnn NO Data Found is often a normal error to get on the end of a select rowset....)


Received on Fri Nov 28 2008 - 11:01:01 CST

Original text of this message