Problem connecting to Oracle

Note: please leave bug reports and feature requests on

Problem connecting to Oracle

Postby sandman42 » Fri Dec 09, 2011 10:39 am

Hi,

I'm having problems on connect to oracle servers.

Particularly, when I try to connect, I have the error:

Error connecting to datasource 'MYDB'
Unexpected driver error occurred while connecting to database
no ocijdbc11 in java.library.path

Needless to mention that I have Oracle client installed, working ok from other apps.

What's wrong?

Ciao
sandman42
 
Posts: 14
Joined: Wed Oct 12, 2011 8:31 am

Re: Problem connecting to Oracle

Postby Support » Fri Dec 09, 2011 12:19 pm

Probably you should use Thin driver - it doesn't require native client.

In any case, Oracle client must be in system PATH, otherwise OCI driver won't work.
Note that if you have multiple Oracle client installations then the only one which will work is that one which is in PATH.

Thanks for report
Support
 
Posts: 49
Joined: Thu Mar 17, 2011 10:11 am

Re: Problem connecting to Oracle

Postby sandman42 » Fri Dec 09, 2011 3:57 pm

sandman42
 
Posts: 14
Joined: Wed Oct 12, 2011 8:31 am

Re: Problem connecting to Oracle

Postby Support » Fri Dec 09, 2011 6:58 pm

That's interesting.

I suppose you are not on Windows. And you have Oracle 11g client.
Could you say what exactly OS/client do you have? Especially - is it "normal" or "Instant" Oracle client?

Unfortunatelly support of OCI driver wasn't well-tested on Linux/Unix platforms yet. In fact there are not much users with such environment and we lack feedbacks :(
If we will figure out the problem quickly then we'll release another hotfix version in a few days.

Thanks!
Support
 
Posts: 49
Joined: Thu Mar 17, 2011 10:11 am

Re: Problem connecting to Oracle

Postby sandman42 » Sun Dec 11, 2011 4:16 pm

sandman42
 
Posts: 14
Joined: Wed Oct 12, 2011 8:31 am

Re: Problem connecting to Oracle

Postby EugeneJF » Sun Dec 11, 2011 5:56 pm

EugeneJF
 
Posts: 42
Joined: Mon Feb 28, 2011 10:04 am

Re: Problem connecting to Oracle

Postby sandman42 » Mon Dec 12, 2011 7:12 am

sandman42
 
Posts: 14
Joined: Wed Oct 12, 2011 8:31 am

Re: Problem connecting to Oracle

Postby sandman42 » Mon Dec 12, 2011 7:27 am

sandman42
 
Posts: 14
Joined: Wed Oct 12, 2011 8:31 am

Re: Problem connecting to Oracle

Postby Serge » Tue Dec 13, 2011 4:12 pm

Concerning connect error:

I think you have an unusual Oracle environment.
What do you see in Oracle Home selector combo? What client version is there? Or may be there are multiple homes?
If you click on "Browse" item in this combo you may see detailed client description - is it correct?

Concerning problem with connection role: yes, it is a bug in DBeaver. It will be fixed in next hotfix version.

Sorry for delay - right now I'm in vacation, too far from my development environment ;) But I think we'll make hotfix version in the beginning of next week.

Thanks for your reports!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Problem connecting to Oracle

Postby sandman42 » Wed Dec 14, 2011 8:35 am

sandman42
 
Posts: 14
Joined: Wed Oct 12, 2011 8:31 am

Next

Return to Support



Who is online

Users browsing this forum: Google [Bot] and 26 guests