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.
ORA-16000 on click Alert Log?
Actions on the Alert Log & Trace Files opened from the Alert Log
 |
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:
| Text to find |
Enter or paste in the text you want to find. |
| Match case |
When selected, match the case of the text exactly. For example a search for text AbC will NOT find the text abc. |
| Up |
Search only upwards through the file from the current location. |
| Down |
Search only downwards through the file from the current location. |
| From Cursor |
Search for the specified text from the current location of the cursor. |
| Entire File |
Search the entire file for the specified text. |
| Find Next |
Find the next occurrence of the text. |
| Search Period |
Enter how far you want to search within the file for the text you want to find. (The direction of the search is specified by your other choices.) | |
 |
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
| 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 .
ORA-16000 on click Alert Log?
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
Related Topics
Spotlight on Oracle Drilldowns
