dbeaver / dbeaver/dbeaver

Oracle: Unknown host specified

Open
#41,312 1 comment 0 reactions 0 assignees View on GitHub
x:oracle xf:connection
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 13h
Merged PRs (30d)
183

Description

### Description

I created a JDBC6 oracle custom driver using "ojdbc14-10.2.0.2.0.jar" to connect to legacy Oracle databases, when i create a new entry from TNSNAMES, always throw "Unknown host specified" instead using TNSNAMES.ORA data.

Image

And the driver config:

Image

(I also tried with "jdbc:oracle:thin:@{host}[:{port}]/{database}")

Image

Image

Image

The TNSNAMES.ORA entry:

COGNOSD.WORLD=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=slx00010565_svc)
(PORT=1535)
)
(CONNECT_DATA=
(SID=COGNOSD)
)
)

Obviously this entry works in TOAD or with normal Oracle driver

### DBeaver Version

26.1.0

### Operating System

Windows 22H2

### Database and driver

Any oracle what i try to connect with this driver

### Steps to reproduce

Create custom Oracle driver with library brom
https://mvnrepository.com/artifact/com.oracle/ojdbc14/10.2.0.2.0

Try to use with tnsnames.ora entry

### Additional context

Related to:
https://github.com/dbeaver/dbeaver/issues/657
https://github.com/dbeaver/dbeaver/issues/684

This is the same driver that "Dbeaver pro" is using.

Data from

C:\Users\xxx\AppData\Roaming\DBeaverData\workspace6\.metadata\.config\drivers.xml

```























```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.