| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-27123: unable to attach to shared memory segment
So far there seem to be several problems:
Personally I would change the account and re-install.
Hth,
Sybrand Bakker, Oracle DBA
Dave Eidman <dave_at_access.digex.net> wrote in message
news:37B0E02F.1717B659_at_access.digex.net...
> HELP!
>
> I am trying to install Oracle 8.0.5 Enterprise Server (Trial Version)
> The environment is Solaris 2.6 running on a Sparc 2 with 64 meg. The
> install
> fails when trying to create the database.
>
>
> The version of Solaris has had no patches installed.
>
> Any suggestions would be appreciated.
>
> Below is attached more than you would ever want to know about the
> environment:
>
>
>
> 1) /etc/system
>
> 2) output of sysdef
>
> 3) output of the unixenv utility
>
> 4) output of the shmtst utility script
>
> 5) output of the tstshm utility
>
> 6) output of the 'ipcs -a' utility
>
> 7) last 40 lines of sql.log
>
> 8) inittest.ora
>
> Please be specific. I have access to neither sunsolve nor Oracle
> support.
>
>
>
> Thanks,
>
> Dave Eidman
>
> dave_at_access.digex.net
>
>
>
>
> 1) /etc/system :
> =====================================================================
> *ident "@(#)system 1.18 97/06/27 SMI" /* SVR4 1.5 */
> *
> * SYSTEM SPECIFICATION FILE
> *
>
> * moddir:
> *
> * Set the search path for modules. This has a format similar to the
> * csh path variable. If the module isn't found in the first directory
> * it tries the second and so on. The default is /kernel /usr/kernel
> *
> * Example:
> * moddir: /kernel /usr/kernel /other/modules
>
>
>
> * root device and root filesystem configuration:
> *
> * The following may be used to override the defaults provided by
> * the boot program:
> *
> * rootfs: Set the filesystem type of the root.
> *
> * rootdev: Set the root device. This should be a fully
> * expanded physical pathname. The default is the
> * physical pathname of the device where the boot
> * program resides. The physical pathname is
> * highly platform and configuration dependent.
> *
> * Example:
> * rootfs:ufs
> * rootdev:/sbus_at_1,f8000000/esp_at_0,800000/sd_at_3,0:a
> *
> * (Swap device configuration should be specified in /etc/vfstab.)
>
>
>
> * exclude:
> *
> * Modules appearing in the moddir path which are NOT to be loaded,
> * even if referenced. Note that `exclude' accepts either a module name,
> * or a filename which includes the directory.
> *
> * Examples:
> * exclude: win
> * exclude: sys/shmsys
>
>
>
> * forceload:
> *
> * Cause these modules to be loaded at boot time, (just before mounting
> * the root filesystem) rather than at first reference. Note that
> * forceload expects a filename which includes the directory. Also
> * note that loading a module does not necessarily imply that it will
> * be installed.
> *
> * Example:
> * forceload: drv/foo
>
>
>
> * set:
> *
> * Set an integer variable in the kernel or a module to a new value.
> * This facility should be used with caution. See system(4).
> *
> * Examples:
> *
> * To set variables in 'unix':
> *
> * set nautopush=32
> * set maxusers=40
> *
> * To set a variable named 'debug' in the module named 'test_module'
> *
> * set test_module:debug = 0x13
> set shmsys:shminfo_shmmax=4294967295
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=10
> set shmsys:shminfo_shmmns=4294967295
> set semsys:seminfo_semmns=200
> set semsys:seminfo_semmni=70
> set semsys:seminfo_semmsl=1002
> ======================================================================
>
>
> 2) output of sysdef command
>
> =====================================================================
> *
> * Hostid
> *
> 55c0ffee
> *
> * sun4c Configuration
> *
> *
> * Devices
> *
> packages (driver not attached)
> disk-label (driver not attached)
> deblocker (driver not attached)
> obp-tftp (driver not attached)
> openprom (driver not attached)
> zs, instance #0
> zs, instance #1
> audio (driver not attached)
> eeprom (driver not attached)
> counter-timer (driver not attached)
> memory-error (driver not attached)
> interrupt-enable (driver not attached)
> auxiliary-io (driver not attached)
> sbus, instance #0
> le, instance #0
> dma, instance #0
> esp, instance #0
> sd (driver not attached)
> st (driver not attached)
> sd, instance #0 (driver not attached)
> sd, instance #1 (driver not attached)
> sd, instance #2
> sd, instance #3
> sd, instance #4 (driver not attached)
> sd, instance #5 (driver not attached)
> sd, instance #6
> cgsix, instance #0
> memory (driver not attached)
> virtual-memory (driver not attached)
> fd, instance #0
> options, instance #0
> pseudo, instance #0
> clone, instance #0
> ip, instance #0
> tcp, instance #0
> udp, instance #0
> icmp, instance #0
> arp, instance #0
> sad, instance #0
> consms, instance #0
> conskbd, instance #0
> wc, instance #0
> iwscn, instance #0
> ptsl, instance #0
> tl, instance #0
> cn, instance #0
> mm, instance #0
> openeepr, instance #0
> kstat, instance #0
> log, instance #0
> sy, instance #0
> pm, instance #0
> vol, instance #0
> ptm, instance #0
> pts, instance #0
> logindmux, instance #0
> ksyms, instance #0
> *
> * Loadable Objects
> *
> strmod/bufmod
> strmod/connld
> strmod/dedump
> strmod/ldterm
> strmod/ms
> strmod/pckt
> strmod/pfmod
> strmod/pipemod
> strmod/ptem
> strmod/redirmod
> strmod/rpcmod
> hard link: sys/rpcmod
> strmod/timod
> strmod/tirdwr
> strmod/ttcompat
> strmod/hwc
> strmod/bd
> sched/TS
> sched/TS_DPTBL
> genunix
> sys/c2audit
> sys/doorfs
> sys/inst_sync
> sys/kaio
> sys/msgsys
> sys/pipe
> sys/pset
> sys/semsys
> sys/shmsys
> drv/arp
> hard link: strmod/arp
> drv/arp
> drv/be
> drv/bpp
> drv/clone
> drv/clone
> drv/cn
> drv/cn
> drv/conskbd
> drv/conskbd
> drv/consms
> drv/consms
> drv/esp
> drv/icmp
> drv/icmp
> drv/ip
> drv/ip
> drv/isp
> drv/iwscn
> drv/iwscn
> drv/le
> drv/lebuffer
> drv/llc1
> drv/llc1
> drv/log
> drv/log
> drv/mm
> drv/mm
> drv/openeepr
> drv/openeepr
> drv/options
> drv/options
> drv/pci_pci
> drv/profile
> drv/pseudo
> drv/pseudo
> drv/ptc
> drv/ptc
> drv/ptsl
> drv/ptsl
> drv/qe
> drv/qec
> drv/rts
> drv/rts
> drv/sad
> drv/sad
> drv/sd
> drv/sd
> drv/sp
> drv/sp
> drv/st
> drv/st
> drv/sy
> drv/sy
> drv/tcp
> drv/tcp
> drv/tl
> drv/tl
> drv/udp
> drv/udp
> drv/wc
> drv/wc
> drv/xbox
> drv/fas
> drv/hme
> drv/socal
> drv/pcic
> drv/pcic
> drv/pcs
> drv/pem
> drv/pem
> drv/stp4020
> drv/pcelx
> drv/pcmem
> drv/pcram
> drv/pcram
> drv/pcser
> drv/ecpp
> drv/glm
> drv/se
> drv/pcata
> drv/rtvc
> drv/ses
> drv/ses
> drv/pln
> drv/pln
> drv/soc
> drv/ssd
> drv/ssd
> exec/aoutexec
> exec/elfexec
> exec/intpexec
> fs/cachefs
> fs/fifofs
> fs/hsfs
> fs/lofs
> fs/nfs
> hard link: sys/nfs
> fs/procfs
> fs/sockfs
> fs/specfs
> fs/tmpfs
> fs/ufs
> fs/autofs
> misc/consconfig
> misc/des
> misc/ipc
> misc/klmmod
> misc/klmops
> misc/krtld
> misc/nfs_dlboot
> misc/nfssrv
> misc/rpcsec
> misc/rpcsec_gss
> misc/scsi
> misc/seg_drv
> misc/seg_mapdev
> misc/strplumb
> misc/swapgeneric
> misc/tlimod
> misc/cis
> misc/cs
> misc/pcalloc
> misc/pcmcia
> *
> * System Configuration
> *
> swap files
> swapfile dev swaplo blocks free
> /dev/dsk/c0t3d0s1 32,25 8 393672 349856
> *
> * Tunable Parameters
> *
> 1314816 maximum memory allowed in buffer cache (bufhwm)
> 1002 maximum number of processes (v.v_proc)
> 99 maximum global priority in sys class (MAXCLSYSPRI)
> 997 maximum processes per user id (v.v_maxup)
> 30 auto update time limit in seconds (NAUTOUP)
> 25 page stealing low water mark (GPGSLO)
> 5 fsflush run rate (FSFLUSHR)
> 25 minimum resident memory for avoiding deadlock (MINARMEM)
> 25 minimum swapable memory for avoiding deadlock (MINASMEM)
> *
> * Utsname Tunables
> *
> 5.6 release (REL)
> SS2 node name (NODE)
> SunOS system name (SYS)
> Generic version (VER)
> *
> * Process Resource Limit Tunables (Current:Maximum)
> *
> ffffffff:fffffffd cpu time
> ffffffff:fffffffd file size
> ffffffff:fffffffd heap size
> ffffffff:fffffffd stack size
> 0:1fefe000 core file size
> ffffffff:fffffffd file descriptors
> 0: 800000 mapped memory
> *
> * Streams Tunables
> *
> 9 maximum number of pushes allowed (NSTRPUSH)
> 65536 maximum stream message size (STRMSGSZ)
> 1024 max size of ctl part of message (STRCTLSZ)
> *
> * IPC Messages
> *
> 0 entries in msg map (MSGMAP)
> 0 max message size (MSGMAX)
> 0 max bytes on queue (MSGMNB)
> 0 message queue identifiers (MSGMNI)
> 0 message segment size (MSGSSZ)
> 0 system message headers (MSGTQL)
> 0 message segments (MSGSEG)
> *
> * IPC Semaphores
> *
> 10 entries in semaphore map (SEMMAP)
> 70 semaphore identifiers (SEMMNI)
> 200 semaphores in system (SEMMNS)
> 30 undo structures in system (SEMMNU)
> 1002 max semaphores per id (SEMMSL)
> 10 max operations per semop call (SEMOPM)
> 10 max undo entries per process (SEMUME)
> 32767 semaphore maximum value (SEMVMX)
> 16384 adjust on exit max value (SEMAEM)
> *
> * IPC Shared Memory
> *
> 4294967295 max shared memory segment size (SHMMAX)
> 1 min shared memory segment size (SHMMIN)
> 100 shared memory identifiers (SHMMNI)
> 10 max attached shm segments per process (SHMSEG)
> *
> * Time Sharing Scheduler Tunables
> *
> 60 maximum time sharing user priority (TSMAXUPRI)
> SYS system class name (SYS_NAME)
> ========================================================================
>
> 3) output of the unixenv utility
>
>
> ====================================================================
>
> Machine Environment:
> --------------------
>
>
> User: uid=1002(oracle) gid=10(staff)
> Current Directory: /u01/app/oracle/product/8.0.5/orainst
> Machine: {
> System = SunOS
> Node = SS2
> Release = 5.6
> KernelID = Generic
> Machine = sun4c
> BusType = <unknown>
> Serial = <unknown>
> Users = <unknown>
> OEM# = 0
> Origin# = 1
> NumCPU = 1
>
> [From uname -X]
>
> SS2
> [From hostname]
> }
> Ulimit: {
> time(seconds) unlimited
> file(blocks) unlimited
> data(kbytes) 523256
> stack(kbytes) 8192
> coredump(blocks) unlimited
> nofiles(descriptors) 64
> memory(kbytes) unlimited
> }
> Swap: {
> swapfile dev swaplo blocks free
> /dev/dsk/c0t3d0s1 32,25 8 393672 349896
> [From swap -l]
> }
> Disk Mounts: {
> / on /dev/dsk/c0t3d0s0 read/write/setuid/largefiles on Tue Aug 10
> 16:26:40 1999
> /usr on /dev/dsk/c0t3d0s6 read/write/setuid/largefiles on Tue Aug 10
> 16:26:40 1999
> /proc on /proc read/write/setuid on Tue Aug 10 16:26:40 1999
> /dev/fd on fd read/write/setuid on Tue Aug 10 16:26:40 1999
> /export/home on /dev/dsk/c0t3d0s7 setuid/read/write/largefiles on Tue
> Aug 10 16:26:46 1999
> /opt on /dev/dsk/c0t3d0s5 setuid/read/write/largefiles on Tue Aug 10
> 16:26:46 1999
> /tmp on swap read/write on Tue Aug 10 16:26:46 1999
> /u01 on /dev/dsk/c0t2d0s0 setuid/read/write/largefiles on Tue Aug 10
> 16:26:46 1999
> /u02 on /dev/dsk/c0t2d0s1 setuid/read/write/largefiles on Tue Aug 10
> 16:26:46 1999
> /u03 on /dev/dsk/c0t2d0s3 setuid/read/write/largefiles on Tue Aug 10
> 16:26:46 1999
> /u04 on /dev/dsk/c0t2d0s4 setuid/read/write/largefiles on Tue Aug 10
> 16:26:46 1999
> [From mount]
> }
> Disk Free: {
> Filesystem kbytes used avail capacity Mounted on
> /dev/dsk/c0t3d0s0 123205 20437 102645 17% /
> /dev/dsk/c0t3d0s6 582654 382750 199322 66% /usr
> /proc 0 0 0 0% /proc
> fd 0 0 0 0% /dev/fd
> /dev/dsk/c0t3d0s7 288457 135 288034 1% /export/home
> /dev/dsk/c0t3d0s5 491910 11688 479731 3% /opt
> swap 205544 16 205528 1% /tmp
> /dev/dsk/c0t2d0s0 1016453 243881 770878 25% /u01
> /dev/dsk/c0t2d0s1 1016453 125075 889684 13% /u02
> /dev/dsk/c0t2d0s3 1016453 11 1014748 1% /u03
> /dev/dsk/c0t2d0s4 981757 11 980110 1% /u04
> [From df -k]
> }
> Environment: {
> HOME=/export/home/oracle
> HZ=100
> LC_COLLATE=en_US
> LC_CTYPE=en_US
> LC_MESSAGES=C
> LC_MONETARY=en_US
> LC_NUMERIC=en_US
> LC_TIME=en_US
> LD_LIBRARY_PATH=/u01/app/oracle/product/8.0.5/lib:/usr/dt/lib
> LOGNAME=oracle
> MAIL=/var/mail/oracle
> ORACLE_BASE=/u01/app/oracle
> ORACLE_HOME=/u01/app/oracle/product/8.0.5
> ORACLE_SID=test
> ORACLE_TERM=sun
>
>
PATH=/u01/app/oracle/product/8.0.5/bin:/bin:/opt/bin:/usr/bin:/usr/ccs/bin:/
usr/ucb:/etc:
> SHELL=/bin/sh
> TERM=ansi
> TMPDIR=/var/tmp
> TZ=US/Eastern
> }
> System Tables: {
>
> SunOS SS2 5.6 Generic sun4c 08/10/99
>
> 22:09:41 proc-sz ov inod-sz ov file-sz ov lock-sz
> 22:09:42 62/1002 0 4722/4722 0 397/397 0 0/0
> [From sar -v 1 1]
> }
> Semaphores: {
> IPC status from <running system> as of Tue Aug 10 22:09:44 1999
> T ID KEY MODE OWNER GROUP CREATOR
> CGROUP NSEMS OTIME CTIME
> Semaphores:
> [From ipcs -sa]
>
> 10 entries in semaphore map (SEMMAP)
> 70 semaphore identifiers (SEMMNI)
> 200 semaphores in system (SEMMNS)
> 30 undo structures in system (SEMMNU)
> 1002 max semaphores per id (SEMMSL)
> 10 max operations per semop call (SEMOPM)
> 10 max undo entries per process (SEMUME)
> 32767 semaphore maximum value (SEMVMX)
> 16384 adjust on exit max value (SEMAEM)
> }
> Shared Mem: {
> IPC status from <running system> as of Tue Aug 10 22:09:49 1999
> T ID KEY MODE OWNER GROUP CREATOR
> CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME
> Shared Memory:
> m 0 0x50018948 --rw-r--r-- root root root
> root 1 68 227 227 16:27:53 16:27:53 16:27:53
> [From ipcs -ma]
>
> 4294967295 max shared memory segment size (SHMMAX)
> 1 min shared memory segment size (SHMMIN)
> 100 shared memory identifiers (SHMMNI)
> 10 max attached shm segments per process (SHMSEG)
> }
> /var/opt/oracle/oratab: {
>
>
> }
> Tracing: { adb truss crash }
>
>
##############################################################################
###############################################################################
 |
 |