oracle Visual Studio Code Sql扩展未连接到数据库

uklbhaso  于 2023-08-03  发布在  Oracle
关注(0)|答案(1)|浏览(144)

我试图通过Matheus特谢拉的扩展SQLTools将Visual Studio Code IDE连接到我的工作场所的测试数据库,即Oracle,但我得到了以下错误:

[1690966489589] INFO  (ls): Connection instance created for TEST_testdb.
   ns: "conn-manager"
[1690966489643] ERROR (ls): Connecting error: {"code":-32001,"data":{"driver":"Oracle","driverOptions":{"oracleOptions":{"autoCommit":false,"lowerCase":false,"thickMode":false}}},"name":"Error"}
   ns: "conn-manager"
[1690966489643] ERROR (ls): Open connection error
   ns: "conn-manager"
[1690966489644] ERROR (ext): ERROR: Error opening connection NJS-516: no configuration directory set or available to search for tnsnames.ora, {"code":-32001,"data":{"driver":"Oracle","driverOptions":{"oracleOptions":{"autoCommit":false,"lowerCase":false,"thickMode":false}}}}
   ns: "error-handler"

字符串
这是我的连接json:

{
  "oracleOptions": {
    "autoCommit": false,
    "lowerCase": false,
    "thickMode": false
  },
  "previewLimit": 50,
  "askForPassword": true,
  "server": "localhost",
  "port": 1521,
  "driver": "Oracle",
  "connectString": "testdb.bank.it",
  "username": "my-username",
  "name": "TEST_testdb"
}


其他有用的信息是,我必须通过代理安装扩展为this,可能还有其他事情要设置,才能正常工作

vd8tlhqk

vd8tlhqk1#

您的数据库配置正确吗?你能通过sqlplus连接到数据库吗?似乎找不到tnsnames.ora。

相关问题