Home » RDBMS Server » Networking and Gateways » Logging the remote connection Information
Logging the remote connection Information [message #67480] Thu, 19 August 2004 03:26 Go to next message
RIZWAN USMAN
Messages: 1
Registered: July 2002
Junior Member
Hi All,

  I am new to oracle server 8i administration. I want to know that how can log the remote connections information to oracle server runing on my system. The oracle user name can be the same from two or more machines. I want to log the IP address , User Name and the queries executed by the user using either SQL Plus or any other application /program ?

Is this possible? if yes then how , if know what can be the other solution for this problem - loggin the remote connection information with IP address.

Report message to a moderator

Re: Logging the remote connection Information [message #67485 is a reply to message #67480] Thu, 19 August 2004 11:17 Go to previous message
MacDuck
Messages: 4
Registered: August 2004
Junior Member
Doesn't listener log contain enough information 4U about all incoming connections?

U can write script which will collect and sort needed parameters.

Report message to a moderator

Previous Topic: Could Oracle be the worst RDBMS ever - ORA-12154?
Next Topic: ORA-03121 error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 01 04:38:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.