32Bit DB Driver for 64Bit Developer??

[Ron E]

I'm trying to debug an issue with somebody who gets ORA-12560 -Protocol Adapter Error only when trying to export a table. When I looked at my setup, I noticed that the connection dropdowns only show the 32Bit Home and OCI entries, even though both 32 and 64Bit are installed, and the PL/SQL Developer shows the 64Bit version. The Export screen Executable box also shows the 32Bit version. Is that a problem? If so, how do we choose the 64Bit versions?

Thanks

Ron

 

[Marco Kalter]

PL/SQL Developer is a 32 Bit application, so it can only interface with a 32 Bit Oracle Client. A 64 Bit client is in essence invisible to a 32 Bit application.

 

[Ron E]

My fault. I was reading the information box wrong. I saw 64 bit, but it was really saying it was running on Windows 7 (64 bit). I could have sworn that the newer versions were 64 bit.

Well, with that not an issue, can you think of anywhere to look to find why he's getting the ORA-12560 error immediately when he clicks on Table Export? I've sent him the request to turn debug on and send me the log file, but haven't received anything back from him yet.

Thanks,

Ron

 

[Marco Kalter]

I assume you are using Oracle export format? If so, can you check if the exp.exe utility is functioning correctly?

 

[Ron E]

How would I know if it's operating correctly? It seems to work, but when I look at the log, I get this, and nothing written out. (I can duplicate it on my PC now, so I have a bit more control of logs, etc. now.)

Export started on 8/5/2014 4:05:52 PM
C:\ORACLE\ora112_32_home\bin\exp.exe parfile=C:\Users\rle4550\AppData\Local\Temp\plsexp.par

EXP-00056: ORACLE error 12560 encountered
ORA-12560: TNSrotocol adapter error
EXP-00000: Export terminated unsuccessfully

Export finished on 8/5/2014 4:05:53 PM

 

[Ron E]

I added the DebugSQL, opened a new program, went into Table Export and chose the table and target. When I clicked on Export, the log said "Export Started", but nothing else. It didn't give the error this time. When I looked for the log file in the user folder, there was nothing in that directory except a Preferences folder and a file called PLSRecall.dat from about an hour ago. It looked like that file had SQL in it from when I first started running today, but nothing about the Export.

Ron

 

[Marco Kalter]

You can try to use the exp.exe utility from the Windows Command Line. Just start it, make a connection, and check if this also raises an "ORA-12560: TNSrotocol adapter error" exception.