PL/SQL Developer does not start

[Anton Swaneveld]

After installing PL/SQL on a pentium 4 3Ghz machine the program hangs when starting.
When i install PL/SQL on a pentium 4 2.6Ghz machine the program starts correct. Both machine work with Windows XP Proffesional SP1 and have 512mb memory.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the 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.

 

[Anton Swaneveld]

PL/SQL Developer 6.0.6.947 02.16873 - 5 user license
C:\Program Files\PLSQL Developer\plsqldev.exe

27-4-2006 17:19:12 Application started
27-4-2006 17:19:12 InitPreferences
27-4-2006 17:19:12 Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
27-4-2006 17:19:12 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
27-4-2006 17:19:12 PreferenceSet.Load OK
27-4-2006 17:19:12 Load C:\Program Files\PLSQL Developer\Preferences\manz818118 = 0
27-4-2006 17:19:12 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\manz818118\default.ini
27-4-2006 17:19:12 PreferenceSet.Load OK
27-4-2006 17:19:12 PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\manz818118\user.prefs
27-4-2006 17:19:12 PreferenceSet.Load OK
27-4-2006 17:19:12 InitPreferences end
27-4-2006 17:19:12 SortPreferenceSets
27-4-2006 17:19:12 - Default manz818118
27-4-2006 17:19:12 - System Default
27-4-2006 17:19:12 LoadPreferences
27-4-2006 17:19:12 LoadPreferences searching for default
27-4-2006 17:19:12 C:\Program Files\PLSQL Developer\Preferences\manz818118\default.ini
27-4-2006 17:19:13 LoadPreferences end
27-4-2006 17:19:13 FormCreate Logon.Execute
27-4-2006 17:19:26 LogonHistorySave start
27-4-2006 17:19:26 ChangeUserPref LogonHistory,
27-4-2006 17:19:26 ChangeUserPref DSA,
27-4-2006 17:19:26 ChangeUserPref end
27-4-2006 17:19:26 ChangeUserPref ColumnAssociations,
27-4-2006 17:19:26 ChangeUserPref end
27-4-2006 17:19:26 ChangeUserPref ImportAssociations,
27-4-2006 17:19:26 ChangeUserPref end
27-4-2006 17:19:26 ChangeUserPref BrowserFilters,
27-4-2006 17:19:26 ChangeUserPref end
27-4-2006 17:19:26 ChangeUserPref BrowserFolders,
27-4-2006 17:19:26 ChangeUserPref end
27-4-2006 17:19:26 ChangeUserPref SessionQueries,
27-4-2006 17:19:26 ChangeUserPref end
27-4-2006 17:19:26 ChangeUserPref ExternalTools,
27-4-2006 17:19:26 ChangeUserPref end
27-4-2006 17:19:26 ChangeUserPref Documents,
27-4-2006 17:19:26 ChangeUserPref end
27-4-2006 17:19:26 ChangeUserPref Reports,
27-4-2006 17:19:26 ChangeUserPref end
27-4-2006 17:19:26 LogonHistorySave end
27-4-2006 17:19:26 FormCreate Session.Connected
27-4-2006 17:19:26 FormCreate Logon.Executed -1
27-4-2006 17:19:26 FormCreate TDBNames.Make
27-4-2006 17:19:26 FormCreate SessionChanged
27-4-2006 17:19:26 SessionChanged SetDBAViews
27-4-2006 17:19:26 SessionChanged Authorizations.Load
27-4-2006 17:19:26 Oracle Error: Session.
ORA-00942: Tabel of view bestaat niet.
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)
27-4-2006 17:19:26 SessionChanged EnableAuthorizedMenus
27-4-2006 17:19:26 SessionChanged SetSessionAction
27-4-2006 17:19:26 SetSessionAction starts: Main session
27-4-2006 17:19:26 SetSessionAction ends
27-4-2006 17:19:26 SessionChanged ExecuteConnectScript
27-4-2006 17:19:26 ExecuteConnectScript starts
27-4-2006 17:19:26 ExecuteConnectScript ends
27-4-2006 17:19:26 SessionChanged LoadRecentObjects
27-4-2006 17:19:26 SessionChanged Notify children
27-4-2006 17:19:26 SessionChanged Logoff secondary sessions
27-4-2006 17:19:26 SessionChanged SessionMode = smMulti
27-4-2006 17:19:26 SessionChanged EnableChildFunctions
27-4-2006 17:19:26 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: D:\oracle\ora92
Found: oci.dll
Using: D:\oracle\ora92\bin\oci.dll

 

[Marco Kalter]

It seems thing go bad when loading the OCI library (D:\oracle\ora92\bin\oci.dll). Can you still use SQL*Plus or other Oracle client tools?

 

[Anton Swaneveld]

After entering the userid pwd and environment on the login panel the program "hangs". When instead of entering the userid, pwd etc on the login panel i press cancel and connect from the main panel the programs does not function properly also. Again this only happens on a certain type of pc (i tested on 2 machines with the same specifications). On other pc's this does not occur and i can work with PL/SQL.

 

[Marco Kalter]

Can you still use SQL*Plus or other Oracle client tools?

 

[Anton Swaneveld]

I have downloaded the trial version and installed it. With this version i do not have the reported "problem" that the program hangs when starting. How can i register the trial version with the product key we have for version PL/SQL Developer 6.06 ?