| Error during starting a database [message #297056] |
Wed, 30 January 2008 00:44  |
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
|
Junior Member |
|
|
Hi all,
When I am starting up the database after a clean shutdown i am getting the folling error.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
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
My Init.ora parameters are
*.background_dump_dest='/ora0/app/oracle/admin/blitz/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/ora0/app/oracle/oradata/blitz/control01.ctl','/ora0/app/oracle/oradata/blitz/control02.ctl','/ora0/app/oracl
e/oradata/blitz/control03.ctl'
*.core_dump_dest='/ora0/app/oracle/admin/blitz/cdump'
*.cursor_sharing='SIMILAR'
*.cursor_space_for_time=true
*.db_block_size=8192
*.db_cache_size=134217720
*.db_domain='objectorb.com'
*.db_file_multiblock_read_count=16
*.db_name='blitz'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='blitz'
*.java_pool_size=10485760
*.large_pool_size=8388608
*.log_archive_dest_1='location=/ora0/orabackup/arch'
*.log_archive_format='arch%S.arc'
*.log_archive_max_processes=1
*.log_archive_start=FALSE
*.log_checkpoints_to_alert=FALSE
*.open_cursors=300
*.pga_aggregate_target=67108864
*.processes=150
*.query_rewrite_enabled='TRUE'
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_limit=TRUE
*.sga_max_size=536870912
*.shared_pool_size=115343360
*.sort_area_size=2097152
*.sql_trace=FALSE
*.star_transformation_enabled='FALSE'
*.statistics_level='ALL'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/ora0/app/oracle/admin/blitz/udump'
My semaphore parameters are
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
Regards
Sushil
|
|
|
|
|
|
| Re: Error during starting a database [message #297067 is a reply to message #297056] |
Wed, 30 January 2008 00:54  |
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
|
Member |
|
|
Appears like you have been playing with semaphores. If its not a production database than go ahead, but you must understand what you are doing.some changes have database wide consequences.
| Quote: | Read this only if you are on production :-
[Not enough semaphores to allow you to create more processes.Need to set your kernel parameters correctly for the number of processes you want have. ]
|
All the best.
Manjit Kumar [mkbhati]
[Updated on: Wed, 30 January 2008 01:00] Report message to a moderator |
|
|
|
|
|
| Re: Error during starting a database [message #297268 is a reply to message #297056] |
Wed, 30 January 2008 22:44 |
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
|
Member |
|
|
Only if you can post your kernel version & OS version & amount of RAM you have. Also confirm if you are running multiple Instances on this host. also post back output of ipcs -b | grep oracle if possible.
Regards
manjit Kumar [mkbhati]
|
|
|
|
| Re: Error during starting a database [message #297271 is a reply to message #297268] |
Wed, 30 January 2008 23:23 |
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
|
Junior Member |
|
|
Thanks for your reply,
OS version
SunOS flash 5.8 Generic_117350-01 sun4u sparc SUNW,Ultra-4
Kernel version
64-bit sparcv9 kernel modules
RAM
2GB
I am using multiple instances
bash-2.05$ ipcs -b | grep oracle
m 3500 0x3bd7218c --rw-r----- oracle oinstall 180355072
m 2301 0x280c7b24 --rw-r----- oracle oinstall 142606336
m 3902 0xbea3df70 --rw-r----- oracle oinstall 142606336
m 1503 0xf4d57a44 --rw-r----- oracle oinstall 142606336
m 5704 0x726781b8 --rw-r----- oracle oinstall 222298112
s 4653056 0x39e7788 --ra-r----- oracle oinstall 19
s 1114113 0x39e7789 --ra-r----- oracle oinstall 19
s 1114114 0x39e778a --ra-r----- oracle oinstall 19
s 1114115 0x39e778b --ra-r----- oracle oinstall 19
s 1114116 0x39e778c --ra-r----- oracle oinstall 19
s 1114117 0x39e778d --ra-r----- oracle oinstall 19
s 1114118 0x39e778e --ra-r----- oracle oinstall 19
s 1114119 0x39e778f --ra-r----- oracle oinstall 19
s 1114120 0x39e7790 --ra-r----- oracle oinstall 19
s 1114121 0x39e7791 --ra-r----- oracle oinstall 19
s 1310730 0x39e7792 --ra-r----- oracle oinstall 19
s 1114123 0x39e7793 --ra-r----- oracle oinstall 19
s 1114124 0x39e7794 --ra-r----- oracle oinstall 19
s 1114125 0x39e7795 --ra-r----- oracle oinstall 19
s 1114126 0x39e7796 --ra-r----- oracle oinstall 19
s 1114127 0x39e7797 --ra-r----- oracle oinstall 19
s 1114128 0x39e7798 --ra-r----- oracle oinstall 19
s 1114129 0x39e7799 --ra-r----- oracle oinstall 19
s 1114130 0x39e779a --ra-r----- oracle oinstall 19
s 1114131 0x39e779b --ra-r----- oracle oinstall 19
s 2883604 0xd9d80684 --ra-r----- oracle oinstall 13
s 720917 0xd9d80685 --ra-r----- oracle oinstall 13
s 720918 0xd9d80686 --ra-r----- oracle oinstall 13
s 720919 0xd9d80687 --ra-r----- oracle oinstall 13
s 720920 0xd9d80688 --ra-r----- oracle oinstall 13
s 720921 0xd9d80689 --ra-r----- oracle oinstall 13
s 720922 0xd9d8068a --ra-r----- oracle oinstall 13
s 720923 0xd9d8068b --ra-r----- oracle oinstall 13
s 720924 0xd9d8068c --ra-r----- oracle oinstall 13
s 720925 0xd9d8068d --ra-r----- oracle oinstall 13
s 5177374 0xbdc1091c --ra-r----- oracle oinstall 19
s 1245215 0xbdc1091d --ra-r----- oracle oinstall 19
s 1245216 0xbdc1091e --ra-r----- oracle oinstall 19
s 1441825 0xbdc1091f --ra-r----- oracle oinstall 19
s 1245218 0xbdc10920 --ra-r----- oracle oinstall 19
s 1245219 0xbdc10921 --ra-r----- oracle oinstall 19
s 1245220 0xbdc10922 --ra-r----- oracle oinstall 19
s 1245221 0xbdc10923 --ra-r----- oracle oinstall 19
s 1245222 0xbdc10924 --ra-r----- oracle oinstall 19
s 1245223 0xbdc10925 --ra-r----- oracle oinstall 19
s 655400 0xd9d8068e --ra-r----- oracle oinstall 13
s 655401 0xd9d8068f --ra-r----- oracle oinstall 13
s 1900586 0x67092bd8 --ra-r----- oracle oinstall 19
s 1441835 0x67092bd9 --ra-r----- oracle oinstall 19
s 655404 0x67092bda --ra-r----- oracle oinstall 19
s 655405 0x67092bdb --ra-r----- oracle oinstall 19
s 655406 0x67092bdc --ra-r----- oracle oinstall 19
s 655407 0x67092bdd --ra-r----- oracle oinstall 19
s 655408 0x67092bde --ra-r----- oracle oinstall 19
s 655409 0x67092bdf --ra-r----- oracle oinstall 19
s 655410 0x67092be0 --ra-r----- oracle oinstall 19
s 655411 0x67092be1 --ra-r----- oracle oinstall 19
s 6750260 0xa22d3f64 --ra-r----- oracle oinstall 13
s 1769525 0xa22d3f65 --ra-r----- oracle oinstall 13
s 589878 0xa22d3f66 --ra-r----- oracle oinstall 13
s 589879 0xa22d3f67 --ra-r----- oracle oinstall 13
s 524344 0xa22d3f68 --ra-r----- oracle oinstall 13
s 327737 0xa22d3f69 --ra-r----- oracle oinstall 13
Regards
Sushil
[Updated on: Wed, 30 January 2008 23:23] Report message to a moderator |
|
|
|
|
|
| Re: Error during starting a database [message #297282 is a reply to message #297056] |
Thu, 31 January 2008 00:13 |
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
|
Member |
|
|
There is no magic formula but try to resolve using following hints hope you may be able to hit the root of problem.
1. It is common for semaphores to exhaust on multiple instance hosts. If every thing was fine & working before incident than it may be attributed to large number of semaphores locked by other instances. [if your system was up for a long time]As suggested by Ana try rebooting & restarting your instances one by one if you can afford it.
2. If no luck by rebooting. Try increasing maximum numbers of semaphores [SEMMNS] by increasing it to a higher value. Following recommendations are valid for most unix/linux versions but please consult docs for your SunOS before you proceed as changing these values may have system wide impact. Also refer oracle installation guide for your platform for recommended range of values.
Semaphore You posted Rec Range Remarks
semmni 100 128 - 250 Max semaphore sets in entire system
semmns 1024 32000 Max semaphore count in entire system
semmsl nil 250 Max semaphores per semaphore set
3. If tuning semaphores do not yield any results than have a look on your shared memory segments they may also need tuning.
Regards
Manjit Kumar [mkbhati]
[Updated on: Thu, 31 January 2008 00:26] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
