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

"Manfred Rebentisch" <mr_at_comparat.de> wrote in message news:amp7o9.2fq.ln_at_lxs5.comparat.intra...
> I try to install Oracle 8.1.7 on Suse Linux 7.2.
> After Installing I start dbassist to create database, but with 80% it
stops
> with the Message "ORA-03113: end-of-file on communication channel". After
> that I get the message ORA-03114: not connected to ORACLE.
> The seed.log file tells:
>
> Connected.
> ORA-03113: end-of-file on communication channel
> create controlfile reuse set database "m3ora"
> *
> ORA-03114: not connected to ORACLE
> alter database "m3ora" open resetlogs
> *
> ORA-03114: not connected to ORACLE
> alter system enable restricted session
> *
> ORA-03114: not connected to ORACLE
> alter database "m3ora" character set WE8ISO8859P1
> *
> ORA-03114: not connected to ORACLE
> alter database "m3ora" national character set US7ASCII
> *
> ORA-03114: not connected to ORACLE
> alter database rename global_name to "m3ora"
> *
> ORA-03114: not connected to ORACLE
> ORA-03113: end-of-file on communication channel
>
> ============================
> The settings:
> unset LANG
> export ORACLE_BASE=/opt/oracle
> export ORACLE_HOME=$ORACLE_BASE/oraHome
> export ORACLE_OWNER=oracle
> export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
> export ORACLE_SCRIPTS_DIR=$ORACLE_HOME/bin
> export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
> export TNS_ADMIN=$ORACLE_HOME/admin
> export PATH=$ORACLE_HOME/bin:$PATH
> export ORACLE_SID=m3ora
> export ORACLE_TERM=xterm
> export DISPLAY=WS15:0
> #export JAVA_HOME=/usr/lib/jdk1.1.8
> export JAVA_HOME=/opt/oracle/jre/1.1.8
> export CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip
> export LD_LIBRARY_PATH=$ORACLE_HOME/lib
>
>
> --
> Manfred Rebentisch
> COMPARAT GmbH

One of the common courses for this error is incorrect semaphore and shared memory segments settings. This will result in the database not starting at all, resulting in 3113.
So questions:
Did you check the alert.log?
Did you set the number of semaphores (2 times the number of processes + 5)

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Sep 18 2001 - 12:31:37 CDT