PL/SQL Dev compiled as 64bit

[jellegaa]

I am aware of that PL/SQL Dev cannot use a x64 oracle client, due to beeing a 32 bit application it self.
However, 64 bit clients are getting more and more common in developer teams due to heavy memory requirements.
I am not too fond of installing both 32 and 64 bit oracle clients on same machine - does it work at all?
So how about making a 64bit build of the PL/SQL Dev? Now a days it is rarely such a big deal to do it.

Note: I cannot do without the 64 bit oracle client due to that our own applications need it.

 

[Marco Kalter]

I am not too fond of installing both 32 and 64 bit oracle clients on same machine - does it work at all?

Yes, this works fine.

I am not too fond of installing both 32 and 64 bit oracle clients on same machine - does it work at all?

PL/SQL Developer is written in Delphi. The first thing that needs to become available is a 64 bit version of the Delphi IDE.

 

[jellegaa]

Now I have both x64 and x86 oracle client installed. x64 works fine, and on the x86 the oracle net manager is testing connection ok. But using PL/SQL Dev, I am getting the "ORA-12154 TNS:could not resolve service name". Tried everything known to mankind related to this error message. Normally I could fix it really easy, but now I can't make it work.
Any suggestions?

 

[Gustavo]

Have you tried to specify the Oracle Home in Tools --> Preferences --> Oracle --> Connection?

 

[Marco Kalter]

You should probably review the tnsnames.ora file from the 32 bit home, and/or enable tracing in the sqlnet.ora file to see what exactly Oracle Net is doing.

To ensure that the 32 bit client is working you can use the sqlplus.exe and tnsping.exe tools from that home.

 

[jellegaa]

Logging did it, thanks.
The ORACLE_HOME environment variable was some how changed to nothing. Pointing it to the x86 client makes pl/sql dev work.

But what should it be, now having 2 clients?

 

[Marco Kalter]

Ideally you shouldn't have an ORACLE_HOME environment variable. Are you perhaps using an Oracle Instant Client?