Re: AW: not able to connect to the database
Date: Fri, 28 Nov 2008 17:01:01 +0000
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:
#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 wireshark.org 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....)