在修改oracle默认端口时,监听服务没有正常关闭的情况,有可能会造成端口号暂用问题。
[oracle@localhost ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 21-JAN-2016 16:13:43
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/oracle/product/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/oracle/product/network/admin/listener.ora
Log messages written to /u01/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
Listener failed to start. See the error message(s) above...
查看端口号占用情况
[root@localhost ~]# netstat -ntulp|grep 1521
tcp 0 0 192.168.XX.XX:1521 0.0.0.0:* LISTEN 3988/tnslsnr
[root@localhost ~]# ps -ef |grep 3988
oracle 3988 1 0 15:42 ? 00:00:00 /u01/oracle/product/bin/tnslsnr LISTENER -inherit
root 5091 4987 0 16:13 pts/3 00:00:00 grep 3988
[root@localhost ~]# kill -9 3988
[oracle@localhost ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 21-JAN-2016 16:13:43
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/oracle/product/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/oracle/product/network/admin/listener.ora
Log messages written to /u01/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
Listener failed to start. See the error message(s) above...
查看端口号占用情况
[root@localhost ~]# netstat -ntulp|grep 1521
tcp 0 0 192.168.XX.XX:1521 0.0.0.0:* LISTEN 3988/tnslsnr
[root@localhost ~]# ps -ef |grep 3988
oracle 3988 1 0 15:42 ? 00:00:00 /u01/oracle/product/bin/tnslsnr LISTENER -inherit
root 5091 4987 0 16:13 pts/3 00:00:00 grep 3988
[root@localhost ~]# kill -9 3988