Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Server Lock-ups

Re: Oracle Server Lock-ups

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Thu, 20 Mar 2003 18:21:03 -0000
Message-ID: <kEnea.3850$pK2.4120@news.indigo.ie>


Oracle does not normally display this behaviour out of the box.  I am running 9202 on a MUCH smaller box than you are with none of these issues.

Can you connect at the server itself via SQL*Plus ?

What did you use to stop the Oracle Service ?

what does tnsping give from the clients

what's the output from
lsnrctl status on the server ?

Clients can connect and select, but lock up at first
> attempt to update or append (I didn't try delete). This behavior was
> duplicated with SQL-Plus

well what locked up the first time if not SQL*plus ?

Are any errors reported in the Alert log ?

And so forth... Received on Thu Mar 20 2003 - 12:21:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US