Re: AW: not able to connect to the database
Date: Fri, 28 Nov 2008 17:01:01 +0000
Message-ID: <8c8b716a0811280901x2ca97819mfecc133988a00930@mail.gmail.com>
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-lReceived on Fri Nov 28 2008 - 11:01:01 CST