Home » Infrastructure » Unix » Not enough memory available (10G)
Not enough memory available [message #597917] Wed, 09 October 2013 05:11 Go to next message
sinpeak
Messages: 59
Registered: January 2011
Location: india
Member
Hello,

We are invoking the following code from a shell script :

  LOADFILE=`sqlplus -S $DATABASE <<-_END
    SET SERVEROUTPUT ON SIZE UNLIMITED;
    WHENEVER SQLERROR EXIT SQL.SQLCODE;
    SET LINESIZE 100;
    SET HEADING OFF;
    SET FEEDBACK OFF;
    SET PAGESIZE 0;
    SET TRIMSPOOL ON;
    SET NEWPAGE NONE;
    SET TERMOUT OFF;
    SET  ECHO OFF;
    SPO  $VFileName;
    
    SELECT 'test: TRUE' FROM DUAL;
    
    SELECT 'a: '||CREF_VALUE FROM CREFDATA;  
    SPO OFF;

    EXIT

    _END`


When the data in CREFDATA table is huge ( lets say 150K + rows ) , then the shell script returns the following error :

/bin/CR.ksh[423]: 0403-029 There is not enough memory available now.
[genpprod]:/geneva_prog/PR1 $Error 45 initializing SQL*Plus
Internal error


When we try the same test in another other environment setup/server, the shell scripts runs fine.

Please advise as in..what should be done from DBA/Sys Admin point of view on the original environment ( where we are getting the error ) to avoid such an error.

Thanks.




icon2.gif  Re: Not enough memory available [message #597918 is a reply to message #597917] Wed, 09 October 2013 05:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
When we try the same test in another other environment setup/server, the shell scripts runs fine.


So the problem is not in Oracle (moreover you have no Oracle error and sqlplus even not start) you should ask your sysadmin.

Re: Not enough memory available [message #597928 is a reply to message #597917] Wed, 09 October 2013 05:39 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
sinpeak wrote on Wed, 09 October 2013 15:41

/bin/CR.ksh[423]: 0403-029 There is not enough memory available now.
[genpprod]:/geneva_prog/PR1 $Error 45 initializing SQL*Plus
Internal error



This is an issue purely related to your UNIX box. Get in touch with the server admin.

Quote:

When we try the same test in another other environment setup/server, the shell scripts runs fine.


Other environment has more free memory than the current environment.

A similar thread about the same error on AIX server http://www.unix.com/aix/138042-aix-ksh-0403-029-there-not-enough-memory-available-now.html

[Updated on: Wed, 09 October 2013 05:40]

Report message to a moderator

Previous Topic: Tar the binary files
Next Topic: solaris booting
Goto Forum:
  


Current Time: Thu Mar 28 08:15:50 CDT 2024