Home » RDBMS Server » Server Administration » problem in db startup (oracle 9.2.0.8, solaris 10)
problem in db startup [message #605770] Tue, 14 January 2014 08:03 Go to next message
savugar
Messages: 33
Registered: February 2012
Member
Hi ,

I am getting the below error when I am fire startup command.

ORA-27102: out of memory
SVR4 Error: 22: Invalid argument


Below error I am getting in alert log file at the same time.

WARNING: EINVAL creating segment of size 0x000000055a400000
fix shm parameters in /etc/system or equivalent


I have gone through the below url. it is been mentioned that, the cause of the issue was the low memory segment allocated for max-shm-memory. But in my case, this size is 85 Gb. but as per alert log message, it is trying to allocate only 22gb memory segment. I am not sure what is the problem here. pls help

http://technopark02.blogspot.co.uk/2006/09/solaris-10oracle-fixing-ora-27102-out.html


net01:/etc [TQN5]> uname -a
SunOS net01 5.10 Generic_147440-09 sun4u sparc SUNW,SPARC-Enterprise


net01:/etc [TQN5]> more /etc/project
system:0::oracle::project.max-shm-memory=(privileged,91268055040,deny);project.max-sem-ids=(priv,100,deny);project.max-sem-nsems=(priv,2048,deny);project.max
-shm-ids=(priv,4096,deny)
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
group.dba:100::oracle::project.max-shm-memory=(privileged,91268055040,deny);project.max-sem-ids=(priv,100,deny);project.max-sem-nsems=(priv,2048,deny);projec
t.max-shm-ids=(priv,4096,deny)
user.oracle:101::oracle::project.max-shm-memory=(priv,91268055040,deny)


net01:/etc [TQN5]> id -p
uid=361(oracle) gid=200(dba) projid=0(system)


net01:/etc [TQN5]> prctl -n project.max-shm-memory -i project 0
project: 0: system
NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT
project.max-shm-memory
        privileged      62.8GB      -   deny                                 -
        system          16.0EB    max   deny 



init parameters:
================
db_block_size        = 8192
db_cache_size = 10737418240     
sga_max_size = 23622320128
pga_aggregate_target = 4294967296
shared_pool_size =  5737418240
large_pool_size =  5268045824    
java_pool_size = 314572800      
log_buffer = 2097152    
Re: problem in db startup [message #605776 is a reply to message #605770] Tue, 14 January 2014 08:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
OS is not configured to provide what Oracle is requesting.
Re: problem in db startup [message #605777 is a reply to message #605776] Tue, 14 January 2014 08:39 Go to previous messageGo to next message
savugar
Messages: 33
Registered: February 2012
Member
how you are saying that OS doesn't configured with enough space? what needs to be done to sort out this?
Re: problem in db startup [message #605778 is a reply to message #605777] Tue, 14 January 2014 08:42 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://docs.oracle.com/cd/E16655_01/install.121/e17752/app_manual.htm#SSDBI7871
Previous Topic: Database connectivity check
Next Topic: How to unload an oracle package from memory?
Goto Forum:
  


Current Time: Thu Nov 28 21:43:00 CST 2024