Oracle监听无法启动处理随记

早上上班，启动工作电脑，按照习惯，手动启动Oracle数据库，启动监听，数据库是起来了，但是启动监听的时候报如下错误：

SQL> host lsnrctl start

LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 27-APR-2016 09:04
:09

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production
Log messages written to d:\oracle\diag\tnslsnr\LiuFeng\listener\alert\log.xml
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12542: TNS:address already in use
 TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   64-bit Windows Error: 48: Unknown error

Listener failed to start. See the error message(s) above...

从提示的日志上看，是1521端口被占用了，使用netstat查看一下是哪个进程占用了该端口

C:\Users\Esri>netstat -abn|find "1521"
  TCP    192.168.100.138:1304   192.168.100.138:1521   ESTABLISHED
  TCP    192.168.100.138:1521   192.168.100.138:1304   ESTABLISHED
  TCP    192.168.100.138:1559   192.168.220.131:1521   ESTABLISHED

的确是有进程将1521端口作为客户端临时端口被使用了，但是由于find把进程过滤掉了，因此需要使用没有过滤后的信息。

netstat -abn>>ls.txt，将完整信息存储到ls.txt文件中

打开ls.txt文件，发现相关信息

[ArcSOC.exe]
  TCP    192.168.100.138:1502   192.168.100.138:1304   ESTABLISHED
 [ArcSOC.exe]
  TCP    192.168.100.138:1521   192.168.100.138:1304   ESTABLISHED
 [ArcSOC.exe]
  TCP    192.168.100.138:1526   192.168.100.138:1304   ESTABLISHED
 [ArcSOC.exe]
  TCP    192.168.100.138:1527   192.168.100.138:1304   ESTABLISHED
 [ArcSOC.exe]
  TCP    192.168.100.138:1559   192.168.220.131:1521   ESTABLISHED

原来是ArcGIS Server的ArcSOC.exe使用了该端口。由于ArcGIS Server服务是自动启动的，因此在数据库启动前就已经启动了，因此占用是正常的，停掉ArcGIS Server服务，然后再重新监听。

C:\Users\Esri>sc query |find "Arc"
SERVICE_NAME: ArcGIS Server
DISPLAY_NAME: ArcGIS Server

C:\Users\Esri>sc stop "ArcGIS Server"

SERVICE_NAME: ArcGIS Server
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 3  STOP_PENDING
                                (STOPPABLE, NOT_PAUSABLE, ACCEPTS_SHUTDOWN)
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x80e8

C:\Users\Esri>lsnrctl start

LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 27-APR-2016 09:40
:41

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production
Log messages written to d:\oracle\diag\tnslsnr\LiuFeng\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LiuFeng)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Produ
ction
Start Date                27-APR-2016 09:40:46
Uptime                    0 days 0 hr. 0 min. 8 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         d:\oracle\diag\tnslsnr\LiuFeng\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LiuFeng)(PORT=1521)))
The listener supports no services
The command completed successfully

C:\Users\Esri>sc start "ArcGIS Server"

SERVICE_NAME: ArcGIS Server
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 2  START_PENDING
                                (NOT_STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN)
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x7d0
        PID                : 10100
        FLAGS              :

顺利启动。