oracle知识库在线工具,汇集oracle常用sql、函数、运维命令、故障排查、体系结构、学习笔记,dba与开发学习查阅工具
# 监听基础命令
lsnrctl status # 查看监听状态、端口、注册实例
lsnrctl start # 启动监听
lsnrctl stop # 关闭监听
lsnrctl reload # 重载监听配置(改listener.ora后不用重启)
lsnrctl services # 查看监听注册的服务
lsnrctl set log_status on # 开启监听日志
lsnrctl show log_file # 查看监听日志路径
# 测试连通性
tnsping orcl
# 监听配置文件路径
# $ORACLE_HOME/network/admin/listener.ora
# $ORACLE_HOME/network/admin/tnsnames.ora
# 简单listener.ora示例
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
)
)
# tnsnames.ora 本地服务名配置
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)