SQL> select * from v$diag_info; INST_ID NAME ---------- ---------------------------------------------------------------- VALUE -------------------------------------------------------------------------------- 1 Diag Enabled TRUE 1 ADR Base /d20/oracle/product/mbasdb/11.1.0/admin/dest 1 ADR Home /d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas INST_ID NAME ---------- ---------------------------------------------------------------- VALUE -------------------------------------------------------------------------------- 1 Diag Trace /d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas/trace 1 Diag Alert /d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas/alert 1 Diag Incident /d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas/incident INST_ID NAME ---------- ---------------------------------------------------------------- VALUE -------------------------------------------------------------------------------- 1 Diag Cdump /d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas/cdump 1 Health Monitor /d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas/hm 1 Default Trace File /d20/oracle/product/mbasdb/11.1.0/admin/dest/diag/rdbms/mbas/mbas/trace/mbas_ora _23961.trc INST_ID NAME ---------- ---------------------------------------------------------------- VALUE -------------------------------------------------------------------------------- 1 Active Problem Count 8 1 Active Incident Count 81 11 rows selected. On Nov 9, 2009 11:51am, Job Miller <jobmiller@xxxxxxxxx> wrote:
Are these ADR files?
that path doesn't fit the ADR structure.
what does select * from v$diag_info show?
ADR should be:
$ORACLE_BASE/diag/product_type/product_id/instance_id