Home » RDBMS Server » Server Administration » SQl net tracing (10.2.0.1,Windows 2003)
SQl net tracing [message #331164] Wed, 02 July 2008 08:06 Go to next message
sant_new
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):


LOG_DIRECTORY_CLIENT=c:\oracle\product
LOG_FILE_CLIENT=client_log
TRACE_DIRECTORY_CLIENT=c:\oracle\product
TRACE_FILE_CLIENT=client_trace
TRACE_FILELEN_CLIENT=10000
TRACE_FILENO_CLIENT=5
TRACE_LEVEL_CLIENT=16
TRACE_TIMESTAMP_CLIENT=TRUE
TRACE_UNIQUE_CLIENT=TRUE

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: 68707
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.

Regards
Michel


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


Current Time: Thu Nov 07 16:04:58 CST 2024