lock_sga
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: lock_sga

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Posts
    193
    i shutdown my databas.
    add lock_sga=true to init.ora
    startup

    it gives me error

    SQL> startup
    ORA-27126: unable to lock shared memory segment in core
    SVR4 Error: 1: Not owner


    why?
    guru is on the way!!!!

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check to make sure that your platform supports this, and you have the appropirate privileges, to lock the segment in the memory....

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2001
    Posts
    193
    my system is solaris 2.7

    how to check if i have the appropriate privileges to lock the
    segment in the memory?
    guru is on the way!!!!

  4. #4
    Join Date
    Mar 2001
    Posts
    314
    You need root privileges on Solaris to be able to use the lock_sga parameter.

    Anybody using this parameter out there ??

    -amar

  5. #5
    Join Date
    Oct 2000
    Posts
    449
    What does lock_sga do and why would you do that??
    Thanks ST

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    It would lock the sga to the memory at boot time and would hold that for ever. But be aware of that if you were to use the virtual memory, then you would endup going to the disk too to process your SGA.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    May 2001
    Location
    Cape Town, South Africa
    Posts
    52
    I know on HP-UX you use this solution
    You need to give the oracle Unix user memory locking privileges at the OS level.
    Do the following:

    1) Login as root:

    %su root

    2) Create the file "/etc/privgroup":

    $vi /etc/privgroup

    3) Add line "dba MLOCK" to file.

    Note: The group dba is assuming the oracle owner's ID is part of the dba
    group.

    4) As root, run the command "/etc/setprivgrp -f /etc/privgroup":

    $/etc/setprivgrp -f /etc/privgroup

    I am sure the procedure should be simler on solaris as they are both California Berkly systems

Posting Permissions

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



Click Here to Expand Forum to Full Width