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

Thread: dedicated server issues !

  1. #1
    Join Date
    Oct 2002

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


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

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

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

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Feb 2000
    Washington DC
    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.

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