application crashing on standby database

[xplanasp]

Hi,
every time we try to select the data grid on a standby database PLSQL Developer crashes unexpectly. We've reproduced this behavior under our current licensed version ( 6 ) and also with 7 trial version.
We've only been able to track this issue under our standby database, but as is our reporting environment is becoming an annoiance.
Is there any known bug related to this subject? Any way to workaround to this trouble?
Regards.
Xavi

 

[Marco Kalter]

How exactly does it crash? Any error messages?

 

[xplanasp]

We have no error messages, the applications just crashes silently as soon as we click on the data grid.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the PL/SQL Developer 7 shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[xplanasp]

Marco,
I've launched plsqldev as you've told, then I've connected to standby database and I've typed "select * from dual", I've click on data grid and the application have crashed again, but no debug.txt seems to be generated.
Xavi.

 

[Marco Kalter]

Do you have write access to the PL/SQL Developer 7 installation directory? If so, a debug.txt file will immediately be created when you launch PL/SQL Developer 7 with the debugsql parameter.

 

[Holger Dors]

We have the same problem, albeit intermixed with a couple of "Access violation at address 00000000. Read of address 00000000" exception messages.

Interestingly, when running against the same DB, an application we made using DOA shows pretty much the same problems. Unfortunately, both aren't reproducible, but a colleague of mine managed to get a debug log; I'll mail it to you soon.

 

[xplanasp]

Marco,
I've write access on PLSQL Developer directory. I've tried to generate the log file creating an empty debug.txt but unfortunately this have not generated any output to this file under plsqldev install directory.
I'm running PLSQL version 6.0.5.

 

[Marco Kalter]

You will need to use PL/SQL Developer 7 trial version for this.