Find the answer to your Linux question:
Results 1 to 7 of 7
Hello all, I am running oracle 817 on RH Linux 7.2 and running iPlanet webserver for applications. I keep getting the following errors around once a week or even at ...
  1. 12-18-2003 #1
    k007
    k007 is offline
    Just Joined!
    Join Date
    May 2003
    Location
    Los Angeles
    Posts
    34

    Oracle error on Linux

    Hello all,

    I am running oracle 817 on RH Linux 7.2 and running iPlanet webserver for applications. I keep getting the following errors around once a week or even at a greater frequency

    ORA-04031: unable to allocate 2560 bytes of shared memory ("large poo
    l","unknown object","session heap","First curdef allocation")

    I have tried increasing the large pool size in the init.ora file, increased the max cursors as well but still the error persists. I also get thsi errors on RH 6.2 . I have tried increasing the shmmax parameter as well but to no success

    Is there a way to determine how much size should be put for large pool and other parameters ? or is this related to any system patches for linux ? because on solaris everything works fine.. I tried to search on google but most of the results show increase in pool size which I have already tried ...

    Any help is highly appreciated.

    Thanks
    K
    Reply With Quote Reply With Quote
  2. 12-19-2003 #2
    Dolda2000
    Dolda2000 is offline
    Linux Guru
    Join Date
    Oct 2001
    Location
    Täby, Sweden
    Posts
    7,578
    Are you sure that you have enough physical memory installed?
    Reply With Quote Reply With Quote
  3. 12-19-2003 #3
    k007
    k007 is offline
    Just Joined!
    Join Date
    May 2003
    Location
    Los Angeles
    Posts
    34
    Hello Dolda,

    Yes I have 512 MB of memory installed on the machine and its running just one instance of oracle.

    Thanks
    K
    Reply With Quote Reply With Quote
  4. 12-19-2003 #4
    Dolda2000
    Dolda2000 is offline
    Linux Guru
    Join Date
    Oct 2001
    Location
    Täby, Sweden
    Posts
    7,578
    Can you check the shm settings in "/proc/sys/kernel/shm*"?
    Reply With Quote Reply With Quote
  5. 12-22-2003 #5
    k007
    k007 is offline
    Just Joined!
    Join Date
    May 2003
    Location
    Los Angeles
    Posts
    34
    Hi Dolda,

    I have tried increasing the shm* settings in /proc/sys/kernel
    but that had not helped. I am using oracle 8.1.7.0.0 . Is this some kind of a bug with that version of oracle since some search results on google had a single line mentioned that this is a bug ..am not exactly sure if its true or not ...If it is a bug thne is there any patch or something for that ....

    Thanks
    K
    Reply With Quote Reply With Quote
  6. 12-22-2003 #6
    Dolda2000
    Dolda2000 is offline
    Linux Guru
    Join Date
    Oct 2001
    Location
    Täby, Sweden
    Posts
    7,578
    I'm sorry, but I'm not really good with Oracle. I just knew some of the generic stuff.
    Reply With Quote Reply With Quote
  7. 12-23-2003 #7
    andutt
    andutt is offline
    Linux Engineer
    Join Date
    Apr 2003
    Location
    Sweden
    Posts
    796
    The Oracle version before 9.2.0 must have a system variable set to be able to work properly. Have you set LD_ASSUME_KERNEL= to a very old kernel version.

    I dont remeber exatcly what it should be set to. But if you dont have set it and dont know i can look it up for you.

    Try also to tweak on the largepool and shared memory parameters in oracle to allocate less memory shunks.
    Regards

    Andutt
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

...