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 | |||||||||||||||||||
Find a specified string of text. Open the Find dialog The options in the Find dialog are:
| |||||||||||||||||||
Save the file. Save File As Dialog Note: Use this command to save the file on the Spotlight client. This command cannot be used to save (update) the file on the database server. | |||||||||||||||||||
Close the file.
|
The Alert Log display
Display | Description |
---|---|
Date |
The time at which 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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center