Re: ORA 3113 is making me miserable

Sean,
  there are many reasons why you can get an ORA-3113.

  Have a look at the alertSID.log. It usually contains   additional info.

  Try to isolate when it happens (enable trace).

  And finally (or first) ... contact your local support.   The guys are good and fast with finding solutions    to known problems.

Good luck
Dante
In article <7h6bfs$f8t$1_at_netnews.upenn.edu>,   sean_at_unagi.cis.upenn.edu (Sean B Fernandes) wrote:
> I'm a newbie DBA running Oracle 7.3.4 on AIX 4.3.2 with 2GB of
memory.
> For the last couple of days I have been experiencing a very weirdd
> problem which cropped up for no apparent reason.
>
> Users complain that they have problems connecting to Oracle. When I
go
> into Server Manager I am unable to connect to any of the 4 (250 Mb
SGA)
> instances that I have set up. I get the following error
>
> ORA 3113 - "end of file on communication channel"
>
> The first time this happened I had to reboot the box and watch Oracle
> perform recovery as there was no way to shut down the database
cleanly.
> Now I've figured out that by using ipcrm -s to remove semaphores and
> memory segments after kill -9ing all oracle processes I can get it to
> restart without having to reboot. However this is obviously a very bad
> situation and I cannot figure out what the problem is. Any help at all
> would be very much appreciated. If you need further details please e-
mail.
>
> Thanks in advance,
>
> Sean
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 10 1999 - 07:53:40 CDT