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

Do you notice anything sticky about
ls -l $ORACLE_HOME/bin/oracle

if not try chmod 7755 $ORACLE_HOME/bin/oracle

Greg

Tim Smith wrote:

> 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
>>