Re: Can't get rid of ORA-27123 error

Hi, Please forgive me for the lack of information on my reply. My Sun Box and Oracle Database is currently being used for y2k testing, so I cannot really help you but I can point you into the right direction.

Two possibilities: 1. There is a bug (Bug No. 476463) on some platforms (like Solaris 2.5.1). Make sure that in your init<sid>.ora file, you have "use_ism = false". There is a fix in 8.0.6. If you are using Solaris 2.5.1, you will need patch ID 103640-14.

2. If you do a 'uname -a' on your IPX, you will notice that the unit uses a Sun4c archticture, verses a Sun4m. You will have to change the address in which your Shared Memory attaches too. This address is called the "sgabeg" address. For example, I would change it from 0x80000000 to 0x8000000.

Good Luck,
Satar
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

In article <765t5p$r9r$1_at_nnrp1.dejanews.com>,   elcaro_at_my-dejanews.com wrote:
> 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)
>
> 1470: times(0xEFFFD3D0) = 2523011
> 1470: shmget(-265100280, 5787648, 0640|IPC_CREAT|IPC_EXCL) = 800
> 1470: shmget(-265100279, 0, 0) Err#2 ENOENT
> 1470: shmget(-265100278, 0, 0) Err#2 ENOENT
> 1470: shmget(-265100277, 0, 0) Err#2 ENOENT
> 1470: shmat(800, 0x80000000, 040000) Err#22 EINVAL
> 1470: times(0xEFFFCDC0) = 2523025
> 1470: stat("/oracle/rdbms/log", 0xEFFFC8A8) = 0
> 1470: getpid() = 1470 [1468]
> 1470: 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:
>
> 1470: shmctl(800, 10, 0) = 0
> 1470: shmget(-265100280, 0, 0) Err#2 ENOENT
> 1470: shmget(-265100279, 0, 0) Err#2 ENOENT
> 1470: shmget(-265100278, 0, 0) Err#2 ENOENT
> 1470: shmget(-265100277, 0, 0) Err#2 ENOENT
> 1470: open("/oracle/rdbms/mesg/oraus.msb", O_RDONLY) = 14
> 1470: fcntl(14, F_SETFD, 0x00000001) = 0
> 1470: lseek(14, 0, SEEK_SET) = 0
> 1470: read(14, "1513 "011303\t\t\0\0\0\0".., 256) = 256
> 1470: lseek(14, 512, SEEK_SET) = 512
> 1470: read(14, "1DC3 p o t1A\0\0\0\0\0\0".., 512) = 512
> 1470: lseek(14, 1536, SEEK_SET) = 1536
> 1470: read(14, "1DD31DDF1E\01E191E %1E I".., 512) = 512
> 1470: lseek(14, 256512, SEEK_SET) = 256512
> 1470: read(14, "\0\f iF1\0\0\0 P iF2\0\0".., 512) = 512
> 1470: close(14) = 0
> 1468: 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
>

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