Re: ORA 3113 is making me miserable

One of the usual situations that cause this error is running binaries (sqlplus, svrmgrl) from a different version of the RDBMS in $ORACLE_HOME; this may happen if you have more than one version of Oracle installed and the PATH is not correct. For example, i just simulated this by setting the environment to my oracle 7.1.6 database and using the sqlplus in my oracle 7.3.3 home - then i get the ORA 3113 error....

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

--
Mário Miguel Nogueira
Systems Administrator
mario.nogueira_at_jae.pt

The statements and opinions expressed here are my own and do not necessarily represent those of my employer. Received on Wed May 12 1999 - 11:33:30 CDT