Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Server Lock-ups
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