如何在SQLcl中修复“连接失败”提示

后端开发 2026-07-09

我刚刚安装了SQLcl和 Oracle数据库21c Express Edition，并且也把路径添加到了环境变量中。所有服务包括OracleOraDB21Home1TNSListener在内都已成功运行，但我仍无法连接到Oracle数据库。

命令提示符中的连接失败信息：

C:\Users\USER>sql.exe
SQLcl: Release 26.1 Production on Fri Apr 24 03:38:11 2026

Copyright (c) 1982, 2026, Oracle.  All rights reserved.

Username? ('') system
Password? (********?) ****
Connection failed
USER          = system
URL           = jdbc:oracle:oci8:@
Error Message = no ocijdbc23 in java.library.path: 
C:\Program Files\Java\jdk-17.0.19\bin;C:\windows\Sun\Java\bin; 
C:\windows\system32;
C:\windows;
C:\Users\USER\Downloads\sqlcl-26.1.0.086.1709\sqlcl\bin;
C:\app\USER\product\21c\dbhomeXE\bin;
C:\Program Files\Java\jdk-17.0.19\bin;
C:\Program Files\Common Files\Oracle\Java\javapath;
C:\windows\system32;C:\windows;
C:\windows\System32\Wbem;
C:\windows\System32\WindowsPowerShell\v1.0;
C:\windows\System32\OpenSSH;
C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;
C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;
C:\Users\Administrator\AppData\Local\Microsoft\WindowsApps;
C:\Program Files\HP\OMEN-Broadcast\Common;
C:\Program Files (x86)\Yarn\bin;
C:\Program Files\nodejs;
C:\Program Files\MySQL\MySQL Server 8.0\bin;
C:\Program Files\Docker\Docker\resources\bin;
C:\Program Files\Git\cmd;
C:\Program Files\Java\jdk-24\bin;
C:\Program Files\MySQL\MySQL Shell 8.0\bin;
C:\Users\USER\AppData\Local\Microsoft\WindowsApps;
C:\Users\USER\AppData\Local\Programs\Microsoft VS Code\bin;
C:\Program Files\JetBrains\IntelliJ IDEA 2024.3.2.1\bin;;
C:\Users\USER\AppData\Local\JetBrains\IntelliJ IDEA Community Edition 2024.3.2.2\bin;;
C:\Users\USER\AppData\Local\Yarn\bin;
C:\intelFPGA\20.1\modelsim_ase\win32aloem;
C:\Users\USER\AppData\Roaming\npm;
C:\Program Files\Java\jdk-17.0.19\bin;.

C:\Users\USER>