SQLDBX Connect Oracle (no need to install Oracle client)

Unzip the Sqldbx.zip and put the sqldbx into the C: packing directory

1.Path inside added: C:\SQLDBX
Path is to find Tnsnames.ora.

2. Add System variable: oracle_home, Path: C:\SQLDBX
Oracle_home was trying to find Oci.dll.

3. When using sqldbx query, if there is garbled in Chinese, then:

Set Variable name: Nls_lang, Variable value: Simplified Chinese_china. Zhs16gbk

4.SQLDBX exposes ora-12154:tns:could not resolve the connect identifier specified error

Because the 64 bit to the 32-bit sqlplus, so this ora address is wrong (PS: I was changed after this, now is right)

To add an environment variable,

Tns_admin

D:\tool\oraclexe\app\oracle\product\instantclient_11_2 (PS: This path is to find the Ora file can be a well-equipped Ora file in the C:\SqlDbx extracted path, Configuration path)

Add this to path, too,

Repeat the above steps to find the

: https://download.csdn.net/download/xzplinke/10428957

SQLDBX Connect Oracle (no need to install Oracle client)