Re: AW: not able to connect to the database
- From: "Turloch O'Tierney" <turloch@xxxxxxxxx>
- To: drumilnarayan@xxxxxxxxx
- Date: Fri, 28 Nov 2008 17:01:01 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
