Spotlight on Oracle 10.9 - Getting Started Guide

Select the Spotlight on Oracle connection in the Spotlight Browser.
Click SQL & Application Workload | Analyze Trace | Trace Files.
Select a Trace File.
If the trace file has not been analyzed yet, right-click its row in the Trace File Details table and select Analyze Trace File. Analyze Trace Settings Dialog
Click Raw Trace File

ORA-16000 on click Raw Trace File?

Actions on the Trace File

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.

Disabled for the Configuration & Memory | Alert Log Page.
Disabled for the Configuration & Memory | OEM Status Page.
Disabled for the Configuration & Memory | OEM Logs Viewer.
Disabled for the Analyze Trace | Raw Trace File Page.
Disabled for the Configuration & Memory | Alert Log Page.
Enabled only for trace files opened from the Alert Log.

The Raw Trace File display

Display	Description
File Contents	The text of the Oracle message or error. Additional information is displayed in colored or hyperlink text.
File Contents - Blue Hyperlink Text	The start of a parse of SQL code. Click on the blue hyperlinked text to open the Navigation dialog to navigate the current parse of SQL code. Start - Click to move the cursor to the initial command of the parse. End - Click to move the cursor to the closing command of the parse. Select from Exec, Binds, Fetch, Start, Parse and Error and click Previous or Next to move the cursor to the nearest selected command in the parse.
File Contents - Red Text	Oracle error.
File Contents - Green Text	Stages of processing the SQL code.

ORA-16000 on click Raw Trace File?

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 Raw Trace File tab on the standby database

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

Spotlight on Oracle 10.9 - Getting Started Guide

Raw Trace File Page