SQl net tracing [message #331164] |
Wed, 02 July 2008 08:06 |
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 |
|
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
|
|
|