Re: Oracle/Sun Crashing

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 07 Dec 1999 21:00:09 +0800
Message-ID: <384D04D9.58CE@yahoo.com>

Dave wrote:
>
> Hi, I need help
> I have SUN Sparc Centre 2000 running Oracle 7.3.3
> As of Friday it is hanging completely. I can't get in to
> it and have to power it down and bring it back up again.
> Some details below.
>
> > uname -a
> SunOS scs2000 5.5.1 Generic sun4d sparc SUNW,SPARCcenter-2000
>
> /etc/system
>
> set shmsys:shminfo_shmmax=268435456
> set shmsys:shminfo_shmmin=200
> set shmsys:shminfo_shmmni=200
> set shmsys:shminfo_shmseg=200
> set semsys:seminfo_semmap=250
> set semsys:seminfo_semmni=500
> set semsys:seminfo_semmns=500
> set semsys:seminfo_semmnu=500
> set semsys:seminfo_semmsl=500
> set semsys:seminfo_semopm=100
> set semsys:seminfo_semume=100
> set semsys:seminfo_semusz=256
> set semsys:seminfo_semvmx=32767
> set semsys:seminfo_semaem=16384
>
> The Machine has 4 cpu's and 256mb ram.
>
> Oracle seems fine, it starts up and SQL Selects still work fine.
> If I try and build an index it will run for a while and then crash.
> Clock still ticks but network dies and console hangs up.
> Stop-A does not work.
> Is my Oracle database broken?
> How can I tell.
> My Oracle tables are big, 2 tables of 40 million rows.
>
> Any help please!!
> dave_at_scsdirect.co.uk

Check with oracle support - we had a 7.3.3 version on Sun that ORA-600'd when doing index rebuilds...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Dec 07 1999 - 07:00:09 CST