SUMMARY: [Q] can NOT create new database?

From: L (leed@chele.cais.net)
Date: Wed Jan 13 1999 - 12:38:06 CST


Thank you for the answer. I list the answer I got:

I. Increase swap space --- It does not work.

II. Increase share memory(shmmax) -- it does not work

III Increase seminfo_semmsl -- it does not work

IV. Increase set semsys:seminfo_semmns=200
              set semsys:seminfo_semmni=70
    to 100%, it fixed the problem.

My original post:B
> We have ORACLE 7.3.4.1 on SUN SPARC 1000E computer (SOlaris 2.6).
> This computer have 128MB RAM (I knew it is too small) and four
> ORACLE instanances running on it. I tried to create fifth database
> (instance), Solaris does NOT allow me to do it. is there has way I
> can change the /etc/system setup to make it work? I list some
>information for you to reference. Thanks.

> ======== /etc/system ===========================
> *ident "@(#)system 1.15 92/11/14 SMI" /* SVR4 1.5 */
> *
> * SYSTEM SPECIFICATION FILE
> *
>
>
> * Begin ORACLE database info
> set shmsys:shminfo_shmmax=67108864
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=20
> set semsys:seminfo_semmns=200
> set semsys:seminfo_semmni=70
> set semsys:seminfo_semmsl=50
> * End ORACLE database info



This archive was generated by hypermail 2.1.2 : Fri Sep 28 2001 - 23:13:13 CDT