Alert Log Page
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
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
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.
- To view the contents of a trace file, click a hyperlink in the Alert Log.
- The trace file opens in a separate tab control in the Alert Log page.
- The trace file is formatted as per the Alert Log with hyperlinks and highlighted text.
- The name of the trace file is shown to the left of the Alert Log toolbar, and in the tab control.
- Use the tab controls to switch between the Alert Log and open trace files.
- To close a trace file, select the trace file and click Close .
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.
- Find background_dump_dest on the standby database
- Create two directories on the primary database (with and without the trailing slash) for example:
- Create directory QUEST_SOO_BDUMP_DIR_STDBY_1 as '/u01/app/oracle/diag/rdbms/spotl105/spotl105/trace/';
- Create directory QUEST_SOO_BDUMP_DIR_STDBY_2 as '/u01/app/oracle/diag/rdbms/spotl105/spotl105/trace';
- Ensure the directory has been replicated to the standby (this may take some time depending on your data guard setup)
- Click the Alert Log tab on the standby database