9.0.4.1644 on W2K8 R2 SP1 File Type registration not allowed

[JDietz]

Hello,

it seems that file type registration with PLSQL Dev 9.0.4.1644 on W2K8 R2 SP1 (fully patched) is broken => the error message box says: "Could not register file types, please run as administrator".

We tried the same with "run as administrator" on plsqldev.exe and also logged in as local and domain admin account but every try gave us the same message box.

I also reinstalled PLSQL Developer but it still refuses to register the file types.

BTW: file type registering works very well on my Win 7 Laptop when I use "run as administrator" on the plsqldev.exe.

I haven't tried it out with older 9.0.x versions.

Here' the debug output:

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

Physical memory : 4.194.304 kB (4.194.304 available)
Paging file : 4.194.304 kB (4.194.304 available)
Virtual memory : 2.097.024 kB (1.973.596 available)

Parameters
C:\Program Files 32\PLSQL Developer\plsqldev.exe
debug

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files

Plug-Ins

02.02.2012 14:55:46 Application started
02.02.2012 14:55:46 InitPreferences
02.02.2012 14:55:46 Load C:\Program Files 32\PLSQL Developer\Preferences\Default = 0
02.02.2012 14:55:46 PreferenceSet.Load C:\Program Files 32\PLSQL Developer\Preferences\Default\Default.ini
02.02.2012 14:55:46 PreferenceSet.Load OK
02.02.2012 14:55:46 Determine LocalPrefPath
02.02.2012 14:55:46 [1]: C:\Users\jdietz\AppData\Roaming\PLSQL Developer\Preferences
02.02.2012 14:55:46 LocalPrefPath: C:\Users\jdietz\AppData\Roaming\PLSQL Developer\Preferences\jdietz
02.02.2012 14:55:46 Load C:\Users\jdietz\AppData\Roaming\PLSQL Developer\Preferences\jdietz = 0
02.02.2012 14:55:46 PreferenceSet.Load C:\Users\jdietz\AppData\Roaming\PLSQL Developer\Preferences\jdietz\default.ini
02.02.2012 14:55:46 PreferenceSet.Load OK
02.02.2012 14:55:46 PreferenceSet.Load C:\Users\jdietz\AppData\Roaming\PLSQL Developer\Preferences\jdietz\user.prefs
02.02.2012 14:55:46 PreferenceSet.Load OK
02.02.2012 14:55:46 InitPreferences end
02.02.2012 14:55:46 SortPreferenceSets
02.02.2012 14:55:46 - Default jdietz
02.02.2012 14:55:46 - System Default
02.02.2012 14:55:46 DoUpdateChildList
02.02.2012 14:55:46 pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
02.02.2012 14:55:46 ReadString OK
02.02.2012 14:55:46 pfReadRegistry: "C:\Program Files 32\PLSQL Developer\PLSQLDev.exe" "%1"
02.02.2012 14:55:46 LoadPreferences
02.02.2012 14:55:46 LoadPreferences searching for default
02.02.2012 14:55:46 C:\Users\jdietz\AppData\Roaming\PLSQL Developer\Preferences\jdietz\default.ini
02.02.2012 14:55:46 LoadPreferences NewPref := nil
02.02.2012 14:55:46 LoadPreferences
02.02.2012 14:55:46 LoadPreferences Reading preferences
02.02.2012 14:55:46 LoadPreferences ReadPosition
02.02.2012 14:55:46 LoadPreferences ToolsBrowserItemClick(nil)
02.02.2012 14:55:46 LoadPreferences CreateBrowserFilters...
02.02.2012 14:55:46 LoadPreferences Files
02.02.2012 14:55:46 LoadPreferences Buttons
02.02.2012 14:55:46 LoadPreferences Printer
02.02.2012 14:55:46 LoadPreferences FileBrowserFolders
02.02.2012 14:55:46 LoadPreferences Connections
02.02.2012 14:55:46 LoadPreferences BrowserFolders
02.02.2012 14:55:46 LoadPreferences
02.02.2012 14:55:46 LoadPreferences end
02.02.2012 14:55:46 MacroLibFilename: C:\Program Files 32\PLSQL Developer\Macro\jdietz.emlib
02.02.2012 14:55:48 FormCreate Logon.Executed 0
02.02.2012 14:55:48 FormCreate SessionChanged
02.02.2012 14:55:48 SessionChanged SetDBAViews
02.02.2012 14:55:48 SessionChanged Authorizations.Load
02.02.2012 14:55:48 SessionChanged EnableAuthorizedMenus
02.02.2012 14:55:48 WindowAllowed(1)
02.02.2012 14:55:48 WindowAllowed done
02.02.2012 14:55:48 WindowAllowed(1)
02.02.2012 14:55:48 WindowAllowed done
02.02.2012 14:55:48 ExecuteConnectScript starts
02.02.2012 14:55:48 ExecuteConnectScript ends
02.02.2012 14:55:48 SessionChanged LoadRecentObjects
02.02.2012 14:55:48 SessionChanged Notify children
02.02.2012 14:55:48 SessionChanged Logoff secondary sessions
02.02.2012 14:55:48 SessionChanged EnableChildFunctions
02.02.2012 14:55:48 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1_32bit
OracleHomeDir: C:\Oracle\product\11.2.0\client_1
Found: oci.dll
Using: C:\Oracle\product\11.2.0\client_1\bin\oci.dll
02.02.2012 14:55:48 Lock
02.02.2012 14:55:48 UnLock
02.02.2012 14:55:48 Lock
02.02.2012 14:55:48 UnLock
02.02.2012 14:55:49 SortPreferenceSets
02.02.2012 14:55:49 - Default jdietz
02.02.2012 14:55:49 - System Default
02.02.2012 14:55:49 Lock
02.02.2012 14:55:49 UnLock
02.02.2012 14:55:49 DoUpdateChildList
02.02.2012 14:55:49 FormActivate start
02.02.2012 14:55:49 FormActivate end
02.02.2012 14:55:49 WMUpdatePopups starts
02.02.2012 14:55:49 LoadDesktop starts
02.02.2012 14:55:49 DoUpdateChildList
02.02.2012 14:55:49 Lock
02.02.2012 14:55:49 Lock
02.02.2012 14:55:49 UnLock
02.02.2012 14:55:49 UnLock
02.02.2012 14:55:49 LoadDesktop ends
02.02.2012 14:55:49 WMUpdatePopups ends
02.02.2012 14:55:55 SortPreferenceSets
02.02.2012 14:55:55 - Default jdietz
02.02.2012 14:55:55 - System Default
02.02.2012 14:56:04 Preference changed: DiaOthExt
02.02.2012 14:56:04 Preference changed: DiaOthExt
02.02.2012 14:56:05 PreferenceForm.DialogToPrefSet
02.02.2012 14:56:05 - PrefAutomaticStatistics = True
02.02.2012 14:56:05 - SelectedStatNames =
02.02.2012 14:56:05 - SqlOthExt =
02.02.2012 14:56:05 - RepOthExt =
02.02.2012 14:56:05 - TstOthExt =
02.02.2012 14:56:05 - CmdOthExt =
02.02.2012 14:56:05 - DiaOthExt =
02.02.2012 14:56:05 - [KeyConfiguration]
02.02.2012 14:56:05
02.02.2012 14:56:05 PreferenceForm.DialogToPrefSet
02.02.2012 14:56:05 - PrefAutomaticStatistics = True
02.02.2012 14:56:05 - SelectedStatNames =
02.02.2012 14:56:05 - SqlOthExt =
02.02.2012 14:56:05 - RepOthExt =
02.02.2012 14:56:05 - TstOthExt =
02.02.2012 14:56:05 - CmdOthExt =
02.02.2012 14:56:05 - DiaOthExt =
02.02.2012 14:56:05 - [KeyConfiguration]
02.02.2012 14:56:05
02.02.2012 14:56:05 PreferenceSet.Save
02.02.2012 14:56:05 PreferenceSet Filename = C:\Users\jdietz\AppData\Roaming\PLSQL Developer\Preferences\jdietz\default.ini
02.02.2012 14:56:05 PreferenceSet AltFile = default.ini
02.02.2012 14:56:05 PreferenceSet.Save end
02.02.2012 14:56:05 ChangeUserPref , LastNewsRead
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref , LastNewsItem
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref , LastUpdateItem
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref LogonHistory,
02.02.2012 14:56:05 ChangeUserPref DSA,
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref ColumnAssociations,
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref ImportAssociations,
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref BrowserFilters,
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref FileBrowserFolders,
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref Connections,
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref BrowserFolders,
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref SessionQueries,
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref ExternalTools,
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref Documents,
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref Reports,
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 ChangeUserPref CurrentConnections,
02.02.2012 14:56:05 ChangeUserPref end
02.02.2012 14:56:05 SortPreferenceSets
02.02.2012 14:56:05 - Default jdietz
02.02.2012 14:56:05 - System Default
02.02.2012 14:56:06 Lock
02.02.2012 14:56:06 UnLock
02.02.2012 14:56:06 DoUpdateChildList
02.02.2012 14:56:06 Lock
02.02.2012 14:56:06 Lock
02.02.2012 14:56:06 UnLock
02.02.2012 14:56:06 UnLock
02.02.2012 14:56:06 pfWriteRegistry(PL/SQL Developer, FileTypes)
02.02.2012 14:56:06 Elevating...
02.02.2012 14:56:06 InitElevate: 2008 detected, don't elevate
02.02.2012 14:56:06 InitElevate: Failed
02.02.2012 14:56:06 pfWriteRegistry: 0
02.02.2012 14:56:06 pfRegisterFileType(fnc, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(prc, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(trg, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(pck, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(typ, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(tps, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(tpb, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(jsp, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(tst, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(sql, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(rep, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(pdc, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(pdd, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(prj, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterFileType(dsk, PL/SQL Developer)
02.02.2012 14:56:06 pfRegisterApplication(PL/SQL Developer)

Regards,
Juergen

 

[Marco Kalter]

This does indeed not work on Windows Server 2008R2. You will need to manually associate the file types to PL/SQL Developer.

 

[JDietz]

Hallo Marco,

will this be fixed in the near future? File type registration worked well with PLSQL Dev 8.x on W2K8 R2 (as admin).
This imho is a very time saving feature because we have a lot of development servers with lots of different (Windows) users and manually registering file types takes a lot of time.

We also still have problems with setting our own PLSQL Dev default parameters (see also one of my prev. threads):

We can't manage to find a proper way to innately deactivate certain options (especially the new (imho pesky) "multiple connections" feature) when we upgrade from an existing 8.x version to 9.0.x.
My modified "default.ini" which turns of unwanted options is not taken in account when I make an upgrade installation. The modified "default.ini" works only for new installation.

The "multiple connections default on" feature is dangerous because you can work on different instances without having a clear "marker" whether you are on a development or a production instance. You can easily hit execute on the wrong connected window by chance and then in the worst case you have to recover the instance.

Also the "SQL Window"'s "Auto execute default on" setting can be very dangerous if you are used to "single statement" execution. Imagine you have a SQL window/script with different statements in and further down below there's a "truncate" or "drop table" in - it's not a good idea to have it default set to auto execution. We all work on different servers and once you are used to you own setting. Normally you don't check the current PLSQL Dev settings on the current system first. If it's a brand new server then you have all those dangerous settings default set to "on".

Would you consider to preset certain features/options to "off" for new and particularly for upgrade installations in the future? This would make working with PLSQL Dev on different machines much more safer.

Regards,
Juergen

 

[Marco Kalter]

I'm not sure. I think this is a security restriction on Windows Server 2008.

 

[JDietz]

It's strange because file type registration works on W2K8 R2 with PLSQL Dev 8.x when the plsqldev.exe is executed as admin.

Nevertheless trying to register the file types with PLSQL Dev 8/9 and not using admin privs leads to a shutdown of Windows or renders the Windows session unuseable

Have you also read my worries about the "unfortunate" default setting values for some (new) PLSQL Developer settings (especially the multiple connection feature)?

Thanks,
Juergen

 

[JDietz]

Hello Marco,

do you have any news?

Regards,
Juergen

 

[Marco Kalter]

For the default "Allow Multiple Connections" settings we'll have a new pinning option in the next release. By default a window connection will be "unpinned", so it will follow the main connection. You will need to explicitly pin the window connection to override this, so it will be a lot safer.