Home » RDBMS Server » Server Administration » Error during starting a database
Error during starting a database [message #297056] Wed, 30 January 2008 00:44 Go to next message
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 #297061 is a reply to message #297056] Wed, 30 January 2008 00:46 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>ORA-27301: OS failure message: No space left on device
Which volume has no free space?
Re: Error during starting a database [message #297067 is a reply to message #297056] Wed, 30 January 2008 00:54 Go to previous messageGo to next message
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 #297099 is a reply to message #297056] Wed, 30 January 2008 02:43 Go to previous messageGo to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
Thanks for your reply.
Can you tell me which parameter?

Regards
Sushil

[Updated on: Wed, 30 January 2008 03:16]

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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #297272 is a reply to message #297056] Wed, 30 January 2008 23:30 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
At your earliest convenience, you should reboot the system.
Re: Error during starting a database [message #297282 is a reply to message #297056] Thu, 31 January 2008 00:13 Go to previous messageGo to next message
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

Re: Error during starting a database [message #297328 is a reply to message #297282] Thu, 31 January 2008 02:47 Go to previous message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
Thanks Manjeet

Regards
Sushil
Previous Topic: system statistics - where can I see the current values
Next Topic: Logminer not showing recent actions
Goto Forum:
  


Current Time: Tue Dec 06 12:20:15 CST 2016

Total time taken to generate the page: 0.08786 seconds