ORA-27101: shared memory realm does not exist

From: Carsten Grammes <cgrammes_at_gmx.net>
Date: Wed, 20 Feb 2002 16:28:06 GMT
Message-ID: <3c73ca05.1669187634@192.109.199.19>

Hello world,

I try to run Oracle 9.0.1.1 on a SUN Ultra 10 (512MB RAM). shared pool size is set to 8000000. That results in an SGA:

Total System Global Area 46727408 bytes

When running catproc.sql I see some error messages like:

grant select on ku$_fhtable_view to public                           
                *                                                    
ERROR at line 1:                                                     
ORA-00604: error occurred at recursive SQL level 2                   

ORA-04031: unable to allocate 1360 bytes of shared memory ("shared pool","select ts#,file#,block#,nvl(...","sql area","kafco : qkacol")                                                                      

When I connect to the database using sqlplus, the first user succeeds, the second one gets a message:

Enter user-name: system                         
Enter password:                                 
ERROR:                                          
ORA-01034: ORACLE not available                 
ORA-27101: shared memory realm does not exist   
SVR4 Error: 2: No such file or directory        

Question: there seems to a problem with shared memory. I set the system shared memory settings to double the Oracle recommendations

/etc/system:

set semsys:seminfo_semmni=200        
set semsys:seminfo_semmns=512        
set semsys:seminfo_semmsl=512        
set shmsys:shminfo_shmseg=20         
set shmsys:shminfo_shmmni=200        
set shmsys:shminfo_shmmax=4294967295 
                            

Does this mean, my SGA is too small or my system settings are too small? Or anything else?

Thanks for any help!
Carsten.

---
I want to die peacefully in sleep like my grandfather.
Not screaming in terror like his passengers!

Received on Wed Feb 20 2002 - 10:28:06 CST