我试图通过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,可能还有其他事情要设置,才能正常工作
1条答案
按热度按时间vd8tlhqk1#
您的数据库配置正确吗?你能通过sqlplus连接到数据库吗?似乎找不到tnsnames.ora。