Home » RDBMS Server » Server Administration » ORA-27102: out of memory ? why ?
ORA-27102: out of memory ? why ? [message #369172] Tue, 04 April 2000 21:21 Go to next message
rwang
Messages: 1
Registered: April 2000
Location: Los Angeles, California, ...
Junior Member
please help, thanks a lot.
i installed oracle 8.1.6 on Sun Ultra2 box, the installer did not complete because 'Oracle not available' while creating database, so i try to do it manually with svrmgrl and get error: out of memory.
--
here are some setting: (machine has 1G memory)
in the inittest.ora (test is sid name)
db_block_buffers = 100
shared_pool_size = 3500000
log_buffer = 32768

in /etc/system
#set shmsys:shminfo_shmmax=4294967295 (does not work)
set shmsys:shminfo_shmmax=1048576
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

-----------here is how the error comes from---
web2% svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup nomount
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
SVRMGR>
Re: ORA-27102: out of memory ? why ? [message #369173 is a reply to message #369172] Wed, 05 April 2000 03:40 Go to previous messageGo to next message
Thierry Van der Auwera
Messages: 44
Registered: January 2000
Member
Hallo Rick,

Set the parameter shared_pool_size higher.

ex : shared_pool_size = 90000000

Also set your db_block_buffers higher, is better for performance.

I think this will help

Greetings,

Thierry.
Re: ORA-27102: out of memory ? why ? [message #369193 is a reply to message #369172] Thu, 06 April 2000 15:54 Go to previous message
Barry Sutter
Messages: 4
Registered: April 2000
Junior Member
1. Your current shmmax (1MB) is too small for you current shared pool (3500000).
2. Your original shmmax was far too big. I have recently configured a Sun E6500 with 4GB RAM. I dedicated 25% (1GB) to Oracle. I set shmmax to be 1.1 GB and the Oracle's shared pool to 1GB. I had trouble making them the same size. It seems that Oracle wants to take a little more than you say it can have.
3. I've had problems where the Oracle installation didn't quite finish. I don't mess around. I deleted everything that had been installed and started over.
Previous Topic: Creating a procedure in a different schema..Pls Help !!!Urgent !!!
Next Topic: Linking Excel on NT to Oracle 8
Goto Forum:
  


Current Time: Fri Mar 29 01:47:43 CDT 2024