Re: Oracle 10g hangs ...earlier running smoothly
- From: Saad Khan <saad4u@xxxxxxxxx>
- To: "Johnson, William L (TEIS)" <WLJohnson@xxxxxxxxxxxxxxxxxxx>
- Date: Tue, 19 May 2009 11:09:33 -0400
Few more facts:
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@xxxxxxxxxxxxxxxxxxx> wrote:
> On the same lines…are you auditing and filled the audit tablespace?
>
>
> ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Rajeev Prabhakar
> *Sent:* Tuesday, May 19, 2009 10:57 AM
> *To:* saad4u@xxxxxxxxx
> *Cc:* oracle-l@xxxxxxxxxxxxx
> *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@xxxxxxxxx> wrote:
>
> Good Morning fellows,
>
> Thanks.
>
> Sid
>
>
>
Other related posts:
