rdbmsalertlog

anishtv
anishtv used Ask the Experts™
on
Where is the location of rdbms alertlog

Can you please tell me the location of rdbms alertlog
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2012
Commented:
in 11g and higher this will return the directory  for either rdbms or asm


SELECT    (SELECT VALUE
             FROM v$parameter
            WHERE name = 'diagnostic_dest')
       || '/diag/'
       || (SELECT LOWER(VALUE)
             FROM v$parameter
            WHERE name = 'instance_type')
       || '/'
       || LOWER(SYS_CONTEXT('userenv', 'db_unique_name'))
       || '/'
       || SYS_CONTEXT('userenv', 'instance_name')
       || '/trace'
  FROM DUAL;

if you want the xml version of the alert log, then  change /trace  to /xml



for 10g and lower

  select value from v$parameter where name = 'background_dump_dest'

Author

Commented:
fine

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial