Problem with Win2008R2 64 Bit/Oracle 11.2.0.1 64 bit

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Yahia
Posts: 23
Joined: Tue 25 Oct 2011 09:30

Problem with Win2008R2 64 Bit/Oracle 11.2.0.1 64 bit

Post by Yahia » Tue 25 Oct 2011 09:38

Hi,

I have installed the latest Studio version, it imported my connections from OraDeveloper tools just fine...
When I try to connect I get "Can't load oci.dll - use x32 version with x32 app"... when I try to make a new connection it says that it can't find tnsnames.ora and only displays "Instant Client" as Home...

ALL other apps (like OraDeveloper, SQL Developer, SQL Plus...) and libraries (like Devart dotconnect for Oracle...) work like a charm on this machine (Windows Server 2008 R2 64 Bit)... the installed Oracle client is 64 Bit...

Am I missing something ?

Thanks in advance
Yahia

.jp
Devart Team
Posts: 306
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Tue 25 Oct 2011 10:10

Currently, we suggest you to use either 32-bit Oracle client software or Direct mode which doesn't require installation and administration of Oracle client software. Please refer to the 'Using Direct Mode' topic in dbForge Studio for Oracle help documentation for details.

Please note that Direct mode is not accessible in the Express edition of dbForge Studio for Oracle.
You can see the features list of dbForge Studio for Oracle editions here.

Yahia
Posts: 23
Joined: Tue 25 Oct 2011 09:30

Post by Yahia » Tue 25 Oct 2011 10:14

I have the licensed Pro version... and don't want to use Direct Mode... any timeframe when 64 Bit will be supported ?

Alexz
Devart Team
Posts: 165
Joined: Wed 10 Aug 2005 08:30

Post by Alexz » Tue 25 Oct 2011 11:24

For the time being, dbForge Studio for Oracle, v3.0 is a 32bit application, and it cannot work with 64bit Oracle client.
We plan to make dbForge Studio compatible with all kinds of CPU architectures in the nearest future.

Yahia
Posts: 23
Joined: Tue 25 Oct 2011 09:30

Post by Yahia » Tue 25 Oct 2011 11:31

Then perhaps you can give me a piece of advice: Does installing the 32 Bit client in parallel to the above configuration (64 Bit) have any side-effects ?

Thanks in advance
Yahia

Alexz
Devart Team
Posts: 165
Joined: Wed 10 Aug 2005 08:30

Post by Alexz » Tue 25 Oct 2011 11:46

You can have both 32bit and 64bit Oracle clients on one machine.

Yahia
Posts: 23
Joined: Tue 25 Oct 2011 09:30

Post by Yahia » Tue 25 Oct 2011 12:20

Thanks - it works :-)

One last question though:
When managing sessions while connected to a RAC I only see sessions from one node and not from all... anything I need to configure ?

.jp
Devart Team
Posts: 306
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Tue 25 Oct 2011 15:13

Could you please clarify what sessions you would like to see and provide a screenshot. If these are sessions in the Session Manager window, there is no way to see sessions for all connections. You can select only one connection from the list and see sessions only for this connection.

Yahia
Posts: 23
Joined: Tue 25 Oct 2011 09:30

Post by Yahia » Tue 25 Oct 2011 15:43

I am on exactly one connection... this connection is with a RAC (=Real Application Cluster) with 3 nodes.
So the same DB is running on 3 nodes in parallel...

When I use

SELECT * FROM GV$SESSION

I can see all active session of all 3 nodes of this one DB.

When I go into dbForge / Administration / Monitor sessions I don't see all, I just see those that come up when I use SELECT * FROM V$SESSION .

Difference is that the latter only shows the sessions from the node I am connected to while the first SELECT shows all sessions for all 3 nodes of this DB.

My question is: How can I configure dbForge show me all sessions in the (one) DB I am connected to ?

Thanks in advance
Yahia

.jp
Devart Team
Posts: 306
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Wed 26 Oct 2011 08:45

We've just reviewed your question once again and came to the conclusion that you have to click the 'Full session information' on the Session Manager toolbar to make all sessions display in the 'Session Manager' window since they are filtered once you open the 'Session Manager' window. Please let us know if this is what you asked for.

We have put some changes connected to this functionality to our development plan and will implement them shortly.

Yahia
Posts: 23
Joined: Tue 25 Oct 2011 09:30

Post by Yahia » Wed 26 Oct 2011 09:56

No - that still shows the same sessions but with a different set of columns...

Please check with a RAC with at least 2 nodes... The difference lies in the used view to gather the session information... in a RAC you need to use GV$SESSION instead of V$SESSION to get really ALL sessions from ALL nodes on the DB.

alexa
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Post by alexa » Wed 26 Oct 2011 11:34

We have put the support of reading sessions from the GV$SESSION to our development plan and will implement the new change in one of our future releases.

Yahia
Posts: 23
Joined: Tue 25 Oct 2011 09:30

Re: Problem with Win2008R2 64 Bit/Oracle 11.2.0.1 64 bit

Post by Yahia » Sat 15 Nov 2014 09:27

any news on RAC support?

alexa
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Problem with Win2008R2 64 Bit/Oracle 11.2.0.1 64 bit

Post by alexa » Mon 17 Nov 2014 13:33

It's still in the queue for investigation.

Yahia
Posts: 23
Joined: Tue 25 Oct 2011 09:30

Re: Problem with Win2008R2 64 Bit/Oracle 11.2.0.1 64 bit

Post by Yahia » Mon 17 Nov 2014 14:34

3 years ago you wrote that this feature in on your ToDo-List for a future release...
It would be really helpfull to have at least a timeframe...

Post Reply