Date: Sun, 27 Sep 1998 20:36:13 -0600 From: "Victor M. Carranza G." <victor@mp.lex.gob.gt> To: freebsd-questions@FreeBSD.ORG Cc: Sergey Solyanik <solik@solik.net> Subject: Oracle 7, shmget() problem... Message-ID: <360EF61D.6B6D9183@mp.lex.gob.gt>
next in thread | raw e-mail | index | archive | help
Oracle 7.3.2 server and SQL*Net listener appears to be running ok, so I am trying to run sqlplus client from win95. After sending username and password, it says: ERROR: ORA-01034: ORACLE not available ORA-07429: smsgsg: shmget() failed to get segment. AT&T System V/386 Error: 2: No such file or directory What file is this error talking about?? >From a FreeBSD session, I am able to use sqlplus. My kernel configuration file says: options SYSVSHM options SYSVSEM options SYSVMSG options "IBCS2" options SHMALL=5120 options "SHMMAX=(SHMMAXPGS*PAGE_SIZE+1)" options SHMMAXPGS=10240 options SHMMIN=10 options SHMMNI=100 options SHMSEG=180 options SEMMNI=20 options SEMMNS=60 my /compat/ibcs2/dev looks like: total 2 drwxr-xr-x 2 root wheel 512 Sep 27 19:57 . drwxr-xr-x 4 root wheel 512 Jan 26 1998 .. lrwxrwxrwx 1 root wheel 9 Sep 3 12:36 XOR -> /dev/null lrwxrwxrwx 1 root wheel 9 Sep 27 19:56 XOR@ -> /dev/null lrwxrwxrwx 1 root wheel 9 Sep 27 19:57 nfs@ -> /dev/null lrwxrwxrwx 1 root wheel 9 Sep 3 12:36 nfsd -> /dev/null -rw-rw-r-- 1 root wheel 0 Sep 3 12:36 null lrwxrwxrwx 1 root wheel 9 Jan 26 1998 socksys -> /dev/null lrwxrwxrwx 1 root wheel 9 Sep 27 19:57 socksys@ -> /dev/null (FAQ entry about this shows filenames with a "@", I am not sure why, so I have created two versions of each file). The shm test program from Oracle, shows: Number of segments gotten by shmget() = 13 Number of segments attached by shmat() = 13 Segments attach at higher addresses Maximum size segments are not attached contiguously! Segment separation = 2097152 bytes Default shared memory address = 0x9001000 Lowest shared memory address = 0x9001000 Highest shared memory address = 0xefa01000 Total shared memory range = -423624704 Total shared memory attached = 27262976 Largest single segment size = 2097152 Segment boundaries (SHMLBA) = 4194304 (0x400000) Any ideas? My FreeBSD version is 3.0-981006-SNAP. Thanks in advance! -- +------------------------------------------+ | Víctor Manuel Carranza González | | Ministerio Público de Guatemala | | Llave pública PGP disponible a solicitud | | PGP public key available on request | +------------------------------------------+ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?360EF61D.6B6D9183>