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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    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

  2. #2
    Linux Guru
    Join Date
    Oct 2001
    Location
    Täby, Sweden
    Posts
    7,578
    Are you sure that you have enough physical memory installed?

  3. #3
    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

  4. #4
    Linux Guru
    Join Date
    Oct 2001
    Location
    Täby, Sweden
    Posts
    7,578
    Can you check the shm settings in "/proc/sys/kernel/shm*"?

  5. #5
    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

  6. #6
    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.

  7. #7
    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

Posting Permissions

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