Subject: ipc errors/Linux Emulation NetBSD-3BETA using Oracle
To: None <current-users@netbsd.org>
From: GNMJLR@terra.es <GNMJLR@terra.es>
List: current-users
Date: 11/01/2005 23:14:46
------=_Part_1992_26840148.1130883286470
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

I have installed Oracle 9.2.0.4 under NetBSD 3.0 (20051008), (Linux Emulation)
When I do a startup of the database It doesn't work (gives the error: ORA-03113: end-of-file on communication channel)

It appears that are not implmented all ipc calls. Is there some solution? Is it complex to fix this? My knowlodge about
kernel programming are limited.

Doing a ktrace -d -p pid_sql I obtain this trace (I only show the more relevant parts):
.................
CALL  ipc(1,0x1b0000,0x35,0,0xbfbfb9ac)
  1192 oracle   RET   ipc -1 errno -7 Argument list too long
  1192 oracle   CALL  ipc(1,0x1b0000,0x1a,0,0xbfbfb9ac)
  1192 oracle   RET   ipc -1 errno -7 Argument list too long
  1192 oracle   CALL  ipc(1,0x1b0000,0xd,0,0xbfbfb9ac)
  1192 oracle   RET   ipc -1 errno -7 Argument list too long
  1192 oracle   CALL  ipc(1,0x1b0000,6,0,0xbfbfb9ac)
  1192 oracle   RET   ipc -1 errno -7 Argument list too long
 1192 oracle   CALL  ipc(1,0x1b0000,3,0,0xbfbfb9ac)
  1192 oracle   RET   ipc 0
  1192 oracle   CALL  ipc(3,0x1b0000,0,0,0xbfbfb954)
  1192 oracle   RET   ipc 0
  1192 oracle   CALL  ipc(2,0x8c2d9cc8,0,0,0)
  1192 oracle   RET   ipc -1 errno -2 No such file or directory
  1192 oracle   CALL  ipc(2,0x731b3c0c,0,0,0)
  1192 oracle   RET   ipc -1 errno -2 No such file or directory
  1192 oracle   CALL  ipc(2,0xf939ae4,0,0,0)
  1192 oracle   RET   ipc -1 errno -2 No such file or directory
  1192 oracle   CALL  ipc(2,0xc4a80cac,0,0,0)
  1192 oracle   RET   ipc -1 errno -2 No such file or directory
  1192 oracle   CALL  umask(0)
  1192 oracle   RET   umask 18/0x12
  1192 oracle   CALL  umask(0x12)
  1192 oracle   RET   umask 0

........
  1192 oracle   CALL  getuid
  1192 oracle   RET   getuid 101/0x65
  1192 oracle   CALL  ipc(0x18,0xf0000,0x102,0,0xbfbfbb08)
  1192 oracle   RET   ipc -1 errno -22 Invalid argument
  1192 oracle   CALL  gettimeofday(0xbfbfb5f8,0)
  1192 oracle   RET   gettimeofday 0
..........

.....
Several messages saying:
1192 oracle   CALL  ipc(1,0x1c0000,1,0,0xbfbfbcf0)
  1192 oracle   RET   ipc -1 errno -4 Interrupted system call
  1192 oracle   PSIG  SIGALRM caught handler=0xbd782c70 mask=(33): code=SI_TIMER
 sigval 0x0)
  1192 oracle   CALL  rt_sigprocmask(0,0xbfbfba7c,0,8)
  1192 oracle   RET   rt_sigprocmask 0
.........

The output of ipcs is the next:
$ ipcs -a
IPC status from  as of Wed Nov  2 01:12:44 2005

Message Queues:
T        ID     KEY        MODE       OWNER    GROUP  CREATOR   CGROUP CBYTES  QNUM QBYTES LSPID LRPID    STIME    RTIME    CTIME

Shared Memory:
T        ID     KEY        MODE       OWNER    GROUP  CREATOR   CGROUP NATTCH   SEGSZ  CPID  LPID    ATIME    DTIME    CTIME
m    983040 -1164697984 --rw-r-----   oracle oinstall   oracle oinstall      0 50331648  1192  1192  0:21:32  0:23:37  0:21:32

Semaphores:
T        ID     KEY        MODE       OWNER    GROUP  CREATOR   CGROUP NSEMS    OTIME    CTIME
s   1835008 -1943167800 --rw-r-----   oracle oinstall   oracle oinstall    53 no-entry  0:21:32






Prueba el Nuevo Correo Terra; Seguro, R&aacute;pido, Fiable.





------=_Part_1992_26840148.1130883286470
Content-Type: text/html;charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

I have installed Oracle 9.2.0.4 under NetBSD 3.0 (20051008), (Linux Emulati=
on)<br/>When I do a startup of the database It doesn't work (gives the erro=
r: ORA-03113: end-of-file on communication channel)<br/><br/>It appears tha=
t are not implmented all ipc calls. Is there some solution? Is it complex t=
o fix this? My knowlodge about<br/>kernel programming are limited.<br/><br/=
>Doing a ktrace -d -p pid_sql I obtain this trace (I only show the more rel=
evant parts):<br/>.................<br/>CALL  ipc(1,0x1b0000,0x35,0,0xbfbfb=
9ac)<br/>  1192 oracle   RET   ipc -1 errno -7 Argument list too long<br/> =
 1192 oracle   CALL  ipc(1,0x1b0000,0x1a,0,0xbfbfb9ac)<br/>  1192 oracle   =
RET   ipc -1 errno -7 Argument list too long<br/>  1192 oracle   CALL  ipc(=
1,0x1b0000,0xd,0,0xbfbfb9ac)<br/>  1192 oracle   RET   ipc -1 errno -7 Argu=
ment list too long<br/>  1192 oracle   CALL  ipc(1,0x1b0000,6,0,0xbfbfb9ac)=
<br/>  1192 oracle   RET   ipc -1 errno -7 Argument list too long<br/> 1192=
 oracle   CALL  ipc(1,0x1b0000,3,0,0xbfbfb9ac)<br/>  1192 oracle   RET   ip=
c 0<br/>  1192 oracle   CALL  ipc(3,0x1b0000,0,0,0xbfbfb954)<br/>  1192 ora=
cle   RET   ipc 0<br/>  1192 oracle   CALL  ipc(2,0x8c2d9cc8,0,0,0)<br/>  1=
192 oracle   RET   ipc -1 errno -2 No such file or directory<br/>  1192 ora=
cle   CALL  ipc(2,0x731b3c0c,0,0,0)<br/>  1192 oracle   RET   ipc -1 errno =
-2 No such file or directory<br/>  1192 oracle   CALL  ipc(2,0xf939ae4,0,0,=
0)<br/>  1192 oracle   RET   ipc -1 errno -2 No such file or directory<br/>=
  1192 oracle   CALL  ipc(2,0xc4a80cac,0,0,0)<br/>  1192 oracle   RET   ipc=
 -1 errno -2 No such file or directory<br/>  1192 oracle   CALL  umask(0)<b=
r/>  1192 oracle   RET   umask 18/0x12<br/>  1192 oracle   CALL  umask(0x12=
)<br/>  1192 oracle   RET   umask 0<br/><br/>........<br/>  1192 oracle   C=
ALL  getuid<br/>  1192 oracle   RET   getuid 101/0x65<br/>  1192 oracle   C=
ALL  ipc(0x18,0xf0000,0x102,0,0xbfbfbb08)<br/>  1192 oracle   RET   ipc -1 =
errno -22 Invalid argument<br/>  1192 oracle   CALL  gettimeofday(0xbfbfb5f=
8,0)<br/>  1192 oracle   RET   gettimeofday 0<br/>..........<br/><br/>.....=
<br/>Several messages saying:<br/>1192 oracle   CALL  ipc(1,0x1c0000,1,0,0x=
bfbfbcf0)<br/>  1192 oracle   RET   ipc -1 errno -4 Interrupted system call=
<br/>  1192 oracle   PSIG  SIGALRM caught handler=3D0xbd782c70 mask=3D(33):=
 code=3DSI_TIMER<br/> sigval 0x0)<br/>  1192 oracle   CALL  rt_sigprocmask(=
0,0xbfbfba7c,0,8)<br/>  1192 oracle   RET   rt_sigprocmask 0<br/>.........<=
br/><br/>The output of ipcs is the next:<br/>$ ipcs -a<br/>IPC status from =
<running system> as of Wed Nov  2 01:12:44 2005<br/><br/>Message Queues:<br=
/>T        ID     KEY        MODE       OWNER    GROUP  CREATOR   CGROUP CB=
YTES  QNUM QBYTES LSPID LRPID    STIME    RTIME    CTIME<br/><br/>Shared Me=
mory:<br/>T        ID     KEY        MODE       OWNER    GROUP  CREATOR   C=
GROUP NATTCH   SEGSZ  CPID  LPID    ATIME    DTIME    CTIME<br/>m    983040=
 -1164697984 --rw-r-----   oracle oinstall   oracle oinstall      0 5033164=
8  1192  1192  0:21:32  0:23:37  0:21:32<br/><br/>Semaphores:<br/>T        =
ID     KEY        MODE       OWNER    GROUP  CREATOR   CGROUP NSEMS    OTIM=
E    CTIME<br/>s   1835008 -1943167800 --rw-r-----   oracle oinstall   orac=
le oinstall    53 no-entry  0:21:32<br/><br>
<br>
<br>
<b>Prueba el Nuevo Correo Terra; Seguro, R&aacute;pido, Fiable.</b><br>




------=_Part_1992_26840148.1130883286470--