Re: Oracle 10g hangs ...earlier running smoothly

1. The oracle version is 10.2.0.1
2. The machine is up for 87 days. [Tao:Not sure if the bug applies here or no]
3. The Alert file was last updated on Apr. 11. And the last messages were normal logswitches and other stuff. Nothing very alarming
4. I dont think the audit was ever turned on.
5. There is plenty of space (in GBs) available in filesystems particularly ORACLE_HOME
6. changePerm.sh is already run.

On Tue, May 19, 2009 at 11:03 AM, Johnson, William L (TEIS) < WLJohnson_at_tycoelectronics.com> wrote:

> On the same lines…are you auditing and filled the audit tablespace?
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Rajeev Prabhakar
> *Sent:* Tuesday, May 19, 2009 10:57 AM
> *To:* saad4u_at_gmail.com
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Oracle 10g hangs ...earlier running smoothly
>
>
>
> Hello Saad,
>
> If the adjusting permissions is not very helpful, could you check if the
> free space
> on the filesystem is not the issue. I vaguely remember having encountered
> this (low
> space on either home directory of the oracle id, ORACLE_HOME directory OR
> dest
> directories for udump/bdump) a while back and preventing sqlplus
> connections. Does
> the alert log show anything ?
>
> -Rajeev
>
> On Tue, May 19, 2009 at 10:43 AM, Saad Khan <saad4u_at_gmail.com> wrote:
>
> Good Morning fellows,
>
> Thanks.
>
> Sid
>
>
>

--
http://www.freelists.org/webpage/oracle-l