Home » Infrastructure » Windows » ROW-00001: Cannot allocate memory
ROW-00001: Cannot allocate memory [message #161744] Mon, 06 March 2006 23:34 Go to next message
stayi
Messages: 8
Registered: August 2005
Junior Member
We are using Oarcle 10G release and IIS-6 in our web application.

After moving to oracle 10G we started getting this error
ROW-00001: Cannot allocate memory
now and then. If we restart, the problem gets resolved.

Applications stability is broken because of this.

Can anyone please comment if this is a known issue.

Thanks,
Sunil.
Re: ROW-00001: Cannot allocate memory [message #224783 is a reply to message #161744] Thu, 15 March 2007 08:02 Go to previous messageGo to next message
jsanchez64
Messages: 1
Registered: March 2007
Junior Member
Hello there. Did you ever find out how to resolve this problem. We have seen this in out 10Gr2, with the 10.2 lient.

Thanks
Re: ROW-00001: Cannot allocate memory [message #224822 is a reply to message #224783] Thu, 15 March 2007 10:50 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Check Metalink ?
Re: ROW-00001: Cannot allocate memory [message #391966 is a reply to message #161744] Sun, 15 March 2009 07:12 Go to previous messageGo to next message
jamesadoor
Messages: 1
Registered: March 2009
Junior Member
Please give a solution if somebody have...

TIA,

James
Re: ROW-00001: Cannot allocate memory [message #391973 is a reply to message #161744] Sun, 15 March 2009 09:47 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>ROW-00001: Cannot allocate memory
If error report is 100% correct & accurate, then this is not from Oracle & you should post on IIS forum.
Re: ROW-00001: Cannot allocate memory [message #523706 is a reply to message #391973] Tue, 20 September 2011 01:32 Go to previous messageGo to next message
bhavangowda
Messages: 23
Registered: May 2011
Location: bangalore
Junior Member
Hi all,

I too getting the same error.Any Body has the solution for this error
Re: ROW-00001: Cannot allocate memory [message #523713 is a reply to message #523706] Tue, 20 September 2011 01:54 Go to previous messageGo to next message
stayi
Messages: 8
Registered: August 2005
Junior Member
Moving to Oracle 10gr2 client resolved the issue for us
Re: ROW-00001: Cannot allocate memory [message #523714 is a reply to message #523713] Tue, 20 September 2011 02:01 Go to previous messageGo to next message
bhavangowda
Messages: 23
Registered: May 2011
Location: bangalore
Junior Member
Hi stayi,

We are using below oracle version ....for upgrading the oracle version do i need to upgrade the database.?? please let me know your oracle version also

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
Re: ROW-00001: Cannot allocate memory [message #523731 is a reply to message #523714] Tue, 20 September 2011 03:32 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This (10.2.0.1.0) is the database version, not a client version.

You'll see the client version when you run SQL*Plus (presuming - if there is more than a single Oracle product installed on your computer - that you actually ran a correct SQL*Plus executable):

M:\>sqlplus x/y@ora8

SQL*Plus: Release 10.2.0.1.0 - Production on Uto Ruj 20 10:30:28 2011 (client)

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production (database)
With the Partitioning option
JServer Release 8.1.7.0.0 - Production


Or, even better, run the Oracle Universal Installer - it will display all products you have installed.

P.S. So: what Stayi said was to upgrade client software, not your database.

[Updated on: Tue, 20 September 2011 03:33]

Report message to a moderator

Re: ROW-00001: Cannot allocate memory [message #523732 is a reply to message #523731] Tue, 20 September 2011 03:37 Go to previous messageGo to next message
stayi
Messages: 8
Registered: August 2005
Junior Member
Also we changed to oraoledb provider from MSDAORA
Re: ROW-00001: Cannot allocate memory [message #523736 is a reply to message #523732] Tue, 20 September 2011 03:45 Go to previous messageGo to next message
bhavangowda
Messages: 23
Registered: May 2011
Location: bangalore
Junior Member
HI,

C:\Documents and Settings\Administrator>sqlplus apsrimes/test123

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 20 14:13:21 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

I am executing some RSM application Queries ..!!

Stayi,

How to change the oraoledb provider from MSDAORA
Re: ROW-00001: Cannot allocate memory [message #525629 is a reply to message #523736] Tue, 04 October 2011 03:43 Go to previous message
Flyby
Messages: 169
Registered: March 2011
Location: Belgium
Senior Member
In the connectionstring of the application? Should be tested first as the oraoledb-driver handles things differently. Any reason the database is at level 10.2.0.1.0 instead of 10.2.0.4 or higher?
Clients 10.2.0.4 Oracle 10g Release2 page includes client
Previous Topic: calling stored procedure with input and output parameters from batch file
Next Topic: Installing 9i forms 6i on Vista
Goto Forum:
  


Current Time: Thu Dec 08 22:06:42 CST 2016

Total time taken to generate the page: 0.22838 seconds