Connecting to Scan Listeners

[MattS]

We have about 30 licenses in our office with a mix of 8.x and 9.x. When connecting to our RAC databases, some of them on Oracle Database Appliances using SCAN listeners, the 8.x seems to work fine but 9.x will hang when trying to query data. We can go through the list of objects etc but as soon as I select data even "select * from dual;" the window sticks at "Initializing" and the whole plsqldeveloper stops responding.

Connecting to older VIP listeners works but the new SCAN does not.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the 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 or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).