Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Calling in the Cavalry - Hanging 8i database
On 16 May 2005 06:31:37 -0700, "Johne_uk" <edgarj_at_tiscali.co.uk>
wrote:
>Yes every single application, TOAD, Sqlplus session is hung. Can only
>connect as internal not even as a dba account.
>
>regards
>John
Have you verified the number of semaphores against the number of
processes?
#semaphores should be = 2 * #processes + 10
-- Sybrand Bakker, Senior Oracle DBAReceived on Mon May 16 2005 - 09:44:34 CDT