无法启动正在运行的oracle,Oracle侦听器未运行,无法启动

从lsnrctl status命令得到以下错误：

C:\Users\pna105>lsnrctl stat

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 08-OCT-2014 17:53

:55

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 2: No such file or directory

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

64-bit Windows Error: 61: Unknown error

它在重新启动之前工作正常,但现在它不工作,我也无法访问我的Oracle主页.

我的tnsnames.ora是：

ORACLE =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = Localhost)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = ORACLE)

)

)

LISTENER_ORACLE =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

(CONNECT_DATA =

(SID = CLRExtProc)

(PRESENTATION = RO)

)

)

我的listener.ora是：(这里是由于括号错误添加几个空格解决了问题TNS-12518的错误)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = ORACLE)

(ORACLE_HOME = C:\app\PNA105\product\11.2.0\dbhome_1)

)

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = C:\app\PNA105\product\11.2.0\dbhome_1)

(PROGRAM = extproc)

)

(SID_DESC =

(SID_NAME = CLRExtProc)

(ORACLE_HOME = C:\app\PNA105\product\11.2.0\dbhome_1)

(PROGRAM = extproc)

(ENVS = "EXTPROC_DLLS=ONLY:C:\app\PNA105\product\11.2.0\dbhome_1\bin\oraclr11.dll")

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

)

)

ADR_BASE_LISTENER = C:\app\PNA105

以下是lsnrctl start命令的输出

C:\Users\pna105>lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 08-OCT-2014 18:26

:22

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

Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error

TNS-00530: Protocol adapter error

以下是从日志文件需要的最后一个条目.

Started with pid=14784

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Listener completed notification to CRS on start

09-OCT-2014 15:46:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=INL007306$))

(SERVICE_NAME=oracle)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=57389)) *

establish * oracle * 12518

TNS-12518: TNS:listener could not hand off client connection

TNS-12560: TNS:protocol adapter error

TNS-00530: Protocol adapter error

64-bit Windows Error: 203: Unknown error

Dynamic address is already listened on (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)

(HOST=127.0.0.1)(PORT=1521)))

09-OCT-2014 15:46:06 * service_register * oracle * 0

Thu Oct 09 15:46:11 2014

09-OCT-2014 15:46:11 * service_update * oracle * 0

09-OCT-2014 15:46:12 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=INL007306$))

(SERVICE_NAME=oracle)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=57393)) *

establish * oracle * 0

09-OCT-2014 15:46:12 * service_update * oracle * 0

09-OCT-2014 15:46:13 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=INL007306$))

(SERVICE_NAME=oracle)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=57394)) *

establish * oracle * 0

试图解决TNS-12518和侦听器启动,但仍然无法访问

Oracle主页

输出lnsrctl stat

C:\Users\pna105>lsnrctl stat

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 09-OCT-2014 17:16

:56

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ

ction

Start Date 09-OCT-2014 15:45:58

Uptime 0 days 1 hr. 30 min. 58 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File C:\app\PNA105\product\11.2.0\dbhome_1\network\admin\li

stener.ora

Listener Log File c:\app\pna105\diag\tnslsnr\INL007306\listener\alert\lo

g.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Services Summary...

Service "CLRExtProc" has 1 instance(s).

Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "ORACLE" has 2 instance(s).

Instance "ORACLE", status UNKNOWN, has 1 handler(s) for this service...

Instance "oracle", status READY, has 1 handler(s) for this service...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "oracleXDB" has 1 instance(s).

Instance "oracle", status READY, has 1 handler(s) for this service...

指令成功完成