Debian上查看 sqlplus 相关日志的实用方法
一、先明确你要看的两类日志
二、查看 sqlplus 自身输出
sqlplus user/pass@db @script.sql > sqlplus.log 2>&1script -q sqlplus_session.logsqlplus user/pass@dbless sqlplus_session.logSPOOL /tmp/query.logSELECT SYSTIMESTAMP FROM dual;SPOOL OFFless /tmp/query.logtail -f sqlplus.log三、查看 Oracle 数据库后台与告警日志
$ORACLE_HOME/log/diag/rdbms/<sid>/<sid>/trace/alert_<sid>.logtail -f $ORACLE_HOME/log/diag/rdbms/*/*/trace/alert_*.logecho $ORACLE_HOME$ORACLE_HOME/log/diag/tnslsnr/<listener>/trace/listener.logtail -f $ORACLE_HOME/log/diag/tnslsnr/*/trace/listener.logSELECT instance_name FROM v$instance;SELECT value FROM v$diag_info WHERE name = 'Diag Trace';SELECT value FROM v$diag_info WHERE name = 'Alert Log';journalctl -u <listener_service> -f 查看监听服务的日志(具体服务名以你的安装为准)。四、Debian 系统层日志的辅助查看
journalctl -u your_sqlplus_service.service -fjournalctl -u your_sqlplus_service.service --since "2025-11-21 10:00:00" --until "2025-11-21 12:00:00"tail -f /var/log/syslogjournalctl --since "2025-11-21 10:00:00" --until "2025-11-21 12:00:00"