Can't get rid of ORA-27123 error

From: <elcaro_at_my-dejanews.com>
Date: 1998/12/27
Message-ID: <765t5p$r9r$1@nnrp1.dejanews.com>#1/1

Hello all,

I would be grateful if someone could point me in the right direction with this installation of Oracle 8.0.5. I must install this on a Sun IPX system with 64 megs RAM and a 240 megabyte virtual swap memory.

I have played with the shared memory segments endlessly and always end up with the same problem, that I get an ORA27123 error. This happens when I try to start up an instance of the database. In an effort to try to debug this error I have truss'd the process and followed through what is going on. It looks like the shared memory segment is being fetched properly, but when it is being attached to there is an error. Here is a small snipped from the truss file: (This happens when running svrmgrl, doing a connect internal {which succeeds} and then running the command startup)

1. times(0xEFFFD3D0) = 2523011
2. shmget(-265100280, 5787648, 0640|IPC_CREAT|IPC_EXCL) = 800
3. shmget(-265100279, 0, 0) Err#2 ENOENT
4. shmget(-265100278, 0, 0) Err#2 ENOENT
5. shmget(-265100277, 0, 0) Err#2 ENOENT
6. shmat(800, 0x80000000, 040000) Err#22 EINVAL
7. times(0xEFFFCDC0) = 2523025
8. stat("/oracle/rdbms/log", 0xEFFFC8A8) = 0
9. getpid() = 1470 [1468]
10. getpid() = 1470 [1468]

[This to me looks like it was assigned a return value of 800 on the first shmget but the other three fail.] Later on the truss file shows this:

1. shmctl(800, 10, 0) = 0
2. shmget(-265100280, 0, 0) Err#2 ENOENT
3. shmget(-265100279, 0, 0) Err#2 ENOENT
4. shmget(-265100278, 0, 0) Err#2 ENOENT
5. shmget(-265100277, 0, 0) Err#2 ENOENT
6. open("/oracle/rdbms/mesg/oraus.msb", O_RDONLY) = 14
7. fcntl(14, F_SETFD, 0x00000001) = 0
8. lseek(14, 0, SEEK_SET) = 0
9. read(14, "1513 "011303\t\t\0\0\0\0".., 256) = 256
10. lseek(14, 512, SEEK_SET) = 512
11. read(14, "1DC3 p o t1A\0\0\0\0\0\0".., 512) = 512
12. lseek(14, 1536, SEEK_SET) = 1536
13. read(14, "1DD31DDF1E\01E191E %1E I".., 512) = 512
14. lseek(14, 256512, SEEK_SET) = 256512
15. read(14, "\0\f iF1\0\0\0 P iF2\0\0".., 512) = 512
16. close(14) = 0
17. read(10, "\092\0\006\0\0\0\0\004\0".., 2064) = 146 ORA-27123: unable to attach to shared memory segment SVR4 Error: 22: Invalid argument

The /etc/system file shows the shared memory allocation as follows:

forceload: sys/msgsys
forceload: sys/semsys
forceload: sys/shmsys
set shmsys:shminfo_shmmax=48000000
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

set semsys:seminfo_semmns=200
set semsys:seminfo_semmni=70

If anyone can point me in the right direction as to what is wrong I would be very grateful as I can't do anything with Oracle until it is running properly.

Many Thanks

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Dec 27 1998 - 00:00:00 CST