Hello:
I have had a problem for the past few days where PL/SQL Developer either hangs at startup or crashes afterwards.
The program hangs after entering the password for the database. The last phase displayed in the startup windows varies.
By cancelling the initial connect password, the program does start. However, it may or may not allow me to connect to the database. Sometimes after clicking logon and entering the password, it just fails with a blank message in which all I can see is a caption of "(Not log..." and an "OK" button.
Sometimes, I get an access violation: The debug.txt which follows has: "Result = Access violation at address 778CF514 in module 'ntdll.dll'. Write of address 0B1705AC"
The failure in an earlier start said "violation at address 771E8C42 in module 'ntdll.dll'. Read of address 00080018"
Here is the latest debug.txt:
PL/SQL Developer
Version 7.1.5.1398
Windows Vista 6.0 Build 6001 (Service Pack 1)
Physical memory : 2,097,152 kB (1,872,260 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,974,604 available)
Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
debugsql
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Preference Files
Plug-Ins
6/11/2008 1:14:36 PM Application started
6/11/2008 1:14:36 PM InitPreferences
6/11/2008 1:14:36 PM Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
6/11/2008 1:14:36 PM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
6/11/2008 1:14:36 PM PreferenceSet.Load OK
6/11/2008 1:14:36 PM Determine LocalPrefPath
6/11/2008 1:14:36 PM [1]: C:\Program Files\PLSQL Developer\Preferences
6/11/2008 1:14:36 PM LocalPrefPath: C:\Program Files\PLSQL Developer\Preferences\sidney
6/11/2008 1:14:36 PM Load C:\Program Files\PLSQL Developer\Preferences\sidney = 0
6/11/2008 1:14:36 PM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\sidney\default.ini
6/11/2008 1:14:36 PM PreferenceSet.Load OK
6/11/2008 1:14:36 PM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\sidney\user.prefs
6/11/2008 1:14:36 PM PreferenceSet.Load OK
6/11/2008 1:14:36 PM InitPreferences end
6/11/2008 1:14:36 PM SortPreferenceSets
6/11/2008 1:14:36 PM - Default sidney
6/11/2008 1:14:36 PM - System Default
6/11/2008 1:14:36 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
6/11/2008 1:14:36 PM ReadString OK
6/11/2008 1:14:36 PM pfReadRegistry: "C:\Program Files\PLSQL Developer\plsqldev.exe" "%1"
6/11/2008 1:14:36 PM LoadPreferences
6/11/2008 1:14:36 PM LoadPreferences searching for default
6/11/2008 1:14:36 PM C:\Program Files\PLSQL Developer\Preferences\sidney\default.ini
6/11/2008 1:14:36 PM LoadPreferences NewPref := nil
6/11/2008 1:14:36 PM LoadPreferences <section 2>
6/11/2008 1:14:36 PM LoadPreferences Reading preferences
6/11/2008 1:14:36 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
6/11/2008 1:14:36 PM ReadString OK
6/11/2008 1:14:36 PM pfReadRegistry: "C:\Program Files\PLSQL Developer\plsqldev.exe" "%1"
6/11/2008 1:14:36 PM LoadPreferences ReadPosition
6/11/2008 1:14:36 PM LoadPreferences ToolsBrowserItemClick(nil)
6/11/2008 1:14:36 PM LoadPreferences CreateBrowserFilters...
6/11/2008 1:14:36 PM LoadPreferences Files
6/11/2008 1:14:36 PM LoadPreferences Logon
6/11/2008 1:14:36 PM LoadPreferences Buttons
6/11/2008 1:14:36 PM LoadPreferences Printer
6/11/2008 1:14:36 PM LoadPreferences BrowserFolders
6/11/2008 1:14:36 PM LoadPreferences <section 3>
6/11/2008 1:14:36 PM LoadPreferences end
6/11/2008 1:14:37 PM MacroLibFilename: C:\Program Files\PLSQL Developer\Macro\sidney.emlib
6/11/2008 1:14:41 PM TOracleSession PLSQLDevForm.Session Start Session.LogOn as indigo@stxprod
6/11/2008 1:14:41 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
6/11/2008 1:14:41 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0.015
6/11/2008 1:14:41 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
6/11/2008 1:14:41 PM TOracleQuery BytesPerCharacterQuery End (1 record processed)
Duration = 0
6/11/2008 1:14:41 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
6/11/2008 1:14:41 PM TOracleQuery Query End (1 record processed)
Duration = 0.016
6/11/2008 1:14:41 PM TOracleSession PLSQLDevForm.Session End
Duration = 0.25
6/11/2008 1:14:41 PM LogonHistorySave start
6/11/2008 1:14:41 PM ChangeUserPref LogonHistory,
6/11/2008 1:14:41 PM ChangeUserPref DSA,
6/11/2008 1:14:41 PM ChangeUserPref end
6/11/2008 1:14:41 PM ChangeUserPref ColumnAssociations,
6/11/2008 1:14:41 PM ChangeUserPref end
6/11/2008 1:14:41 PM ChangeUserPref ImportAssociations,
6/11/2008 1:14:41 PM ChangeUserPref end
6/11/2008 1:14:41 PM ChangeUserPref BrowserFilters,
6/11/2008 1:14:41 PM ChangeUserPref end
6/11/2008 1:14:41 PM ChangeUserPref BrowserFolders,
6/11/2008 1:14:41 PM ChangeUserPref end
6/11/2008 1:14:41 PM ChangeUserPref SessionQueries,
6/11/2008 1:14:41 PM ChangeUserPref end
6/11/2008 1:14:41 PM ChangeUserPref ExternalTools,
6/11/2008 1:14:41 PM ChangeUserPref end
6/11/2008 1:14:41 PM ChangeUserPref Documents,
6/11/2008 1:14:41 PM ChangeUserPref end
6/11/2008 1:14:41 PM ChangeUserPref Reports,
6/11/2008 1:14:41 PM ChangeUserPref end
6/11/2008 1:14:41 PM LogonHistorySave end
6/11/2008 1:14:41 PM FormCreate Session.Connected
6/11/2008 1:14:41 PM FormCreate Logon.Executed -1
6/11/2008 1:14:41 PM FormCreate TDBNames.Make
6/11/2008 1:14:41 PM FormCreate SessionChanged
6/11/2008 1:14:41 PM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
6/11/2008 1:14:41 PM TOracleQuery Query End (5 records processed)
Duration = 0.047
6/11/2008 1:14:41 PM SessionChanged SetDBAViews
6/11/2008 1:14:41 PM TOracleQuery $03E1E8C0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
6/11/2008 1:14:41 PM TOracleQuery $03E1E8C0 End (0 records processed)
Duration = 0.031
6/11/2008 1:14:41 PM TOracleQuery $03E1E8C0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
6/11/2008 1:14:41 PM TOracleQuery $03E1E8C0 End (0 records processed)
Duration = 0.016
6/11/2008 1:14:41 PM SessionChanged Authorizations.Load
6/11/2008 1:14:41 PM TOracleQuery $03E1E760 Start Query.Execute
SQL = select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
6/11/2008 1:14:41 PM TOracleQuery $03E1E760 End
Result = ORA-00942: table or view does not exist
Duration = 0.265
6/11/2008 1:14:41 PM SessionChanged EnableAuthorizedMenus
6/11/2008 1:14:41 PM TOracleSession $04E80EA0 Start Session.LogOn as indigo@stxprod
6/11/2008 1:14:42 PM TOracleSession $04E80EA0 End
Result = Access violation at address 778CF514 in module 'ntdll.dll'. Write of address 0B1705AC
Duration = 0.078
6/11/2008 1:14:42 PM SetSessionAction starts: Main session
6/11/2008 1:14:42 PM TOracleQuery $03E1E760 Start Query.Execute
SQL = select null from dual
6/11/2008 1:14:42 PM TOracleQuery $03E1E760 End (1 record processed)
Duration = 0.016
6/11/2008 1:14:42 PM TOracleQuery $03E1E760 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
6/11/2008 1:14:42 PM TOracleQuery $03E1E760 End
Duration = 0.031
6/11/2008 1:14:42 PM SetSessionAction ends
6/11/2008 1:14:42 PM ExecuteConnectScript starts
6/11/2008 1:14:42 PM ExecuteConnectScript ends
6/11/2008 1:14:42 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
6/11/2008 1:14:42 PM TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0.031
6/11/2008 1:14:42 PM SessionChanged: Access violation at address 778F88E8 in module 'ntdll.dll'. Write of address 0B1705A4
6/11/2008 1:14:42 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
6/11/2008 1:14:42 PM TOracleQuery PLSQLDevForm.DynamicQuery End (1 record processed)
Duration = 0.031
6/11/2008 1:14:42 PM WMUpdatePopups starts
