Re: AW: not able to connect to the database

Hi Drumil,

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

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

TRACE_UNIQUE_CLIENT=true
#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]

or
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....)

Regards,
Turloch
--
http://www.freelists.org/webpage/oracle-l

Other related posts: