OracleDiagnostics

Review problems and incidents (ADRCI)

ADRCI commands for critical errors like ORA-00600 and ORA-07445, and for packaging an incident to send to Oracle Support.

Not yet verified. How scripts are tested

1-- From the OS prompt2adrci3SHOW HOMES4SET HOMEPATH diag/rdbms/<db_unique_name>/<instance_name>5SHOW PROBLEM6SHOW INCIDENT7SHOW INCIDENT -mode DETAIL -p "incident_id=<id>"8IPS PACK INCIDENT <id> IN /tmp

Run these at the operating system prompt.

Open in denrepoRelated tool: Oracle error lookup

Helps with

• ORA-00600: internal error code, arguments: [%s], [%s], ...

More Oracle scripts: Diagnostics

• Alert log errors in the last 24 hoursORA- and TNS- errors plus checkpoint warnings from the alert log, read through SQL. It can be slow when the alert log is very large.
• Where the alert log and trace files areThe ADR home, alert log directory, trace directory and this session's own trace file.
• Trace another session with waits and bindsPrompts for a SID and serial number, turns on extended SQL trace, and shows the trace file name. Run the disable line when you've captured enough,…