Connection hangs

[debuggingIT]

Using PL/SQL Developer 7.1.0.1337 with OCI version 8.1. Just running Windows 2004 SP4.

I have problems connecting to an Oracle database where PL/SQL Developer just hangs with no apparent error message. Is there a way to trouble shoot what the problem is? I notice similar problems in other posts but was unable to generate a log e.g."C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql to perhaps shine some light on the problem.

I can connect to other oracle databases with the tool and I can use e.g. toad or command line to connect to the database I have problems with. I don't have the OS details but another machine on the same company network have also been able to connect to the db I have problems with.

No idea what the PL/SQL Developer startup sequence is actaully doing, can anyone advise on the best course of action to resolve my connection problem as it does seem local?

Cheers,

 

[Marco Kalter]

The DEBUGSQL parameter is the best option. The debug.txt file should be created in the PL/SQL Developer installation directory, but if it isn't, perhaps you can verify if you have write privileges in that directory?

 

[debuggingIT]

Yip, lock down on writting to program files folder for mere mortals! Got a colleague with access to run through the login process and generate a debug.txt file. I will send full file to your e-mail address.

 

[debuggingIT]

Thanks Marco, that sorted it!

Installed 7.1.4 and disabled Unicode support via the tools options, preferences, Oracle/options.

Back to debugging joy.