CODEWITHSUNDEEP
oracle-databasesqltools
Moke
Moke

Reputation: 1

Cannot connect to Oracle thas uses wallet (certificates) with SQLTools

We have an Oracle database (external supplier) which we want to connect to with certificates. I have in the file tnsnames.ora the next entry:

TESTDB =
  (DESCRIPTION=
    (ADDRESS_LIST =
      (ADDRESS=(PROTOCOL=tcps)(HOST=TESTDB-SERVER)(PORT=2233))
    )
  (CONNECT_DATA=(SERVICE_NAME=TESTDB))
  (SECURITY =
     (MY_WALLET_DIRECTORY = D:\testwallet\acc)   
     (SQLNET.AUTHENTICATION_SERVICES = (TCPS,NTS))
     (SSL_CLIENT_AUTHENTICATION = FALSE)
  )
)

It works fine with SQL Developer and SQL*Plus, but I cannot connect with SQLTools.

I tried with the latest version. Is this possible or not supported?

What can I try in SQLTools? Not much possible. SQLTools does see the entries from tnsnames.ora.

Upvotes: 0

Views: 230

Answers (1)

p3consulting
p3consulting

Reputation: 4670

It works here:

Connection Type: Use TNSNAMES.ORA
TNS Admin location: directory path where you UNZIP the wallet
TNS Alias: once admin location is OK, will pop-up list of available ones

Upvotes: 0

Related Questions