Home » RDBMS Server » Server Administration » SQl net tracing (,Windows 2003)
SQl net tracing [message #331164] Wed, 02 July 2008 08:06 Go to next message
Messages: 165
Registered: June 2008
Senior Member
Hi all,

I am trying to find out which user is connecting from one of the application server and what connect string he is using to connect to the database. In the sqlnet.log, it only shows the TNS connection refused error with the db name as ORCL.
I turned the sqlnet tracing on in the sqlnet.ora but still I dont see the username and the connect string that is trying to connect to the database.(just to make sure if they are using the correct credentials and the connect string).

Below are the parameters I added in sqlnet.ora(in my pc,just to verify):


THanks for any help.
Re: SQl net tracing [message #331173 is a reply to message #331164] Wed, 02 July 2008 08:21 Go to previous message
Michel Cadot
Messages: 64967
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is in listener.log or v$session for most part.
First have a look at these and come back if something is missing for you. In the latter case, explain in details what is missing.


Previous Topic: Object creation should pop up a mail
Next Topic: locked_object (merged)
Goto Forum:

Current Time: Thu Jun 29 06:00:06 CDT 2017

Total time taken to generate the page: 0.12831 seconds