| Oracle 817, Solaris 8, Out of memory, ORA-27102 [message #97920] |
Tue, 03 June 2003 11:44  |
DP
Messages: 15
Registered: February 2002
|
Junior Member |
|
|
No RTFM please, if you have passion, read this:
I have Solaris 8 installed with 1GB of RAM, 3GB of swap space, 4 disc of size 36GB each and mirrored under solsuite disk suite. My /etc/system file has typical sharedMemSegment+semaphore from Oracle manual, which is perfectly working on other m/c with same database configuration but w/o disc mirroring, as listed below.
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=200
set semsys:seminfo_semmns=300
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
During DB creation, oracle fails with
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
messages.
* Trace file does not reveal anything but the fact that it could not claim shared memory of 128MB with following message.
Tue Jun 3 12:11:35 2003
Starting ORACLE instance (normal)
Tue Jun 3 12:11:36 2003
WARNING: EINVAL creating segment of size 0x000000000784e000
fix shm parameters in /etc/system or equivalent
* Some additional checks:
* Total memory installed.
#prtconf | grep size
Memory size: 1024 Megabytes
* Top shows that 914 MB is free!
load averages: 0.04, 0.05, 0.02 13:16:16
32 processes: 31 sleeping, 1 on cpu
CPU states: 97.6% idle, 0.0% user, 2.4% kernel, 0.0% iowait, 0.0% swap
Memory: 1024M real, 914M free, 25M swap in use, 3802M swap free
* ipcs -b shows:
==============
IPC status from <running system> as of Tue Jun 3 13:20:04 EDT 2003
T ID KEY MODE OWNER GROUP QBYTES
Message Queues:
T ID KEY MODE OWNER GROUP SEGSZ
Shared Memory:
m 0 0x5001ecbf --rw-r--r-- root root 4
T ID KEY MODE OWNER GROUP NSEMS
Semaphores:
=============
So what is wrong?
-Thanks,
DP.
|
|
|
|
|
|
| Re: Oracle 817, Solaris 8, Out of memory, ORA-27102 [message #97924 is a reply to message #97923] |
Wed, 04 June 2003 20:25  |
DP
Messages: 15
Registered: February 2002
|
Junior Member |
|
|
Thanks for your attempt.
Yes, I had already did everything you mentioned in your email, just forgot to put it in my original post - it was lengthy anyway!
Besides, here is the reason why all went wrong in first place! - it is interesting to learn.
In fact our SA found out the the machine had some issues with mirroring! Solstice suite was reporting that one of the mirrored disk was in critical condition! - so that's why is was not reading /etc/system file, fix mirrors first! -
He fixed it, restarted the box and everything was fine.
-Thanks again,
DP.
|
|
|
|
|
|
| Re: Oracle 817, Solaris 8, Out of memory, ORA-27102 [message #126469 is a reply to message #97920] |
Tue, 05 July 2005 00:32 |
man_on_hunt_420
Messages: 2
Registered: July 2005
Location: pakistan
|
Junior Member |
|
|
hi dear
I also face the sane problem few years earlier
I solved thid problrm it take lot of time
U know by solving this problem i got promotion in trh company
see i'm a genious
I'm working in a Mnc i mean (made not in china)
so if u want to solve this problem u have to log in again
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
