Each database has an alert log file, which contains a chronological(sequential order in which they occurred) log of database messages and errors. Oracle will automatically create a new alert log file whenever the old one is deleted. The alert log includes the following errors and log messages: All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60). Administrative operations such as DDL statements and the SQL*Plus commands STARTUP, SHUTDOWN, ARCHIVE LOG, and RECOVER. Several messages and errors relating to the functions of shared server and dispatcher processes. Errors during the automatic refresh of a materialized view Find the Location of alert log file in Oracle To view alert log, first you need to find it’s location using select command. SQL> SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace'; VALUE -------------------------------------------------------------------------------- /u01/app/oracle/diag/rdbms/orcl/orcl/trace To vi
Comments
Post a Comment