Database log files
Locations in this table represent the default locations, but these may have been modified for your environment.
Table: Reporting Database Log Files
Log File Name | Location | Description |
|---|---|---|
aptare-trans.log | C:\tmp /tmp | Records long-running transactions. |
scon.err | C:\tmp /tmp | Error messages from the database stored procedures. Oracle errors are prefixed with ORA-nnnn, where nnnn is the APTARE or Oracle error number. On Windows, if the directory C:\tmp exists, the file will be written there. Otherwise, it will be written to C:\opt\oracle\logs. |
scon.log | C:\tmp /tmp | Detailed logging from database stored procedures. Shows input and output values, and timing of queries. Oracle errors are prefixed with ORA-nnnn, where nnnn is the APTARE or Oracle error number. On Windows, if the directory C:\tmp exists, the file will be written there. Otherwise, it will be written to C:\opt\oracle\logs. |
sqlnet.log | C:\opt\oracle\network\log /opt/aptare/oracle/network/log | Oracle listener log file. Logs information about connection requests made to the Reporting Database. |
alert_scdb.log | C:\opt\oracle\rdbms\log\diag\rdbms\scdb\scdb\trace /opt/aptare/oracle/rdbms/log/diag/rdbms/scdb/scdb/trace | Oracle alert log file. Logs information on startup and shutdown of oracle instance, and also critical Oracle problems (such as disk I/O failures, out of disk space, system resource issues etc.) |