Check Alert Log File Location in Oracle
If the db is up and running:
show parameter dump;
(here look for the parameter background_dump_dest)
select value from v$parameter where name = 'background_dump_dest';
(here look for the path)
Go to the file location and list the last 100 lines:
tail -100f alert_prod.log
If DB is Down
find / -name alert_prod.log 2>/dev/null
No comments:
Post a Comment