ORA-27102: out of memory in Tru64
Hi friends , I am getting the following error when trying to take the database to nomount state . I am trying to create a new database . $ svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SVRMGR connect internal Connected. SVRMGR startup pfile ='/app/oracle/admin/devbcm/pfile/initdevbcm.ora' nomount ORA-27102: out of memory Compaq Tru64 UNIX Error: 12: Not enough space Additional information: 1 Additional information: 98307 My Shm parameters are as given below . $ /sbin/sysconfig -q ipc ipc: msg-max = 8192 msg-mnb = 16384 msg-mni = 64 msg-tql = 40 shm-max = 1073741824 shm-min = 1024 shm-mni = 256 shm-seg = 128 sem-mni = 4096 sem-msl = 1000 sem-opm = 100 sem-ume = 1000 sem-vmx = 32767 sem-aem = 16384 num-of-sems = 1000 max-kernel-ports = 32351 port-hash-max-num = 1617550 port-reserved-max-num = 32351 set-max-num = 4338 ssm-threshold = 0 ssm-enable-core-dump = 1 Please help me to solve this error . Thanks Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shibu MB INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-27102: out of memory in Tru64
Hi Shibu (Still going to GOA at new year then ??) I would get your shm-max upped. Regards Lee -Original Message- Sent: 04 November 2003 13:39 To: Multiple recipients of list ORACLE-L Hi friends , I am getting the following error when trying to take the database to nomount state . I am trying to create a new database . $ svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SVRMGR connect internal Connected. SVRMGR startup pfile ='/app/oracle/admin/devbcm/pfile/initdevbcm.ora' nomount ORA-27102: out of memory Compaq Tru64 UNIX Error: 12: Not enough space Additional information: 1 Additional information: 98307 My Shm parameters are as given below . $ /sbin/sysconfig -q ipc ipc: msg-max = 8192 msg-mnb = 16384 msg-mni = 64 msg-tql = 40 shm-max = 1073741824 shm-min = 1024 shm-mni = 256 shm-seg = 128 sem-mni = 4096 sem-msl = 1000 sem-opm = 100 sem-ume = 1000 sem-vmx = 32767 sem-aem = 16384 num-of-sems = 1000 max-kernel-ports = 32351 port-hash-max-num = 1617550 port-reserved-max-num = 32351 set-max-num = 4338 ssm-threshold = 0 ssm-enable-core-dump = 1 Please help me to solve this error . Thanks Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shibu MB INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora-4030 out of memory error
All - I have a user receiving this error on several different Unix boxes with the same query. Oracle says to increase the size limit which was done in 2000. The sort are size parm is set to 10485760. Any suggestions?? LeRoy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-4030 out of memory error
LeRoy Check out Metalink Note 199746.1 Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 23, 2003 3:00 PM To: Multiple recipients of list ORACLE-L All - I have a user receiving this error on several different Unix boxes with the same query. Oracle says to increase the size limit which was done in 2000. The sort are size parm is set to 10485760. Any suggestions?? LeRoy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ora-4030 out of memory error
You mean the size parameter was changed in 2000, not to the value 2000? Try increasing the LARGE_POOL_SIZE to at least 2MB or more, preferably 8MB or more. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] edu To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: ora-4030 out of memory error ity.com 06/23/2003 02:59 PM Please respond to ORACLE-L All - I have a user receiving this error on several different Unix boxes with the same query. Oracle says to increase the size limit which was done in 2000. The sort are size parm is set to 10485760. Any suggestions?? LeRoy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ora-4030 out of memory error
LeRoy, You did not say which version of Oracle. Anyway in 8.1.6 there is a bug 1337858. If that is not the case check NOTE:19836.1 on metalink. Shaibal Talukder Discover Financial Services Oracle Engineering [EMAIL PROTECTED] Work Phone :(224) 405 1140 Cell Phone:(513) 850 3721 From: LeRoy Kemnitz [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ora-4030 out of memory error Date: Mon, 23 Jun 2003 11:59:53 -0800 All - I have a user receiving this error on several different Unix boxes with the same query. Oracle says to increase the size limit which was done in 2000. The sort are size parm is set to 10485760. Any suggestions?? LeRoy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shaibal Talukder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-4030 out of memory error
Title: RE: ora-4030 out of memory error LeRoy, Post the query to the list. Just maybe it could tuned or give us an idea of what's going on. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: LeRoy Kemnitz [SMTP:[EMAIL PROTECTED] All - I have a user receiving this error on several different Unix boxes with the same query. Oracle says to increase the size limit which was done in 2000. The sort are size parm is set to 10485760. Any suggestions?? LeRoy
Re: ora-4030 out of memory error
Yes, the parm was changed in 2000. pen_cursors = 300 max_enabled_roles = 30 db_block_buffers = 45000 buffer_pool_keep=(buffers:5200 lru_latches:2) shared_pool_size = 83886080 # shared_pool_reserved_size = 7M large_pool_size = 6291456 java_pool_size = 32K # java_pool_size = 53886080 These are the current values. I am new so there are no dumb suggestions. [EMAIL PROTECTED] wrote: You mean the size parameter was changed in 2000, not to the value 2000? Try increasing the LARGE_POOL_SIZE to at least 2MB or more, preferably 8MB or more. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] edu To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: ora-4030 out of memory error ity.com 06/23/2003 02:59 PM Please respond to ORACLE-L All - I have a user receiving this error on several different Unix boxes with the same query. Oracle says to increase the size limit which was done in 2000. The sort are size parm is set to 10485760. Any suggestions?? LeRoy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ora-4030 out of memory error
I am running 8.1.7.3 oracle on AIX 4.3.3. Will take a look. Thanks, L. Shaibal Talukder wrote: LeRoy, You did not say which version of Oracle. Anyway in 8.1.6 there is a bug 1337858. If that is not the case check NOTE:19836.1 on metalink. Shaibal Talukder Discover Financial Services Oracle Engineering [EMAIL PROTECTED] Work Phone :(224) 405 1140 Cell Phone:(513) 850 3721 From: LeRoy Kemnitz [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ora-4030 out of memory error Date: Mon, 23 Jun 2003 11:59:53 -0800 All - I have a user receiving this error on several different Unix boxes with the same query. Oracle says to increase the size limit which was done in 2000. The sort are size parm is set to 10485760. Any suggestions?? LeRoy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shaibal Talukder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: LeRoy Kemnitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ora-4030 out of memory error
Title: RE: ora-4030 out of memory error PGA grows by using the malloc() or sbrk() system calls to extend the heap data segment for process. The new operating system vertual memory is then added to the PGA heap as a new extent. These extents are only a few kilobytes in size , and Oracle may allocate thousands of them if necessary. There are, however, operating system limits on the growth of the heap data segment of a process. In most cases the default limit is set by an OS kernel parameter(MAXDSIZ). In some cases the default can be changewd on a per-process basis. There is also system-wide limit on the total virtual memory size of all processes. That limit is related to the amount of swap space available. If either of these limit is exceeded, then the Orcale process concerned will return an ORA-4030 error. This error is only rarely dua to the per-process resource limit, and normally indicates a shortage of swap spce. To diagnose the problem use the OS facility to report swap space usage. On some OS Oracle includes a small utility called maxmem which can be used to check the maximum heap data segment size that a process can allocate, and which which limit is being hit first. If the problem is shortage of swap space, and if paging activity is moderate or heavy, then attempt to reduce the system-wide virtual memory usage. either by reducing the process count or by reducing the per-process memory usage. Otherwise, if paging activity is light or nill, you should increase the swap space or if OS supports it, enable the the use of virtual or pseudo swap space. - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Tuesday, June 24, 2003 2:30 AM Subject: RE: ora-4030 out of memory error LeRoy, Post the query to the list. Just maybe it could tuned or give us an idea of what's going on. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: LeRoy Kemnitz [SMTP:[EMAIL PROTECTED] All - I have a user receiving this error on several different Unix boxes with the same query. Oracle says to increase the size limit which was done in 2000. The sort are size parm is set to 10485760. Any suggestions?? LeRoy
Out of Memory
I am getting: SQL startup nomount ORA-27102: out of memory Machine Specs: 0) Oracle 8i 8.1.7 1) Sun Solaris 8 fully patched 2) SparcStation5 70Mhz 3) 128MB Ram 4) 256B Swap 5) /etc/system set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=100 set semsys:seminfo_semmns=200 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767 6) initSID.ora JAVA_POOL_SIZE=0 LARGE_POOL_SIZE=0 SHARED_POOL_SIZE=2097152 SORT_AREA_SIZE=262144 db_block_buffers=1048576 log_buffer=1048576 Can someone give me some tips as to where I need to look next. My system is not running DT/CDE/OW GUI so there is plenty of memory available for Oracle, about 81MB Ram and the whole Swap at system startup before I start Oracle. How come Oracle still insists I am out of memory? ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Out of Memory
Your db_block_buffers=1048576 times your db_block_size. If your db_block_size is 8k, you need 8gb of RAM. If db_block_size is 4k, you need 4gb of RAM. Richard -Original Message- Sent: Saturday, August 17, 2002 11:13 PM To: Multiple recipients of list ORACLE-L I am getting: SQL startup nomount ORA-27102: out of memory Machine Specs: 0) Oracle 8i 8.1.7 1) Sun Solaris 8 fully patched 2) SparcStation5 70Mhz 3) 128MB Ram 4) 256B Swap 5) /etc/system set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=100 set semsys:seminfo_semmns=200 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767 6) initSID.ora JAVA_POOL_SIZE=0 LARGE_POOL_SIZE=0 SHARED_POOL_SIZE=2097152 SORT_AREA_SIZE=262144 db_block_buffers=1048576 log_buffer=1048576 Can someone give me some tips as to where I need to look next. My system is not running DT/CDE/OW GUI so there is plenty of memory available for Oracle, about 81MB Ram and the whole Swap at system startup before I start Oracle. How come Oracle still insists I am out of memory? ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Out of Memory
Aha!!! I actually copied the init.ora file over from a Oracle9i database and I had to rename db_cache_size to db_block_buffers. Guess, what, now I remember - db_block_buffers are in blocks and db_cache_size are in bytes. So I simply renamed the parameter without changing the number : Thanks man!!! ltiu On Saturday 17 August 2002 21:08, Ji, Richard wrote: Your db_block_buffers=1048576 times your db_block_size. If your db_block_size is 8k, you need 8gb of RAM. If db_block_size is 4k, you need 4gb of RAM. Richard -Original Message- Sent: Saturday, August 17, 2002 11:13 PM To: Multiple recipients of list ORACLE-L I am getting: SQL startup nomount ORA-27102: out of memory Machine Specs: 0) Oracle 8i 8.1.7 1) Sun Solaris 8 fully patched 2) SparcStation5 70Mhz 3) 128MB Ram 4) 256B Swap 5) /etc/system set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=100 set semsys:seminfo_semmns=200 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767 6) initSID.ora JAVA_POOL_SIZE=0 LARGE_POOL_SIZE=0 SHARED_POOL_SIZE=2097152 SORT_AREA_SIZE=262144 db_block_buffers=1048576 log_buffer=1048576 Can someone give me some tips as to where I need to look next. My system is not running DT/CDE/OW GUI so there is plenty of memory available for Oracle, about 81MB Ram and the whole Swap at system startup before I start Oracle. How come Oracle still insists I am out of memory? ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
