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

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Tue, 19 May 2009 10:48:26 -0500 (CDT)
Message-ID: <d978ae855f4197669590d2bea9746b53.squirrel_at_society.servebeer.com>

#3 is alarming to me. There should be regularly updated timestamps in there for things like log switches and backups at least -- there are no log switches in >1 month?

Also, you said you're not able to reboot, so you changed permissions while the instance was up? I'm not sure, but that strikes me as not being the recommended procedure.

Check your listener.log, if you have one. While I don't believe it will show bequeath connection issues, it may have pointers to related problems.

Are your available sessions maxed out? (init.ora/spfile parameter)

My kneejerk $.02,
Rich

> 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.

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

Received on Tue May 19 2009 - 10:48:26 CDT