Oracle 48

A fresh view on Oracle

Rotating ssl_request_log

Have a look at my Whitehorses Blog where I will explain in more detail.

Final conclusion (on one line):

CustomLog "|<midtier>\Apache\Apache\bin\rotatelogs logs\ssl_request_log 43200" "%t %... %b"

Happy consulting!

Temporary stop listener to log with ‘set log_status’

When moving/deleting the listener.log, I used to stop and start the listener and move/delete the listener in between the actions.
This method has a big inconvenience: users can not connect to the database for a few seconds…
What I never knew was that the listener could be told to stop and start logging and take the appropriate action in between.

[Read the rest of this entry...]