PL/SQL Developer Crash in Citrix

[roujeh]

Hello All

I am having issues with PL/SQL v7.0.2.1076 in Citrix, where each time the server with PL/SQL installed reboots, PL/SQL fails to launch on first attempt and generates a blank error message box with an OK button.

Im not sure if there is a registry fix for this or not.

Also, when PL/SQL is launched, there is a pop up about upgrading to version 10. I'm not sure if we can use the existing license for this?

Any help would be appreciated, thanks.

Roujeh

-------------------------------------------
PL/SQL Developer
Version 7.0.2.1076 (MBCS)
194.36633 - 50 user license
Windows XP version 5.5 (build 3790) Service Pack 2

Physical memory : 2,097,152 kB (1,509,284 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (2,022,136 available)

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

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

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\\default.ini

Plug-Ins

Homes
OraClient10g_home1 (C:\oracle\product\10.2.0\client_1)

DLLs
C:\oracle\product\10.2.0\client_1\bin\oci.dll

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

Using
Home: OraClient10g_home1
DLL: C:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: version 9.2

-------------------------------

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
VOBHOME2.0 = C:\oracle\product\10.2.0\client_1

SOFTWARE\ORACLE\JInitiator

SOFTWARE\ORACLE\JInitiator\1.3.1.28
JavaHome = C:\Program Files\Oracle\JInitiator 1.3.1.28

SOFTWARE\ORACLE\KEY_OraClient10g_home1
ORACLE_HOME_NAME = OraClient10g_home1
ORACLE_GROUP_NAME = Oracle - OraClient10g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = ENGLISH_AUSTRALIA.WE8MSWIN1252
StatementCacheSize = 0
StmtCacheSize = 0
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient10g_home1
SQLPATH = C:\oracle\product\10.2.0\client_1\dbs
MSHELP_TOOLS = C:\oracle\product\10.2.0\client_1\MSHELP
ORACLE_HOME = C:\oracle\product\10.2.0\client_1
OLEDB = C:\oracle\product\10.2.0\client_1\oledb\mesg
OO4O = C:\oracle\product\10.2.0\client_1\oo4o\mesg

SOFTWARE\ORACLE\KEY_OraClient10g_home1\ODP.NET
TraceLevel = 0
TraceOption = 0
StatementCacheSize = 0
TraceFileName = C:\ODPNET.trc

SOFTWARE\ORACLE\KEY_OraClient10g_home1\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
TraceFileName = C:\OraOLEDB.trc

SOFTWARE\ORACLE\KEY_OraClient10g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
PerBlock = 16
SliceSize = 256
OO4O_HOME = C:\oracle\product\10.2.0\client_1\oo4o
HelpFile = C:\oracle\product\10.2.0\client_1\oo4o\doc\oracleo.hlp
TempFileDirectory = C:\temp

 

[Marco Kalter]

I am having issues with PL/SQL v7.0.2.1076 in Citrix, where each time the server with PL/SQL installed reboots, PL/SQL fails to launch on first attempt and generates a blank error message box with an OK button.

It is odd that this only happens the first time after a reboot. To verify if this is a privilege issue, can you start PL/SQL Developer as administrator after the next reboot?

Also, when PL/SQL is launched, there is a pop up about upgrading to version 10. I'm not sure if we can use the existing license for this?

To upgrade to 10.0 you can purchase an Annual Service Contract for a 50 User License, which costs USD 700 and entitles you to upgrades (including 10.0) and technical support for the period of 1 year.