User Tools

Site Tools


automaticdiagnosticrepository

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
automaticdiagnosticrepository [2015/07/22 09:27] – created z0hpvkautomaticdiagnosticrepository [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 4: Line 4:
 <code>adrci> set base /u01/app/oracle</code> <code>adrci> set base /u01/app/oracle</code>
  
-<code>adrci> show home +<code>adrci> show homes 
-adrci> set home .....+adrci> set homepath .....
 adrci> show alert -tail -f adrci> show alert -tail -f
 adrci> show alert -p "message_text like '%ORA-%'" adrci> show alert -p "message_text like '%ORA-%'"
Line 12: Line 12:
 <code>adrci> show incident <code>adrci> show incident
 INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME
--------------------- ----------------------------------------------------------- ----------------------------------------+-------------------- ----------------------------------------------------------- ---------------------------------
 9675                 ORA 700 [kskvmstatact: excessive swapping observed]         2015-07-16 22:05:37.616000 +01:00 9675                 ORA 700 [kskvmstatact: excessive swapping observed]         2015-07-16 22:05:37.616000 +01:00
  
 adrci> show problem adrci> show problem
-PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT        LASTINC_TIME +PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT         
--------------------- ----------------------------------------------------------- -------------------- ---------------------------------------- +-------------------- ----------------------------------------------------------- ------------------  
-1                    ORA 700 [kskvmstatact: excessive swapping observed]         9675                 2015-07-16 22:05:37.616000 +01:00+1                    ORA 700 [kskvmstatact: excessive swapping observed]         9675               
  
 adrci> show incident -mode detail -p "incident_id=9675" adrci> show incident -mode detail -p "incident_id=9675"
Line 37: Line 37:
 adrci> purge -age 2880 adrci> purge -age 2880
 adrci> purge -age 2880 -type trace</code> adrci> purge -age 2880 -type trace</code>
 +
 +==== Oracle Support Documents ====
 +[[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1221773.1|How To Filter ADRCI 'Show Alert' Output By Date and Time]]\\ 
 +[[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=816871.1|How To Purge Listener Log.Xml File?]]\\
 +[[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1196437.1|Automatic Diagnostic Cleanup - Auto purge]]\\
 +[[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=564269.1|Retention Policy for ADR]]\\
 +[[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=975448.1|Which Files Are Part Of SHORTP_POLICY And LONGP_POLICY In ADR?]]
automaticdiagnosticrepository.1437557267.txt.gz · Last modified: 2025/03/08 22:23 (external edit)