Can't connect to an Oracle DB under Citrix mandatory profile

[glenfar]

Hi, I'm having a problem connecting to Oracle with Citrix. For the administrator or normal user, there's no problem. But when logged in using a mandatory profile, I just can't connect ... here's a bit of the history:

- Initially found the problem while trying to run our application
- Debugged it - code to connect to DB just fails to get a connection - no error comes back though
- Opened up Oracle Management Console (while logged in as mandatory profile user) and added the service to the list of DB's
- I was then able to open SQL Scratchpad and execute SQL in there no problem
- I was also able to open the app without a problem
- Log out ... log back in ... problem is back
- Open Oracle Management Console, and see that I again have no DB's
- Add the service back into the list (no problem there)
- Still can't run the application
- Try to open SQL Scratchpad and the whole Management Console just disappears
- Open the Oracle Net Manager, and test the connection for the service
- Test failed ... message that there may be an error in the fields or server is not ready for a connection
- Login as administrator, and again try the test in Oracle Net Manager
- Test successfully

So basically, while logged in under a mandatory profile, I just can't connect to Oracle ... except for that first time!

Any ideas?

Thanks,
Glen.

 

[stefanhei]

The behavior (no changes saved) are what I'd expect when using mandatory profiles.
There usually is a file called sqlnet.log, which logs failed connection attepts. If you find an entry there about the your attempt please post the errormessages to help us help you.

 

[glenfar]

Not saving I could understand ... but why doesn't the same 'fix' work the second time I log in? Even after a reboot, adding the DB in again doesn't help at all.

In any case, there's no sqlnet.log file (at least not for this issue - it just has an old entry in it). Which is consistent with how the app behaves - no errors, just nothing happens.

 

[glenfar]

So ... it's looking like no-one has any ideas?

Has anyone had Oracle working with Citrix Mandatory profiles? Or tried to get it working?

Also, aside from the Net Manager test, is there any other way of testing an Oracle connection? Maybe at a lower level (like whether it can even see the db server ...)? I'm not familiar with Oracle (usually use SQLServer) so any tips on determining where the connection is failing would be appreciated!