8.0.3.1510 crashes at startup with Access violation in module ntdll.dlll

[jimmo]

Greetings!

We are running PL/SQL Developer Version 8.0.3.1510 on Windows 2008 Server SP1 on VMWare. Sometimes when it starts, right after we input the login data, we get error messages like this:

Access violation at address 77E43DE4 in module ntdll.dll.

the address differs each time and we can login several times before the problem occurs again. I cannot see any pattern as to when this occurs. (e.g. only specific users or only specific databases)

I have googled and found several references to acccess violations in ntdll.dll and the cause mentioned is either a bug in the application (pl/sql developer in our case) or filesystem corruption. In the "PL/SQL Developer - News" I found nothing to indicate that this is a known bug.

An info or suggestions on how to correct this would be appreciated.

Regards,

jimmo

 

[Marco Kalter]

Does the error message refer to a plsqldev.elf file? If so, can you send it to me?

 

[jimmo]

Thanks for the reply. There is no reference to plsqldev.elf in the error message.

 

[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).

 

[jimmo]

Here is the contents of the debug.txt. Thank you very much for your assistance.

Regards,

jimmo
===================
PL/SQL Developer
Version 8.0.3.1510
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4.193.848 kB (1.801.856 available)
Paging file : 4.194.304 kB (4.194.304 available)
Virtual memory : 2.097.024 kB (1.975.420 available)

Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe
DebugSQL

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files

Plug-Ins

06.02.2012 09:25:17 Application started
06.02.2012 09:25:17 InitPreferences
06.02.2012 09:25:17 Load C:\Program Files (x86)\PLSQL Developer\Preferences\Default = 0
06.02.2012 09:25:17 PreferenceSet.Load C:\Program Files (x86)\PLSQL Developer\Preferences\Default\Default.ini
06.02.2012 09:25:17 PreferenceSet.Load OK
06.02.2012 09:25:17 Determine LocalPrefPath
06.02.2012 09:25:17 [1]: C:\Users\jammoh12035\AppData\Roaming\PLSQL Developer\Preferences
06.02.2012 09:25:17 LocalPrefPath: C:\Users\jammoh12035\AppData\Roaming\PLSQL Developer\Preferences\jammoh12035
06.02.2012 09:25:17 Load C:\Users\jammoh12035\AppData\Roaming\PLSQL Developer\Preferences\jammoh12035 = 0
06.02.2012 09:25:17 PreferenceSet.Load C:\Users\jammoh12035\AppData\Roaming\PLSQL Developer\Preferences\jammoh12035\default.ini
06.02.2012 09:25:18 PreferenceSet.Load OK
06.02.2012 09:25:18 PreferenceSet.Load C:\Users\jammoh12035\AppData\Roaming\PLSQL Developer\Preferences\jammoh12035\user.prefs
06.02.2012 09:25:18 PreferenceSet.Load OK
06.02.2012 09:25:18 InitPreferences end
06.02.2012 09:25:18 SortPreferenceSets
06.02.2012 09:25:18 - Default jammoh12035
06.02.2012 09:25:18 - System Default
06.02.2012 09:25:18 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
06.02.2012 09:25:18 ReadString OK
06.02.2012 09:25:18 pfReadRegistry: "C:\Program Files (x86)\PLSQL Developer\PLSQLDev.exe" "%1"
06.02.2012 09:25:18 LoadPreferences
06.02.2012 09:25:18 LoadPreferences searching for default
06.02.2012 09:25:18 C:\Users\jammoh12035\AppData\Roaming\PLSQL Developer\Preferences\jammoh12035\default.ini
06.02.2012 09:25:18 LoadPreferences NewPref := nil
06.02.2012 09:25:18 LoadPreferences
06.02.2012 09:25:18 LoadPreferences Reading preferences
06.02.2012 09:25:18 LoadPreferences ReadPosition
06.02.2012 09:25:18 LoadPreferences ToolsBrowserItemClick(nil)
06.02.2012 09:25:18 LoadPreferences CreateBrowserFilters...
06.02.2012 09:25:18 LoadPreferences Files
06.02.2012 09:25:18 LoadPreferences Logon
06.02.2012 09:25:18 LoadPreferences Buttons
06.02.2012 09:25:18 LoadPreferences Printer
06.02.2012 09:25:18 LoadPreferences FileBrowserFolders
06.02.2012 09:25:18 LoadPreferences BrowserFolders
06.02.2012 09:25:18 LoadPreferences
06.02.2012 09:25:18 LoadPreferences end
06.02.2012 09:25:18 MacroLibFilename: C:\Program Files (x86)\PLSQL Developer\Macro\jammoh12035.emlib
06.02.2012 09:25:18 FormCreate Logon.Execute
06.02.2012 09:25:20 TOracleSession PLSQLDevForm.Session Start Session.LogOn as support@fodbi3-test
06.02.2012 09:25:20 TOracleSession PLSQLDevForm.Session End
Result = Access violation at address 77E43E0D in module 'ntdll.dll'. Read of address 013CBDFA
Duration = 0,015
06.02.2012 09:25:27 LogonHistorySave start
06.02.2012 09:25:27 ChangeUserPref LogonHistory,
06.02.2012 09:25:27 ChangeUserPref DSA,
06.02.2012 09:25:27 ChangeUserPref end
06.02.2012 09:25:27 ChangeUserPref ColumnAssociations,
06.02.2012 09:25:27 ChangeUserPref end
06.02.2012 09:25:27 ChangeUserPref ImportAssociations,
06.02.2012 09:25:27 ChangeUserPref end
06.02.2012 09:25:27 ChangeUserPref BrowserFilters,
06.02.2012 09:25:27 ChangeUserPref end
06.02.2012 09:25:27 ChangeUserPref FileBrowserFolders,
06.02.2012 09:25:27 ChangeUserPref end
06.02.2012 09:25:27 ChangeUserPref BrowserFolders,
06.02.2012 09:25:27 ChangeUserPref end
06.02.2012 09:25:27 ChangeUserPref SessionQueries,
06.02.2012 09:25:27 ChangeUserPref end
06.02.2012 09:25:27 ChangeUserPref ExternalTools,
06.02.2012 09:25:27 ChangeUserPref end
06.02.2012 09:25:27 ChangeUserPref Documents,
06.02.2012 09:25:27 ChangeUserPref end
06.02.2012 09:25:27 ChangeUserPref Reports,
06.02.2012 09:25:27 ChangeUserPref end
06.02.2012 09:25:27 LogonHistorySave end
06.02.2012 09:25:27 FormCreate Session.Connected
06.02.2012 09:25:27 FormCreate Logon.Executed 0
06.02.2012 09:25:27 FormCreate TDBNames.Make
06.02.2012 09:25:27 FormCreate SessionChanged
06.02.2012 09:25:27 SessionChanged SetDBAViews
06.02.2012 09:25:27 SessionChanged Authorizations.Load
06.02.2012 09:25:27 SessionChanged EnableAuthorizedMenus
06.02.2012 09:25:27 ExecuteConnectScript starts
06.02.2012 09:25:27 ExecuteConnectScript ends
06.02.2012 09:25:27 SessionChanged LoadRecentObjects
06.02.2012 09:25:27 SessionChanged Notify children
06.02.2012 09:25:27 SessionChanged Logoff secondary sessions
06.02.2012 09:25:27 SessionChanged SessionMode = smMulti
06.02.2012 09:25:27 SessionChanged EnableChildFunctions
06.02.2012 09:25:27 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient10g_home2
OracleHomeDir: C:\oracle\product\10.2.0\client_2
Found: oci.dll
Using: C:\oracle\product\10.2.0\client_2\oci.dll
06.02.2012 09:25:27 SortPreferenceSets
06.02.2012 09:25:27 - Default jammoh12035
06.02.2012 09:25:27 - System Default
06.02.2012 09:25:27 FormActivate start
06.02.2012 09:25:27 FormActivate end
06.02.2012 09:25:27 WMUpdatePopups starts
06.02.2012 09:25:27 LoadFileList: C:\Users\JAMMOH~1\AppData\Local\Temp\5\PLS-Recovery\*.cfg
06.02.2012 09:25:27 LoadFileList 0 items
06.02.2012 09:25:27 LoadFileList DateSort
06.02.2012 09:25:27 LoadDesktop starts
06.02.2012 09:25:27 DoUpdateChildList
06.02.2012 09:25:27 LoadDesktop ends
06.02.2012 09:25:27 WMUpdatePopups ends

 

[Marco Kalter]

I see that access violation occurs during logon. I see that you are using an Oracle10gR2 client. Can you update to an 11g client and try again? I'm not sure if 10.2 is certified on Windows Server 2008.

 

[jimmo]

We upgraded to PL/SQL Developer 9 and Oracle Client 11.2. However, we were still getting the error. I discovered that PL/SQL Developer was still using the path to the Oracle 10 client. Setting the system variable ORACLE_HOME had no effect at all.

Under Tools->Preferences->Oracle->Connection I set Oracle Home to the 11.2 client (C:\app\Administrator\product\11.2.0\client_1) for my user and not the system default. However PL/SQL Developer still has several things set to the Oracle 10 client as you can see in the support info below.

Is there a simply way of telling PL/SQL Developer were it needs to look for the Oracle cleint?

=====

PL/SQL Developer
Version 9.0.0.1601
01.71861 - 100 user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4.193.848 kB (2.609.088 available)
Paging file : 4.194.304 kB (4.194.304 available)
Virtual memory : 2.097.024 kB (1.873.620 available)

Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Program Files (x86)\PLSQL Developer\Preferences\Default\Default.ini
C:\Users\jammoh12035\AppData\Roaming\PLSQL Developer\Preferences\jammoh12035\default.ini

Plug-Ins

Aliases
eboxfdb-live
eboxfdb-test
fodbd3_P.world
fodbd3_T.world
fodbi3-live
fodbi3-test

Homes
OraClient10g_home2 (C:\oracle\product\10.2.0\client_2)

DLLs
C:\oracle\product\10.2.0\client_2\oci.dll

TNS File
C:\oracle\product\10.2.0\client_2\Network\Admin\tnsnames.ora

Using
Home: C:\app\Administrator\product\11.2.0\client_1
DLL: C:\oracle\product\10.2.0\client_2\oci.dll
OCI: Version 10.2
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0

Character Sets
Character size: 1 byte(s)
CharSetID: 31
NCharSetID: 2000
Unicode Support: True
NLS_LANG: GERMAN
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: WE8ISO8859P1

 

[Marco Kalter]

Perhaps you are using an Instant Client? In any case, you can go to Tools > Preferences > Oracle / Connection and enter the full path to the oci.dll file of the 11g client in the "OCI Library" field.