dedicated server issues !
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dedicated server issues !

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    dedicated server issues !

    Hello all..

    Sun 5.8/ Oracle 9.2

    I created a 9.2 database with dedicated server option. I set my processes value to 600 in init.ora file.. This is the only database on this server.

    My KErnal Parameters are :

    set shmsys:shminfo_shmmax=4294967295
    set shmsys:shminfo_shmmin=1
    set shmsys:shminfo_shmmni=100
    set shmsys:shminfo_shmseg=10

    set semsys:seminfo_semmns=3300
    set semsys:seminfo_semmni=1700
    set semsys:seminfo_semmsl=1700



    My developers are still getting error after crossing 150 limit. earlier the 'process' value was default to 150....now when issue show parameter process, it shows 650 since iam using SPFILE.

    so what else can i do or make changes to make this work ?...


    Dou you think Shared server would have been a better option ?..

    Thanks
    Ron

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    im not sure but you need to set

    shminfo_shmmni equal to or more than the processes in the init parameter file

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    See are there any locked semaphores using 'ipcs -sb' command (after shutting down the database). Remove them using 'ipcrm' command which will allow to bring required number of semaphores upon startup of instance.

    Those commands are solaris specific, not sure other unix flavors equivalent commands.
    Reddy,Sam

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