Re: Can NOT startup database and got error ORA-27300, 27301 and 27302
From: David Ballester <ballester.david_at_gmail.com>
Date: Thu, 23 Jul 2009 18:28:22 +0200
Message-ID: <6a29f8b0907230928y114f426ejdb19a8662ff94a5_at_mail.gmail.com>
2009/7/23 dba1 mcc <mccdba1_at_yahoo.com>
Date: Thu, 23 Jul 2009 18:28:22 +0200
Message-ID: <6a29f8b0907230928y114f426ejdb19a8662ff94a5_at_mail.gmail.com>
2009/7/23 dba1 mcc <mccdba1_at_yahoo.com>
>
> ipcs -s
>
> %ipcs -s
>
> ------ Semaphore Arrays --------
> key semid owner perms nsems
> 0x963683ec 4751396 oracle 640 10
>
(...)
0xd5f2a5c0 29720718 oracle 640 154
>
>
> can you tell me how to calculate how many semaphores already use on server?
>
> Thanks.
ipcs -s | awk '{sum +=$5} END {print sum}'
you can discriminate with a grep by owner value, for example
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 23 2009 - 11:28:22 CDT