Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

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

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click Configuration & Memory | Alert Log.

ORA-16000 on click 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:

Option Description
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

Display Description

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.

  1. Find background_dump_dest on the standby database
  2. 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';
  3. Ensure the directory has been replicated to the standby (this may take some time depending on your data guard setup)
  4. Click the Alert Log tab on the standby database


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating