The Alert Log page, which shows the contents of the alert log file for Oracle databases, contains a chronological list of messages and errors that have occurred for the database.
To open the Alert Log page
Click Configuration & Memory | Alert Log.
Actions on the Alert Log & Trace Files opened from the Alert Log
| Action | Description |
|---|---|
 |
Go to the top of the file |
 |
Page up |
 |
Page down |
 |
Go to the end of the file |
 |
Close the file.
|
The Alert Log display
| Display | Description |
|---|---|
| Date |
The time at which the message or error occurred. |
| Instance | The instance within the Oracle RAC cluster where the message or error occurred. |
|
File Contents |
The text of the Oracle message or error. Additional information is displayed in colored or hyperlink text. |
| File Contents - Blue Hyperlink Text |
Click to view the Oracle trace file generated for the specified message or error. |
| File Contents - Red Text |
Oracle error. If there is a trace file associated with the error, click the hyperlink text to view the file. Otherwise, consult your Oracle documentation or the Oracle Web site for more information. |
|
File Contents - Green Text |
Log entry. The location of the log entry where you can look for more information. |
The Trace File display
A trace file contains text generated by specified errors or messages in the Oracle database.
If you see ORA-16000 on clicking the Alert Log tab on a standby database then create the directory object on the primary and replicate it to the standby.
