重庆思庄Oracle、Redhat认证学习论坛

标题: Oracle TNS-01106 [打印本页]

作者: jiawang 时间: 2024-11-12 10:00
标题: Oracle TNS-01106
本帖最后由 jiawang 于 2024-11-12 13:32 编辑

1、启动监听：
[oracle@sztech ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-MAR-2024 12:44:31
Copyright (c) 1991, 2009, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started

2、这个问题基本2个原因导致：
1, /etc/hosts 文件中的 ip和主机名不一致
2, listener.ora 中监听主机非当前主机.

3、查看 /etc/hosts 文件[root@sztech ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.110.131 sztech

4、显示跟 IP不符
ens33: flags=4163 mtu 1500
inet 192.168.110.132 netmask 255.255.255.0 broadcast 192.168.6.255
inet6 fe80::9941:2693:38ba:317b prefixlen 64 scopeid 0x20
inet6 fe80::7a5e:cead:f696:b4e9 prefixlen 64 scopeid 0x20
ether 00:0c:29:1e:ab:40 txqueuelen 1000 (Ethernet)
RX packets 1907 bytes 160454 (156.6 KiB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 1537 bytes 222663 (217.4 KiB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

5.修改 vi/ets/hosts, 重新启动监听正常

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)