I learnt that pl-sql developer doesn't work with oracle 64-bit client so now i have both 32-bit and 64-bit clients installed on my machine and my ORACLE_HOME variable points to 64-bit client. I am not able to start pl/sql developer even i specify the 32-bit client in Tools->Preferences of pl-sql developer version 8.0.4.
Maybe you are using the 64-bit version of PL/SQL developer and a 32-bit Oracle Client. If so, the fix would be to switch to either a 32-bit version of PL/SQL Developer or a 64-bit Oracle client.
@maniA: I would recommend to install both since the one program needs the 64-bit version and the other the 32-bit version. Just download the client tools from the Oracle website.
It's not that the client isn't supported but if you run a 32 bit Oracle 11g client you need to run a 32 bit PLSQL installation. If you run a 64 bit Oracle 11g client you need to run a 64 bit PLSQL installation
A simple way to find this out in Windows is to run SQLPlus from your Oracle homes's bin directory and then check Task Manager. If it is a 32-bit version of SQLPlus, you'll see a process on the Processes tab that looks like this: sqlplus.exe *32 If it is 64-bit, the process will look like this: sqlplus.exe
2 I am facing to this problem so many times till I have 32bit PL/SQL Developer and 64bit Oracle DB or Oracle Client. The solution is: install a 32bit client. set PLSQL DEV-Tools-Preferencies-Oracle Home to new 32bit client Home
The problem has been solved. Actually, the issue was that the PL/SQL was 64 bit and the client was 32 bit that's why I had to download and install a 64 bit client which I installed and set the path to it's oci.dll file and that's solved my problem. One more thing I need to mention is that I have also created an environment variable for TNS_ADMIN and set the path to the folder which contains ...
Good Morning. I tell you my connection problem with pl / sql Developer. First, I will indicate my environment: -SO Windows10 64 bits. -PLSQL Developer 13 (64 bit) -Client Oracle 12-64bits. Now I pu...
