Alert log file in Oracle
As you know alert log file location determined by the background dump destination it’s specified by backupground_dump_dest parameter
You can find location of alert log with following command.
SQL> show parameter background
NAME TYPE VALUE
——————————— ———– ——————————
background_core_dump string partial
background_dump_dest string D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCLDATA\BDUMP
Also you can use following command
SQL> select name, value from v$parameter where name=’background_dump_dest’
NAME VALUE
——————– ————————————————————
background_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCLDATA\BDUMP
For windows platform to find alert log file location run following command on host
Dir /s alert*.log|more
It’ll show you the location & size of alert log file.