Oracle XE停止工作. TNS侦听器拒绝连接 [英] Oracle XE stopped working. TNS listener refused connection

问题描述

我正在开发一个使用Oracle XE 11g作为其RDBMS的应用程序.它已经工作了几个星期，但现在我开始收到一条错误消息，提示拒绝连接.

I'm working on an application which uses Oracle XE 11g as its RDBMS. It was working for several weeks but now I started to get an error message about the connection being refused.

我重新启动了系统，但没有帮助.我卸载了XE，删除了所有剩余文件(甚至从注册表中删除)，然后重新安装了它.现在，我又收到一条错误消息:

I restarted my system but it did not help. I uninstalled XE, deleted all remaining files (even from registry) and reinstalled it. Now I get another error message:

Listener拒绝连接，并出现以下错误:ORA-12505， TNS:listener当前不知道connect中给定的SID 描述符

Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

我已经阅读了有关此错误的信息，其他人建议将新的SID添加到listener.ora文件:

I've read about this error and others suggested adding a new SID to the listener.ora file:

(SID_DESC =
  (SID_NAME = XE)
  (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
)

如果执行此操作，则会收到另一条错误消息:

If I do this I get another error message:

ORA-01034:ORACLE不可用ORA-27101:共享内存领域 不存在

ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

我的配置文件是: listener.ora

    SID_LIST_LISTENER =   (SID_LIST =
    (SID_DESC =
      (SID_NAME = XE)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
    )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )   )

LISTENER =   (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = AAROLD.in.mycompany.com)(PORT = 1521))
    )   )

DEFAULT_SERVICE_LISTENER = (XE)

tnsnames.ora

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = AAROLD.in.mycompany.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

ORACLR_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
    ) 
    (CONNECT_DATA = 
      (SID = CLRExtProc) 
      (PRESENTATION = RO) 
    ) 
  ) 

lsnrctl状态返回:

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 19-M┴RC. -2013 15:12:24

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date                19-M┴RC. -2013 15:01:12
Uptime                    0 days 0 hr. 11 min. 11 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File         C:\oraclexe\app\oracle\diag\tnslsnr\AAROLD\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=AAROLD.in.mycompany.com)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

您知道可能是什么问题吗?我不是Oracle专家，所以我在这里完全处于黑暗之中.

Do you have any idea what can be the problem? I'm not an Oracle expert so I'm completely in the dark here.

推荐答案

您的Oracle数据库已关闭.启动可能会遇到一些问题.

Your Oracle DB is down. It may have some problem starting up.

转到命令提示符并键入:

Go to command prompt and type:

SQL> sqlplus/as sysdba

如果收到消息连接到空闲实例"，请键入

If you get a message "connected to an idle instance" then type

SQL> 启动

，让我知道您收到的消息.如果在SqlPlus启动时未收到连接到空闲实例"消息，则键入:

and let me know the message you get. If you don't get the "connected to an idle instance" message on SqlPlus startup, the type:

SQL> 设置第80行第50页

SQL> 从v $ database中选择*；

并将输出发布到此处.

这篇关于Oracle XE停止工作. TNS侦听器拒绝连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！