search

hashhashu / sqltools-Oracle-driver

SQLTools Driver for Oracle
MIT License
5 stars 2 forks source link

NJS-518: cannot connect to Oracle Database. Service is not registered with the listener #10

Open MichaelHechtDH opened 1 year ago

MichaelHechtDH commented 1 year ago

I'm new on testing SQL Tools with VSCODE.

I managed to connect to Postgres without problems, but with Oracle I get errors. On doing this:

image

I get

NJS-518: cannot connect to Oracle Database. Service "p54" is not registered with the listener at host 172.x.x.x port 1554. (CONNECTION_ID=mibVPOZnrwVGilnl9hzaeA==)

On changing to Connection String with

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbserver)(PORT=1554))(CONNECT_DATA=(SID=p54)))

I get

NJS-138: connections to this database server version are not supported by node-oracledb in Thin mode

I also tried

//dbserver:1554/p54

but this resulted again in the first described error.

Maybe setting the database to the SID is wrong but changing to the database name on server (which is TDWDB) gives the same error.

On my DBeaver the connection string is:

jdbc:oracle:thin:@dbserver:1554:p54

How to configure the connection properly?

hashhashu commented 1 year ago

Hi, looks like your database version is not high enough, you can try to click the "use thick mode" option image you can see more info about "thick mode and thin mode" in https://node-oracledb.readthedocs.io/en/latest/user_guide/appendix_a.html