I am looking for an option to log client IPs that come to Oracle listener without enabling oracle audit or creating trigger. Is there an option for this?

Ps I am on a windows host, but I am willing to know both for Windows and Oracle Linux

  • 2
    You should already have this logged in your listener trace file Nov 17 '21 at 13:58
  • @AndrewSayer, the listener log file will do, no need to trace. Nov 17 '21 at 14:11
  • By listener trace file, I mean the log file which sits in the trace directory. Nobody has time for setting up sqlnet tracing :D Nov 17 '21 at 15:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.