Menu
Where is the location of my oracle event log (on a default Linux installation)?
351
When a database deployment is created on Oracle Database Exadata Cloud Service, log files from the creation operation are stored in subdirectories of /var/opt/oracle/log . By default, Oracle Database trace files and log files are stored in subdirectories of /u02/app/oracle/diag .
According to your screenshot, you could check under C:\oracle\VIS\12.1. 0\admin\VIS_ebs\diag\rdbms\vis\vis\trace\ .
The ADR is set by using the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted, then, the default location of ADR is, 'u01/oracle/product/ora11g/log' (depends on ORACLE_HOME settings). If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.
Alert logs contain important information about error messages and exceptions that occur during database operations. Each Oracle Database for Windows instance has one alert log; information is appended to the file each time you start the instance. All threads can write to the alert log.
select value from v$parameter where name = 'background_dump_dest'
Using @cagcowboy's answer, a default Oracle XE installation on Linux writes out to:
/usr/lib/oracle/xe/app/oracle/admin/XE/bdump
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
