Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> more on ORA 03113: end-of-file on communication channel

more on ORA 03113: end-of-file on communication channel

From: Tim Smith <timasmith_at_hotmail.com>
Date: 23 Apr 2002 18:13:16 -0700
Message-ID: <a7234bb1.0204231713.43f8f0f1@posting.google.com>


I realise there are many postings on this subject but I still can't see the answer (this is local access through svrmgrl not a net config issue).
Here is some more info:

  1. System changes noted below
  2. The error occurs immediately after switching to the ora8i user and issuing $ svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production ORA-03113: end-of-file on communication channel
  3. If I change my ORACLE_SID to a database that does not exist I do not get the error (immediately) - so what is svrmgrl doing to cause the error - I completely stopped the database instance so there are no processes running for this instance but it still gets the error.
set semsys:seminfo_semmap=2500
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=2500
set semsys:seminfo_semmnu=100
set semsys:seminfo_semmsl=25
set semsys:seminfo_semopm=25
set shmsys:shminfo_shmmax=134217728 (up from 8M)
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=600 (up from 100)
set shmsys:shminfo_shmseg=100 (up from 10)


Tim Smith wrote:

> Hi,
> We have Oracle 7.3 and Oracle 8.1 on the sun4u sparc SUNW,Ultra-4
> Solaris 2.6 server.
>
> Before a reboot we could connect to databases on either version.
>
> After the reboot if I log on as either user (oracle8 or oracle7) I
> can connect via the listener to all Oracle7 databases but none of the
> Oracle8 databases.
>
> The listener was originally started by Oracle7 but then was
> restarted by the Oracle8 user.
>
> I get the error ORA-03113: end-of-file on communication channel
> trying to get via svrmgrl or directly through sqlplus
Received on Tue Apr 23 2002 - 20:13:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US