OracleXE18c，每次尝试连接时，Oracle侦听器OracleOraDB18Home1TNSListener都会停止，并且我无法连接到任何连接。

Question

为了学习，我安装了Oracle 18c XE v18.4.0.0和Oracle SQL Developer v21.4.2。

我以前没有使用Oracle数据库的经验。

命令LSNRCTL似乎显示了正确的结果：

LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 - Production on 02-MAR-2022 20:15:29

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MAJAPC)(PORT=1521)))  
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 18.0.0.0.0 - Production
Start Date                02-MAR-2022 19:49:32
Uptime                    0 days 0 hr. 26 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   C:\oracle18\dbhomeXE\network\admin\listener.ora
Listener Log File         C:\oracle18\diag\tnslsnr\MAJAPC\listener\alert\log.xml

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MAJAPC)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=127.0.0.1)(PORT=5500))(Security=(my
_wallet_directory=C:\ORACLE18\admin\XE\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "3bcb8ed4ef24494d93ec4d9b754310d2" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
Service "xepdb1" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully

我试图使用sqlplus命令连接到XEPDB1插件数据库：

sqlplus system/oracle@192.168.1.102:1521/XEPDB1 1 (192.168.1.102是我的本地IP)

但是每次我尝试这样做时，服务OracleOraDB18Home1TNSListener (以及侦听器)就会停止。

几分钟后对连接命令的响应是: ERROR: ORA-12537: TNS:连接已关闭。

然后，我再次手动启动监听器，然后再尝试连接到XEPDB1，但同样的事情再次发生。

sqlplus system/oracle命令在没有任何问题的情况下登录到Oracle。

在重新安装Oracle18cXE之后，listener.ora和tnsnames.ora文件不会被修改。

# listener.ora Network Configuration File: C:\oracle18\dbhomeXE\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

DEFAULT_SERVICE_LISTENER = XE

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oracle18\dbhomeXE)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\oracle18\dbhomeXE\bin\oraclr18.dll")
    )
  )

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

# tnsnames.ora Network Configuration File: C:\oracle18\dbhomeXE\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MAJAPC)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

LISTENER_XE =
  (ADDRESS = (PROTOCOL = TCP)(HOST = MAJAPC)(PORT = 1521))


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

我对Oracle数据库完全陌生，不知道哪些日志项可以告诉我问题出在哪里。这就是为什么我要把这个问题贴给更有经验的人。老师要求我们安装18c XE，因为它比21c XE更容易安装。除此之外，Windows 7不支持大于18c的版本。

下面是来自侦听器的跟踪和警报日志：

https://drive.google.com/file/d/14mFzW0UgX5OVT75PE7Wxb7DZ2wce8wgl/view?usp=sharing

如果有人能帮我的话我很感激。

Answer 1

你肯定是出了问题。

具有堆栈跟踪的DDE was called in a 'No Invocation Mode'。

很难提出一个简单的前进道路。

我建议您卸载18cXE，而应该使用Oracle，并启动Oracle之一，其中一个是Oracle。

另一种选择是在Oracle云中运行您的自治Oracle数据库。它永远是自由的。这是我现在最喜欢的选择。

祝你好运！