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