Ora
in [Solaris]
|
Prev: Old Solaris 8/9 ISO images
Next: Skype
From: Target on 10 Aug 2005 09:34 From: Oracle Administrators 10-Aug-05 12:37 Subject: ORA-27154 :post/wait create failed RDBMS Version: 9.2.0.6 Operating System and Version: sun solaris 9 Error Number (if applicable): ora-27154 Product (i.e. SQL*Loader, Import, etc.): Product Version: ORA-27154 :post/wait create failed Hy, I want to create a new database and following messages/errors occur during the creation of a database is: ORA-27154 :post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates I tried to configure /etc/system and init.ora files and change max number of processes, semaphors and max alloc memory. s01dev2# less /etc/system ident "@(#)system 1.18 97/06/27 SMI" /* SVR4 1.5 */ SYSTEM SPECIFICATION FILE set sd:sd_max_throttle=20 set sd:sd_io_time = 0x3C set noexec_user_stack=1 set shmsys:shminfo_shmmin=1 D set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmni=200 set shmsys:shminfo_shmseg=20 set semsys:seminfo_semmns=1024 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=256 D set semsys:seminfo_semopm=100 forceload: drv/sd *EMCpower forceload ssd added following: forceload: drv/ssd forceload: drv/emcp forceload: misc/emcpmp forceload: misc/emcpmpc forceload: misc/emcpmpaa forceload: misc/emcpmpap forceload: misc/emcpsapi forceload: misc/emcpcg forceload: misc/emcphr forceload: misc/emcpsm forceload: misc/emcpsc forceload: misc/emcpevm forceload: misc/emcpdpm forceload: misc/emcpioc set emcp:bPxEnableInit=1 set lwp_default_stksize=0x6000 set rpcmod:svc_default_stksize=0x6000 set semsys:seminfo_semmns=0x13d set semsys:seminfo_semmni=0xc set semsys:seminfo_semmsl=0x81 *EMCpower added the following line: set semsys:seminfo_semmap=0x13d set semsys:seminfo_semmnu=0x13d s01dev2# less /opt/home/init.ora ############################################################################## # Copyright (c) 1991, 2001, 2002 by Oracle Corporation ########################################### # Cache and I/O ########################################### db_block_size=8192 db_cache_size=471859200 db_file_multiblock_read_count=16 Cursors and Library Cache ########################################### open_cursors=300 ## Database Identification ########################################### db_domain="" db_name=hdt # Diagnostics and Statistics ########################################### background_dump_dest=/opt/orabill/admin/hdt/bdump core_dump_dest=/opt/orabill/admin/hdt/cdump timed_statistics=TRUE user_dump_dest=/opt/orabill/admin/hdt/udump # File Configuration control_files=("/ora/orabill/oradata/hdt/control01.ctl", "/ora/orabill/oradata/hdt/control02.ctl", " /ora/orabill/oradata/hdt/control03.ctl") # Instance Identification ########################################### instance_name=hdt # Miscellaneous ########################################### compatible=9.2.0.0.0 # Optimizer hash_join_enabled=TRUE query_rewrite_enabled=FALSE star_transformation_enabled=FALSE # Pools ########################################### java_pool_size=157286400 large_pool_size=10485760 shared_pool_size=104857600 # Processes and Sessions ########################################### processes=150 sessions=50 # Redo Log and Recovery ########################################### fast_start_mttr_target=300 # Security and Auditing ########################################### remote_login_passwordfile=EXCLUSIVE # Sort, Hash Joins, Bitmap Indexes ########################################### pga_aggregate_target=25165824 sort_area_size=4194304 # System Managed Undo and Rollback Segments ########################################### undo_management=AUTO undo_retention=10800 undo_tablespace=UNDOTBS1
From: Lothar Armbruester on 10 Aug 2005 12:36 Target wrote: > > From: Oracle Administrators 10-Aug-05 12:37 > Subject: ORA-27154 :post/wait create failed > > RDBMS Version: 9.2.0.6 > Operating System and Version: sun solaris 9 > Error Number (if applicable): ora-27154 > Product (i.e. SQL*Loader, Import, etc.): > Product Version: > > ORA-27154 :post/wait create failed > > Hy, > I want to create a new database and following messages/errors occur > during > the creation of a database is: > > ORA-27154 :post/wait create failed > ORA-27300: OS system dependent operation:semget failed with status: 28 > ORA-27301: OS failure message: No space left on device > ORA-27302: failure occurred at: sskgpcreates > [...] Hello Target, "No space left on device" sounds quite clear for me. Maybe the disk where you want to create the database is full. Another point colud be insufficient swap space but I would expect another error message for that. Hope that helps, Lothar -- Lothar Armbrýster | la(a)oktagramm.de Hauptstr. 26 | la(a)heptagramm.de D-65346 Eltville | lothar.armbruester(a)t-online.de
From: Bojan Mihevc on 11 Aug 2005 04:47 Lothar Armbruester wrote: > [...] > Hello Target, > "No space left on device" sounds quite clear for me. > Maybe the disk where you want to create the database is full. Another > point colud be insufficient swap space but I would expect another error > message for that. > > Hope that helps, > Lothar > Hi, Target and I trying to solve tihis problem but we think that is not problem in HDD space or swap. kthr memory page disk faults cpu r b w swap free re mf pi po fr de sr m1 m1 m1 m1 in sy cs us sy id 0 0 0 21753216 900240 6 7 1 0 0 0 1 0 0 0 0 219 49 105 0 0 100 0 0 0 21759160 898128 6 7 0 0 0 0 0 0 0 0 0 218 40 105 0 0 100 0 0 0 21759160 898128 6 6 0 0 0 0 0 0 0 0 0 240 42 114 0 0 100 Any ideas? Thanks.
From: Niels Baggesen on 11 Aug 2005 05:01 Lothar Armbruester <lothar.armbruester(a)t-online.de> wrote: > Target wrote: > > ORA-27154 :post/wait create failed > > ORA-27300: OS system dependent operation:semget failed with status: 28 > > ORA-27301: OS failure message: No space left on device > "No space left on device" sounds quite clear for me. > Maybe the disk where you want to create the database is full. Another > point colud be insufficient swap space but I would expect another error > message for that. Note that the error message is linked to semget. You seem to have run out of semaphores. You configure the max number of semphores in /etc/system: set semsys:seminfo_semmni=100 set semsys:seminfo_semmns=1024 set semsys:seminfo_semmsl=256 You can check their current values with "sysdef -i" /Niels -- Niels Baggesen -- @home -- ýrhus -- Denmark -- niels(a)baggesen.net The purpose of computing is insight, not numbers -- R W Hamming
|
Pages: 1 Prev: Old Solaris 8/9 ISO images Next: Skype |