Where is alert log in oracle 10g

Avnish Sharma Avnish Sharma 1. After AUDIT is set up: will the Alert Log show the information as to who created or dropped tables and also what tables got created or dropped? Add a comment. Active Oldest Votes. Database opened. Improve this answer. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Text formatted alert. To view the text-only alert. With 11g ,Oracle provides a way to look the alert log file from the database also. We can find the alert log location using below also. Go to the background dump directory to run these unix commands Date and errors in alert. Here are the steps required on How to easily find the Oracle database startup and shutdown time using sqlplus step 1 Create a database directory object.

With the movement towards server consolidation you may have dozens of Oracle instances omn your server and the UNIX find command is one way to find all of the alert logs without querying inside each database. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise.

You can take a look. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. Alert Log File.