Skip to content

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot connect to Oracle Db #12421

Closed
techlock77 opened this issue May 11, 2021 · 4 comments
Closed

Cannot connect to Oracle Db #12421

techlock77 opened this issue May 11, 2021 · 4 comments

Comments

@techlock77
Copy link

techlock77 commented May 11, 2021

System information:

  • Operating system (distribution) and version -> WIN 10
  • DBeaver version -> 21.0.3

Connection specification:

  • Database name and version -> Oracle
  • Driver name -> oracle.jdbc.OracleDriver
    image
@uslss
Copy link
Member

uslss commented May 12, 2021

Seems it is server-side issue. Please, check connection preferences
https://stackoverflow.com/questions/10786782/ora-12514-tnslistener-does-not-currently-know-of-service-requested-in-connect-d

@techlock77
Copy link
Author

The problem is our connection uses service_name but on Dbeaver there is no slot where we can edit the service_name.

image

@techlock77
Copy link
Author

@uslss Is there a way to edit the service name in Dbeaver>?

@p91paul
Copy link
Contributor

p91paul commented May 14, 2021

@techlock77 in your screenshot, you are connecting via service name (orcl). If you actually want to use SID instead of service name, change that combo to SID and orcl will be interpreted as SID instead of service name.

@uslss uslss closed this as completed May 17, 2021
@dbeaver dbeaver locked and limited conversation to collaborators May 17, 2021

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

Projects
None yet
Development

No branches or pull requests

3 participants