Clients app lost connection to Oracle

[oleg_d]

Hi!
I have a problem with PeopleSoft client app:
1. users run PeopleSoft on Citrix servers
2. application fails with following errors in log file
<font class="small">Code:</font><hr /><pre> 14024/7684 FOREIGN_THREAD Tue Oct 07 11:06:40.862000 dbperfrq.c449
OCI0000178 - Unable to execute - SELECT * FROM PRODDTA.F40203 WHERE ( FSDCTO = :KEY1 AND FSTRTY = :KEY2 ) ORDER BY FSDCTO ASC,FSLNTY ASC,FSTRTY ASC
14024/7684 FOREIGN_THREAD Tue Oct 07 11:06:40.862001 dbperfrq.c455
OCI0000179 - Error - ORA-24909: Call in progress. Current operation cancelled
14024/7684 FOREIGN_THREAD Tue Oct 07 11:06:40.862002 Jdb_drvm.c969
JDB9900401 - Failed to execute db request
14024/7684 FOREIGN_THREAD Tue Oct 07 11:06:40.877000 dbperfrq.c449
OCI0000178 - Unable to execute - SELECT * FROM PRODDTA.F46010 WHERE ( IPMCU = :KEY1 AND IPITM = :KEY2 )
14024/7684 FOREIGN_THREAD Tue Oct 07 11:06:40.877001 dbperfrq.c455
OCI0000179 - Error - ORA-24909: Call in progress. Current operation cancelled
14024/7684 FOREIGN_THREAD Tue Oct 07 11:06:40.877002 Jdb_drvm.c969
JDB9900401 - Failed to execute db request
14024/7684 FOREIGN_THREAD Tue Oct 07 11:06:40.877003 dbperfrq.c449
OCI0000178 - Unable to execute - SELECT * FROM PRODDTA.F4101 WHERE ( IMITM = :KEY1 )
14024/7684 FOREIGN_THREAD Tue Oct 07 11:06:40.877004 dbperfrq.c455
OCI0000179 - Error - ORA-03114: not connected to ORACLE
</pre><hr />
3. Environment - E1 8.10, Oracle DB 10.1.0.5 (dedicated), Oracle client 10.1.0.4. There are opened about 400-500 sessions in Oracle DB.
I could not find any logical dependencies why client lost connection. For example, one user open PeopleSoft client app and open 2 new windows in it. After time user just opened it and application crashed.
Maybe Oracle or PeopleSoft Enterprise server can't process this quantity of users? May be Oracle should be in shared mode?
Oracle alert.log doesn't contain any errors.
How to find where is the problem?
Thanks

 

[Alex_Pastuhov]

Oleg,

You should bring your client version up to the exac same as the server's and try again. This error is likely a bug in Oracle.

If this was an issue with the upper limit on sessions, the error would have been diferent. No need to go shared. In fact going shared mode would likely slow the performance down.

Check server logs - there maybe additional details there.

 

[oleg_d]

I've just installed oracle client up to 10.1.0.5 and restarting all servers. I think, today i will get result and can check - Oracle client version was the problem or not.
Thanks a lot.
And what about Oracle Shared server configuration - where I can read recommendations for setting up Shared mode?
Thanks again

 

[oleg_d]

The problem still exists. After installing higher oracle client and rebooting servers a got 1 such error yesterday and 3 today and one of it - I. I've worked with PeopleSoft application and leave it on several minutes, when I back and try no find some on form - connection was lost with same error.

 

[Alex_Pastuhov]

Are you certain that this is the exact Oracle Home used by JDE? - if you have multiple Oracle installations on the Client, the client may potentially use a wrong one.

Keep calling Oracle. If it's a bug, as I think it is, they would be your only hope, or you can try different service packs of Oracle and JDE, hoping that some combination of versions may work differently...