ORA-24371

CNCTech

Active Member
We are experiencing problems when submitting a report on the enterprise server. Here is the log. If anyone seen this before, please let me know:

14923 Mon Nov 15 13:31:27 2004 dbperfrq.c386
OCI0000178 - Unable to execute - SELECT * FROM PRODDTA.F1114 WHERE ( ( C2DOT2 = :KEY1 AND C2CO = :KEY2 AND C2TLT = :KEY3 ) ) AND ( C2CO NOT BETWEEN :KEY4 AND :KEY5 ) ORDER BY C2DOT2 ASC,C2CO ASC,C2CRDC ASC,C2FLT1 ASC,C2TLT ASC,C2MCUF ASC,C2OBJF ASC,C2FSUB ASC

14923 Mon Nov 15 13:31:27 2004 dbperfrq.c393
OCI0000179 - Error - ORA-24371: data would not fit in current prefetch buffer

ERP8 SP 22 Oracle 9i Enterprise Server: Solaris 7
 
For Our DBA:

I spoke with a couple of Oracle guys and they suggested that we try the
Oracle 9.2 client. They said that it was more important to have newer
client software than database software. They also said that this issue is
probably some type of client issue and that it would not be addressed by a
database parameter.



What we did to fix it:

Installed Oracle Client 9.2 and MDAC 2.17 to all Systems.



From PeopleSoft:

Search KG using OCI0000179 and ORA-24371, I found these: - DBA increased
the 'ARRAYSIZE' and the 'MAXDATA' parameters fix the problem SAR # 6965014 -
Fix in SP22_O1, SP22.1 or Oracle 9.0.1.4, Oracle 9.2.0.4



What version of Oracle are you running on the DB server AND on the citrix
box. They should match MTRs and also should be the same versions down to the
patch level, example 8.1.7.4. What is the platform of your enterprise? What
is the SP level of OneWorld ? Xe SP22_F1 ?



I am not a platform guy so I am not sure about the maxdata either but I
found in google "The function of the SET command parameter, MAXDATA, is
described in the section "SET" in Chapter 6 in the SQL*Plus User's Guide and
Reference. SQL*Plus for Windows NT and Windows 95 can process a row width of
up to 60K. The default value for the MAXDATA parameter is 60K."



This is a database setting. We do not support the actual configuration of
the database here through Global Support Services. I did however consult
briefly with our DBA and he has not heard of any way to disable prefetching
and that this is a classic issue of missed MTRs Client/server, ect. should
all be running the same release of oracle including patch level.



Please contact oracle support for further clarify the issue regarding
disabling/enabling of Prefetch.



PeopleSoft EnterpriseOne Tools & Technology

PeopleSoft Global Support Center



From Oracle:

This note gives a brief overview of bug 2699203.



Affects:

Product (Component)

Oracle Server (OCI)



Range of versions believed to be affected

Versions >= 9.2 but < 10G



Versions confirmed as being affected

9.2.0.3



Platforms affected

Generic (all / most platforms affected)





Fixed:

This issue is fixed in

9.2.0.4 (Server Patch Set)

10G Production Base Release





Symptoms:

Error may occur

ORA-24371

Related To:

Transparent Application Failover

OCI

Description





ORA-24371 can occur on Execute/Fetch after FAILOVER.



Workaround:

Disable prefetching (Prefetching is enabled by default)
 
Re: RE: ORA-24371

Thank you but I do need an interm solution to get the user going.

Cheers
 
Back
Top