Hi,

I get a balnk error message when trying to logon through PL/SQL Developer published on CITRIX .

Please find the Info details as below,

PL/SQL Developer
Version 7.1.4.1389
86.46085 - 20 user license
Windows 2003 Standard Edition 5.2 Build 3790 (Service Pack 2)

Physical memory : 2,097,152 kB (2,097,152 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,990,728 available)

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

Preferences
Session mode: Multi
OCI Library: C:\oracle\bin\oci.dll
Use OCI7: False

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

Plug-Ins

Aliases
DMDEVCLS
DMDEVOWB
DMDEVPAC
DMDEVTST
DOCU
...

Homes
OUIHome1 (C:\oracle)

DLLs
C:\oracle\bin\oci.dll

TNS File
C:\oracle\Network\Admin\tnsnames.ora

Using
Home: OUIHome1
DLL: C:\oracle\bin\oci.dll
OCI: version 9.2

--- Registry ---

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

SOFTWARE\ORACLE\KEY_OUIHome1
ORACLE_HOME = C:\oracle
ORACLE_HOME_NAME = OUIHome1
ORACLE_GROUP_NAME = Oracle - OUIHome1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = ENGLISH_UNITED KINGDOM.WE8MSWIN1252
SQLPATH = C:\oracle\dbs
MSHELP_TOOLS = C:\oracle\MSHELP
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OUIHome1

--- Path ---

C:\oracle\bin
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\Program Files\IBM\Director\bin
C:\Program Files\Common Files\IBM\ICC\cimom\bin
C:\Program Files\Citrix\System32\Citrix\IMA
C:\Program Files\Citrix\System32\Citrix\IMA\Subsystems
C:\WINDOWS\System32\Citrix\IMA
C:\Program Files\Citrix\system32


When i try to access the PL/SQL developer on CITRIX server it works fines

Could you please let me know what the problem could be?

Regards
Naveen

Can you run C:\oracle\bin\sqlplus.exe with the same Citrix user and connect to the database?

Hi Marco,

Yes, through sqlplus I can connect to the database with the same citrix user

Regards
Naveen

Hi Iam having the same problem on a server with plsql installed. It works fine as long as you are a administrator bu as a user you recieve the blank error message.
Was there any solution to this problem ?

Regards Craig Gibb

This is usually a PATH related issue, or a privilege issue with the Oracle Client. Can you run <OracleHome>\bin\sqlplus.exe with the same Citrix user and connect to the database?

I found the problem the solution is below:

Thanks anyway /Craig

Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2.0 to 10.2.0.1.0 Oracle Server - Standard Edition - Version: 10.1.0.2.0 to 10.2.0.1.0 Microsoft Windows 2000 Microsoft Windows XP Microsoft Windows Server 2003 Symptoms

When logged on to the Windows server as a non-Administrator OS account using Microsoft Terminal Services client (mstsc.exe), starting SQL*Plus fails with

SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

Starting SQL*Plus works when logged on to the Windows server using an Administrator OS account.

Starting SQL*Plus works when logged on locally to the Windows server console using the non-Administrator OS account.
Cause

The issue is related to a Windows Security configuration. The problem is caused by a security policy called "Create Global Objects". The user account that is used to run the program does not have the "Create global objects" user right. This security policy was introduced with Windows 2000 SP4, and determines if applications started during a Terminal Services session can create or access globally accessible memory. By default, members of the Administrators group, the System account, and Services that are started by the Service Control Manager are assigned the "Create global objects" user right.
Solution
Assign the "Create global objects" user right to the non-Administrator account.

1. Click Start, point to Programs, point to Administrative Tools, and then click Local Security Policy.
2. Expand Local Policies, and then click User Rights Assignment.
3. In the right pane, double-click Create global objects.
4. In the Local Security Policy Setting dialog box, click Add.
5. In the Select Users or Group dialog box, click the user account that you want to add, click Add, and then click OK.
6. Click OK.
------------------------------------

Okay, thanks for the info!