Chat now with support
Chat with Support

Spotlight on Oracle 10.5 - 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 RAC 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

Close the file.

  • Disabled for the Configuration & Memory | Alert Log Page.
  • Enabled only for trace files opened from the Alert Log.

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.

  • 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