Oracle client on Citrix terminal server
Hi,
I'm trying to set up an Oracle client on a Citrix-based terminal server environment.
My environment:
- Citrix Metaframe XPe FP3 SP4 on Windows 2000 advanced server SP4
- Oracle client 10g 10.2.0.1.0
What I'm trying to do is connecting to a remote database using the Oracle client. So I installed the Oracle client and defined the tnsnames.ora file.
Now it's the time to execute sqlplus: everything works like a charm when I connect to the terminal server as administrator.
But when I connect using a normal user the connection doesn't succeed: the sqlplus (after having given username, password and host string) closes its window immediately, without giving to me the possibility to read the Oracle error number (which I see do appears but too shortly).
Other applications (like Toad) again work when I connect to the terminal server as administrator, but show a more generic error ("Can't initialize OCI; Error -1).
So, something is missing and I'm trying to figure out what.
Any tip to solve my problem? Thank you in advance for every possible suggestion!
Diego.
I'm trying to set up an Oracle client on a Citrix-based terminal server environment.
My environment:
- Citrix Metaframe XPe FP3 SP4 on Windows 2000 advanced server SP4
- Oracle client 10g 10.2.0.1.0
What I'm trying to do is connecting to a remote database using the Oracle client. So I installed the Oracle client and defined the tnsnames.ora file.
Now it's the time to execute sqlplus: everything works like a charm when I connect to the terminal server as administrator.
But when I connect using a normal user the connection doesn't succeed: the sqlplus (after having given username, password and host string) closes its window immediately, without giving to me the possibility to read the Oracle error number (which I see do appears but too shortly).
Other applications (like Toad) again work when I connect to the terminal server as administrator, but show a more generic error ("Can't initialize OCI; Error -1).
So, something is missing and I'm trying to figure out what.
Any tip to solve my problem? Thank you in advance for every possible suggestion!
Diego.
Not familiar with your environment at all. Just wanted to add that if you can get to a command prompt of some type, try sqlplus from there. You should be able to see the error message.
ASKER
Hi Slightwv,
thank you for your suggestion.
The error messages are:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
Any idea about the reason why this happens?
Diego.
thank you for your suggestion.
The error messages are:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
Any idea about the reason why this happens?
Diego.
Diego,
You might want to cross-post this in a Citrix Topic Area (if EE has one). I suspect it has to do with the virtual machine that Citrix is creating - something Oracle is doing in order to make it work isn't compatible with a non-admins security. Did you check the security log of the PC?
Good luck!
DrSQL
You might want to cross-post this in a Citrix Topic Area (if EE has one). I suspect it has to do with the virtual machine that Citrix is creating - something Oracle is doing in order to make it work isn't compatible with a non-admins security. Did you check the security log of the PC?
Good luck!
DrSQL
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
One of my clients has two Citrix servers with the Oracle 9i2 Client installed. If you can wait, I am going there tomorrow and I can check how it is setup.
Other than that the only thing that I can think of is that might help is that all the database apps on the Cytrix servers use an ODBC connection to communicate with the database. I know that in windows this type of connection can be shared with all users on the machine. I am not sure when you install an application if there is something that needs to be done to make it available to all users.
Other than that the only thing that I can think of is that might help is that all the database apps on the Cytrix servers use an ODBC connection to communicate with the database. I know that in windows this type of connection can be shared with all users on the machine. I am not sure when you install an application if there is something that needs to be done to make it available to all users.
Each application that you use needs to be published in the cytrix mainframe. You may need to publish the TNSNAMES.ora along with the Oracle SQLPLUS tool.
ASKER
Hi,
unfortunately I couldn't come to a solution to make this Oracle client running. But we managed anyway to reach out goal: I switched to the instant client and everything is working like a charm ...
I'm trying anyway to solve the original issue, but now it has a low priority.
Thank you to everyone for your valuable help! I'm splitting the points to your answers.
Diego.
unfortunately I couldn't come to a solution to make this Oracle client running. But we managed anyway to reach out goal: I switched to the instant client and everything is working like a charm ...
I'm trying anyway to solve the original issue, but now it has a low priority.
Thank you to everyone for your valuable help! I'm splitting the points to your answers.
Diego.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.