Working with Log Files > Database Log Files
  
Version 10.2.01P10
Database Log Files
Locations in this table represent the default locations, but these may have been modified for your environment.
 
Table 3 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.)