Re: Oracle 10g hangs ...earlier running smoothly
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 May 2009 10:48:26 -0500 (CDT)
#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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
