PLSQL Developer hangs on startup

M

Marcus Rangel

Member
Dear Friends,

I recently bought a 5-user license and installed it on 5 machines. They are new and identical in terms of hardware and software, but in four of them the software hangs at the splash screen, the last thing shown being "Loading Plugins". If I use the "noplugins" parameter, it hangs on the step before it. If I use "nosplash", the process stay there forever, but nothing happens. I worked with PLSQL Developer at another company and nothing like this ever happened. Does anybody knows what is happening ?

Thanks in advance
 
Marcus,

Have you tried removing any plugins from the plugin directory? The SmartEdit plugin was causing the startup to hang for me when I first started using PL/SQL Developer, I believe.

I know, if you use the nonplugins parameter it shouldn't try to load them.

Just thought this quick answer might do the trick until Marco & Co see this.

Best of luck,

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

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

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

Thanks for the answer. I did what you said, and the last lines of the file are below. Should I have this object ? How do I send you the whole file ?

...
1/18/2005 3:21:07 PM FormCreate SessionChanged
1/18/2005 3:21:07 PM SessionChanged SetDBAViews
1/18/2005 3:21:07 PM SessionChanged Authorizations.Load
1/18/2005 3:21:07 PM Oracle Error: Session.
ORA-00942: table or view does not exist
At line 2, position 5
select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
1/18/2005 3:21:07 PM SessionChanged EnableAuthorizedMenus
1/18/2005 3:21:07 PM SessionChanged SetSessionAction
1/18/2005 3:21:07 PM SetSessionAction starts: Main session
 
Ok, I found out the "authorizations" menu and created the table. It still hangs, but now it stops here:

...
1/18/2005 3:53:03 PM FormCreate Session.Connected
1/18/2005 3:53:03 PM FormCreate Logon.Executed -1
1/18/2005 3:53:03 PM FormCreate TDBNames.Make
1/18/2005 3:53:03 PM FormCreate SessionChanged
1/18/2005 3:53:03 PM SessionChanged SetDBAViews
1/18/2005 3:53:03 PM SessionChanged Authorizations.Load
1/18/2005 3:53:03 PM SessionChanged EnableAuthorizedMenus
1/18/2005 3:53:03 PM SessionChanged SetSessionAction
1/18/2005 3:53:03 PM SetSessionAction starts: Main session
1/18/2005 3:53:03 PM SetSessionAction ends
1/18/2005 3:53:03 PM SessionChanged ExecuteConnectScript
1/18/2005 3:53:03 PM ExecuteConnectScript starts
1/18/2005 3:53:03 PM ExecuteConnectScript ends
1/18/2005 3:53:03 PM SessionChanged ApplyAutoDebugInfo
1/18/2005 3:53:03 PM SessionChanged LoadRecentObjects
1/18/2005 3:53:03 PM SessionChanged Notify children
1/18/2005 3:53:03 PM SessionChanged Logoff secondary sessions
1/18/2005 3:53:03 PM SessionChanged SessionMode = smMulti
1/18/2005 3:53:03 PM SessionChanged EnableChildFunctions
1/18/2005 3:53:03 PM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME1
OracleHomeDir: C:\oracle\ora92
Found: oci.dll
Using: C:\oracle\ora92\bin\oci.dll
 
The problem seems to be related to Oracle Net. Do you have multiple Oracle Homes installed? If so, does it help if you start PL/SQL Developer without connecting, go to Tools > Preferences > Oracle/Connection page, and select a different Oracle Home from the selection list? You need to restart PL/SQL Developer before this change takes effect.
 
I totally agree with you, it has to be something related to Oracle Net. I have two homes, and I tried switching between them, with no results. I
 
Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?
 
I only see one Oracle Home in the info pages you sent, and that this is an Oracle 8.0.5 home. Perhaps you can install a later version and verify if this fixes the problem?
 
Well, it took me almost forever, but I finally nailed it. I was sure it had something to do with XP Home Edition, so I took one of the problematic Dell machines and after a nice format, installed XP Pro. For my surprise and despair, PLSQLDev hanged exactly the same way under XP Pro !!!

It had to be the hardware, right ? So, what is so special about those 6 machines ? I have no idea, but when you open their Task Manager, there is one CPU but two graphics, and when you right-click a process, you can set something else (not priority) that has two checks CPU0 and CPU1, both checked for every process.

There must be a better way to tell windows to use only one "processor" for plsqldev.exe, but I set compatibility mode to Windows 95. I worked for all six damn machines.

Marco, thanks for you support, I hope things go smoothly around here from now on. :-)
 
I assume these PC's have an Inter Pentium 4 with Hyperthreading, which is displayed as 2 CPU's in the Task Manager. This is nothing out of the ordinary of course, and does not lead to any problems in general.

I'm glad you were able to find a fix though, even though we still don't have a real clue about the cause of the problem.
 
Hmm strange. I've a Dell Dimension 8300 with XP Home edition at Home. Also with pentium 4 with HT and Pl/Sql Developer works fine. I use a 9i Rel2 home though.

Regards,
Martien
 
Martien,

I am also using a 9.2.0.5 client for PLSQLDev. By the way, It was a false alarm, I still have the problem, only it now happens after logon, during work. Trying to view or edit any source code, for example, makes plsqldev stop responding. I am sure it must be something related to hardware or device drivers, because the exact same software configuration works fine on every other machine I have. One more thing: one of my developers has a little utilitary he built with delphi, and it's not working either.
 
As you may or may not know, PL/SQL Developer is also built with Delphi. Maybe there is some system level component (DLL, driver, ...) that conflicts with Delphi applications in general. I have never encountered such a thing though.
 
I seem to be having a very similar problem, yet with my problem it seems to happen throughout the program not just at the start screen. It also seems to pop up when I have left PL/SQL for a while and then go back to it. Seems to effect everything from listing tables to submitting queries. I install another Oracle app that doesn't seem to be having this issue, and this issue seems to have just started happening recently, I can only assume its something Oracle related that I installed.
 
If PL/SQL Developer is idle for a while, it may be that a firewall is closing TCP/IP sessions. If you have such a firewall, go to Tools > Preferences > Options, and enable the "Check Connection" option. Now PL/SQL Developer will check once per minute if the session is still alive, and there will not be any long TCP/IP idle time.
 
Dear Friends,

I have done everything I could think of, and my PLSQLDev is still useless. My boss thinks I made him buy the wrong tool, people are using notepad to write and SQL*Plus to run. Dell says they have nothing to do with that, and if I were them I would say the same, I guess. AllRoundAutomations, please give some piece of advice, I have nothing else to try.
 
Does the hang-up occur during logon or when working with PL/SQL Developer? If it happens when working with PL/SQL Developer, what exactly are you doing when it hangs?
 
If I try to log in at the initial screen, it hangs right there. If I skip connection, it opens normally but hangs up mostly when I select a big package and choose the "Edit Spec and Body" option. If I never login, it sometimes hangs when I try to open the 7th or 8th file (sql files containing packages). In addition to that, sometimes it seems frozen (no CPU and no network activity) but if I wait 10 minutes it finally loads the package. If I turn off the processor hyperthreading, the login hangup never happens, but the others do.
 
A correction:

"In addition to that, sometimes it seems frozen ( **Application not responding**, no CPU and no network activity) but if I wait 10 minutes it finally loads the package."
 
SO if I understand correctly it even hangs (pauses for 10 minutes) when you are not connected to Oracle?
 
Yes, it is true. But the only thing that happens 100% of the tries is the hangup when trying to login on startup. This one is really a hangup, I waited for 3 or 4 hours and nothing happened.
 
I do not have one single problem report that is even remotely similar to this issue. I have no idea what could cause this.
 
Thanks a lot, Charlie. This procedure alone did not solve my problem, but I combined it with the latest bios upgrade from Dell and things now seem to be working.
 
I got the exact same problem with Dell machines. And to solve, I disabled the HT (hyper threading) option of the bios.
After this procedure, the PL/SQL has working fine.
 
You must log in or register to reply here.

Similar threads

Z
  • Discussion Discussion
PLSQL -> put into Result Set tabs in SQL window?
Replies
1
Views
266
Marco Kalter
Marco Kalter
W
  • Discussion Discussion
PLSQL Developer And Performance Decrease by Windows Defender
Replies
2
Views
853
Khan Zain
K
G
  • Discussion Discussion
I'm on windows. Why plyxon and not plsql developer?
Replies
1
Views
1K
Marco Kalter
Marco Kalter
B
  • Discussion Discussion
Unicode Support in PLSQL Developer
Replies
7
Views
6K
Benjamin
B
A
  • Discussion Discussion
PL/SQL Developer Version 15 Hangs Often
Replies
1
Views
797
Marco Kalter
Marco Kalter
Back
Top