Solution : https://service.sap.com/sap/support/notes/1431751 (SAP Service marketplace login required)
Summary :
This SAP Note provides an overview of the Oracle Automatic Diagnostic Repository (ADR) and its command-line interpreter, ADRCI, emphasizing their roles in Oracle Database 11g diagnostics. The document identifies changes in Oracle 11g such as the deprecation of 'user_dump_dest' and 'background_dump_dest', and introduces the ‘diagnostic_dest’ configuration. It comprehensively covers the use of ADRCI to manage diagnostic data, including details on viewing, investigating, and packaging incidents. Additionally, it explains the structure of ADR and how it can be accessed even when the database is down, supporting better problem diagnosis and resolution in SAP environments. Essential references to Oracle Support documents for further guidance on ADR configuration and usage are included.
Key words :
------------------------------hm test checkdb structure integrity checkcf block integrity checkdata block integrity checkredo integrity checklogical block checktransaction integrity checkundo segment integrity checkno mount cf checkmount cf checkcf member checkall datafiles checksingle datafile checktablespace check checklog group checklog group member checkarchived log checkredo revalidation checkio revalidation checkblock io revalidation checktxn revalidation checkfailure simulation checkdictionary integrity checkasm mount checkasm allocation checkasm disk visibility checkasm file busy checkmanually execute, ---------------------------------------------------------------------- 1 diag enabled true 1 adr base /oracle/q97/saptrace 1 adr home /oracle/q97/saptrace/diag/rdbms/q97/q97 1 diag trace /oracle/q97/saptrace/diag/rdbms/q97/q97/trace 1 diag alert /oracle/q97/saptrace/diag/rdbms/q97/q97/alert 1 diag incident /oracle/q97/saptrace/diag/rdbms/q97/q97/incident 1 diag cdump /oracle/q97/saptrace/diag/rdbms/q97/q97/cdump 1 health monitor /oracle/q97/saptrace/diag/rdbms/q97/q97/hm 1 default trace file /oracle/q97/saptrace/diag/rdbms/q97/q97/trace/ q97_ora_15398, adr base = /oracle/qo1/saptraceadr home = /oracle/qo1/saptrace/diag/rdbms/qo1/qo1_1adr home = /oracle/qo1/saptrace/diag/rdbms/qo1/qo1_2adr home = /oracle/qo1/saptrace/diag/rdbms/qo1/qo1_3adr home = /oracle/qo1/saptrace/diag/tnslsnr/<host>/<listener> adr command interpreter, adr base = /oracle/qo1/saptraceadr home = /oracle/qo1/saptrace/diag/rdbms/qo1/qo1adr home = /oracle/qo1/saptrace/diag/tnslsnr/<host>/<listener>, adrci> ips add file <adr_home>/trace/<filename>adrci> ips add file <adr_base>/diag/rdbms/orcl/orcl/trace/<filename>step 3, diag/rdbms/q93/q93diag/tnslsnr/usdbq93/listeneradrci> set homepath diag/rdbms/q93/q93adrci> show homesadr homes, location adr location core dump core_dump_dest $adr_home/cdump alert log data background_dump_dest $adr_home/trace $adr_home/alert, modified timeadrci> show tracefile -rtviewing incidentsadrci> show incidentadrci> show incident -mode briefadrci> show incident -mode detailpackaging incidents - incident package service, 001 rows fetchedadrci> show incidentadr home = /oracle/qo1/saptrace/diag/rdbms/qo1/qo1, file /oracle/qo1/saptrace/diag/rdbms/qo1/qo1/trace/qo1_ora_2490518
Related Notes :
| 1431800 | Oracle 11.2.0: Central Technical Note |