oracle监听tns-12545

【LISTENER】Oracle监听TNS-12545及TNS-00515错误处理一例

2）使用监听start命令获取到的报错信息
LSNRCTL> start
Starting /oracle/ora10gR2/product/10.2.0/db_2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /oracle/ora10gR2/product/10.2.0/db_2/network/admin/listener.ora
Log messages written to /oracle/ora10gR2/product/10.2.0/db_2/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=secdb)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Listener failed to start. See the error message(s) above...

解决方法：
先修改hosts文件内容，确保hosts文件中的内容与主机名保持一致。否则便会出现监听无法启动的问题。
vi /etc/hosts
192.168.161.129 redhat
127.0.0.1 secdb localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6

修改listener.ora文件
$ vi /u01/app/oracle/product/12.1/db1/network/admin/listener.ora
#listener.ora Network Configuration File: /u01/app/oracle/product/12.1/db1/network/admin/listener.ora
#Generated by Oracle configuration tools.

LISTENER =
　　(DESCRIPTION_LIST =
　　　　(DESCRIPTION =
　　　　　　(ADDRESS = (PROTOCOL = TCP)(HOST = redhat)(PORT = 1521))
　　　　　　(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
　　　　)
　　)

重启机器即可
reboot

如果机器里有tnsnames.ora这个文件的HOST也需要修改，但是这个文件建议使用IP地址。