| 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 -> ORA-27123: unable to attach to shared memory segment
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:
Please be specific. I have access to neither sunsolve nor Oracle support.
Thanks,
Dave Eidman
dave_at_access.digex.net
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]
time(seconds) unlimited file(blocks) unlimited data(kbytes) 523256 stack(kbytes) 8192 coredump(blocks) unlimited nofiles(descriptors) 64 memory(kbytes) unlimited
swapfile dev swaplo blocks free /dev/dsk/c0t3d0s1 32,25 8 393672 349896 [From swap -l]
/ 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]
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]
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
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]
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)}
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)}
}
Tracing: { adb truss crash }
4) output of the shmtst utility script
5) output of the tstshm utility script
Default shared memory address = 0xeef20000 Lowest shared memory address = 0xdffe0000 Highest shared memory address = 0xeef20000 Total shared memory range = 252968960 Total shared memory attached = 20971520 Largest single segment size = 2097152 Segment boundaries (SHMLBA) = 4096 (0x1000) ====================================================================== 6) output of the 'ipcs -a' command =====================================================================IPC status from <running system> as of Tue Aug 10 19:29:43 1999 Message Queue facility not in system.
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 T ID KEY MODE OWNER GROUP CREATORCGROUP NSEMS OTIME CTIME
7) last 40 lines of sql.log
>> Leaving rdbms_common.ins >>> Leaving ocommon.ins >>> Leaving client.ins >>> Entering rdbms.ins >>> Entering ordts_common.ins >>> Leaving ordts_common.ins >>> Entering agent_net_common.ins >>> Leaving agent_net_common.ins >>> Entering svrmgr.ins >>> Leaving svrmgr.ins
]---------------------------------------------Action: Running starttest.sql
| Ok: | Ok: Oracle Server Manager Release 3.0.5.0.0 - Production | Ok: | Ok: (c) Copyright 1997, Oracle Corporation. All Rights Reserved. | Ok: | Ok: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production | Ok: PL/SQL Release 8.0.5.0.0 - Production | Ok: | Ok: SVRMGR> Connected. | Ok: ORA-27123: unable to attach to shared memory segment | Ok: SVR4 Error: 22: Invalid argument | Ok: create controlfile reuse set database "test" | Ok: * | Ok: ORA-01034: ORACLE not available | Ok: alter database "test" open resetlogs | Ok: * | Ok: ORA-01034: ORACLE not available | Ok: Disconnected. | Ok: SVRMGR> Server Manager complete.
]---------------------------------------------
===============================================================================
8) inittest.ora ('test' was the name used for $ORACLE_SID)
===============================================================================
#
# include database configuration parameters ifile = /u01/app/oracle/admin/test/pfile/configtest.ora
rollback_segments = (r01,r02,r03,r04)
############################################################################## # Example INIT.ORA file # # This file is provided by Oracle Corporation to help you customize # your RDBMS installation for your site. Important system parameters # are discussed, and example settings given. # # Some parameter settings are generic to any size installation. # For parameters that require different values in different size # installations, three scenarios have been provided: SMALL, MEDIUM # and LARGE. Any parameter that needs to be tuned according to # installation size will have three settings, each one commented # according to installation size. # # Use the following table to approximate the SGA size needed for the # three scenarious provided in this file: # # -------Installation/Database Size------ # SMALL MEDIUM LARGE # Block 2K 4500K 6800K 17000K # Size 4K 5500K 8800K 21000K # # To set up a database that multiple instances will be using, place # all instance-specific parameters in one file, and then have all # of these files point to a master file using the IFILE command. # This way, when you change a public # parameter, it will automatically change on all instances. This is# necessary, since all instances must run with the same value for many # parameters. For example, if you choose to use private rollback segments,
# # INSTRUCTIONS: Edit this file and the other INIT files it calls for # your site, either by using the values provided here or by providing # your own. Then place an IFILE= line into each instance-specific # INIT file that points at this file. ###############################################################################
# tuning parameters
db_files = 80
db_file_multiblock_read_count = 8 # SMALL # db_file_multiblock_read_count = 16 # MEDIUM # db_file_multiblock_read_count = 32 #LARGE
db_block_buffers = 200 # SMALL # db_block_buffers = 550 # MEDIUM # db_block_buffers = 3200 #LARGE
shared_pool_size = 3500000 # SMALL # shared_pool_size = 6000000 # MEDIUM # shared_pool_size = 9000000 #LARGE log_checkpoint_interval = 10000
processes = 50 # SMALL # processes = 100 # MEDIUM # processes = 200 #LARGE
dml_locks = 100 # SMALL # dml_locks = 200 # MEDIUM # dml_locks = 500 #LARGE
log_buffer = 8192 # SMALL # log_buffer = 32768 # MEDIUM # log_buffer = 163840 #LARGE
sequence_cache_entries = 10 # SMALL # sequence_cache_entries = 30 # MEDIUM # sequence_cache_entries = 100 #LARGE
sequence_cache_hash_buckets = 10 # SMALL # sequence_cache_hash_buckets = 23 # MEDIUM # sequence_cache_hash_buckets = 89 #LARGE
# audit_trail = true # if you want auditing
# timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5 Meg each
# log_archive_start = true # if you want automatic archiving
global_names = TRUE
# mts_dispatchers="ipc,1" # mts_max_dispatchers=10 # mts_servers=1 # mts_max_servers=10 # mts_service=test # mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))" # # needed if running OPS
 |
 |