LSNRCTL for Linux: Version 8.0.0 – Production on 11-APR-2026 10:00:00

Copyright (c) 1991, 2026, YashanDB. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fgedu.net.cn)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 8.0.0 – Production
Start Date 10-APR-2026 09:00:00
Uptime 1 days 1 hours 0 minutes 0 seconds
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /yashandb/app/yaslistener.ora
Listener Log File /yashandb/app/log/listener.log
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fgedu.net.cn)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
Service “fgedudb” has 1 instance(s).
Instance “fgedudb”, status READY, has 1 handler(s) for this service…
Service “fgedudbXDB” has 1 instance(s).
Instance “fgedudb”, status READY, has 1 handler(s) for this service…
The command completed successfully

# 查看监听器进程
$ ps -ef | grep yaslsnr
oracle 12345 1 0 09:00 ? 00:00:00 /yashandb/app/bin/yaslsnr -listener LISTENER -inherit

# 检查监听器端口
$ netstat -tuln | grep 1521
tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN
tcp6 0 0 :::1521 :::* LISTEN

# 监听器监控脚本

# 监听器名称
listener_name=”LISTENER”

# 输出文件
output_file=”/tmp/listener_monitor_$(date +%Y%m%d_%H%M%S).log”

echo “开始监控监听器状态” > ${output_file}
echo “监控时间: $(date)” >> ${output_file}
echo “” >> ${output_file}

# 检查监听器状态
${ORACLE_HOME}/bin/yaslsnrctl status ${listener_name} >> ${output_file}
echo “” >> ${output_file}

# 检查监听器进程
ps -ef | grep yaslsnr | grep -v grep >> ${output_file}
echo “” >> ${output_file}

# 检查监听器端口
netstat -tuln | grep 1521 >> ${output_file}
echo “” >> ${output_file}

# 检查监听器日志
if [ -f “/yashandb/app/log/listener.log” ]; then
tail -n 50 /yashandb/app/log/listener.log >> ${output_file}
fi

echo “监控完成，结果保存至：${output_file}” >> ${output_file}
echo “监控完成，结果保存至：${output_file}”

# 1. 检查监听器状态
$ yaslsnrctl status

# 2. 检查监听器进程
$ ps -ef | grep yaslsnr

# 3. 检查监听器端口
$ netstat -tuln | grep 1521

# 4. 检查监听器日志
$ tail -n 100 /yashandb/app/log/listener.log

# 5. 检查网络连接
$ ping fgedu.net.cn
$ telnet fgedu.net.cn 1521

# 6. 检查监听器配置文件
$ cat /yashandb/app/yaslistener.ora

# 7. 检查数据库实例状态
$ yasboot status fgedudb

# 8. 检查服务注册
$ sqlplus / as sysdba
SQL> ALTER SYSTEM REGISTER;
SQL> SELECT instance_name, status FROM v$instance;

# 9. 检查防火墙设置
$ firewall-cmd –list-ports
$ iptables -L

# 错误1：监听器无法启动
$ yaslsnrctl start
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener

# 解决方法：检查监听器配置文件，确保配置正确
$ cat /yashandb/app/yaslistener.ora

# 错误2：监听器启动失败，端口被占用
$ yaslsnrctl start
TNS-12542: TNS:address already in use

# 解决方法：检查端口占用情况，杀死占用端口的进程
$ netstat -tuln | grep 1521
$ lsof -i :1521
$ kill -9

# 错误3：客户端无法连接，提示TNS-12545
$ sqlplus fgedu/fgedu@fgedudb
ORA-12545: Connect failed because target host or object does not exist

# 解决方法：检查网络连接，确保主机名可解析
$ ping fgedu.net.cn
$ nslookup fgedu.net.cn

# 错误4：监听器服务注册失败
$ yaslsnrctl status
Services Summary…
Service “fgedudb” has 0 instance(s).

# 解决方法：手动注册服务
$ sqlplus / as sysdba
SQL> ALTER SYSTEM REGISTER;

# 1. 停止监听器
$ yaslsnrctl stop

# 2. 检查并修复配置文件
$ vi /yashandb/app/yaslistener.ora

# 3. 启动监听器
$ yaslsnrctl start

# 4. 验证监听器状态
$ yaslsnrctl status

# 5. 注册数据库服务
$ sqlplus / as sysdba
SQL> ALTER SYSTEM REGISTER;

# 6. 测试连接
$ sqlplus fgedu/fgedu@fgedudb

# 7. 监控监听器状态
$ yaslsnrctl status

# 监听器自动恢复脚本

# 监听器名称
listener_name=”LISTENER”

# 检查监听器状态
${ORACLE_HOME}/bin/yaslsnrctl status ${listener_name} > /dev/null 2>&1

if [ $? -ne 0 ]; then
echo “监听器 ${listener_name} 未运行，尝试启动…”
${ORACLE_HOME}/bin/yaslsnrctl start ${listener_name}

# 检查启动结果
sleep 2
${ORACLE_HOME}/bin/yaslsnrctl status ${listener_name} > /dev/null 2>&1

if [ $? -eq 0 ]; then
echo “监听器 ${listener_name} 启动成功”
# 注册数据库服务
${ORACLE_HOME}/bin/sqlplus -s / as sysdba << EOF ALTER SYSTEM REGISTER; EXIT; EOF else echo "监听器 ${listener_name} 启动失败，请检查配置" fi else echo "监听器 ${listener_name} 运行正常" fi