Re: DB startup: end-of-file on communication Channel

Hi,

I had the same problem a while back. Are you using TWO_TASK ?

My recollection is that it was while connecting to the database that I got it.

Either it is TWO_TASK or the ORACLE_SID is not correctly set.

Suresh Bhat
Oracleguru
www.oracleguru.net

Loki-2 <bart.van.hest_at_fair.nl> wrote in article <382C114E.37E958CA_at_fair.nl>...
> Question from a non-DBA-er:
>
> When the 3 databases on the server are started after a reboot of
> the server, 2 of them are ok, the third gives an error message
> from svrmgrl. Is states that the instance is started and gives info
> on the System Global Area, etc. Next i get this message:
> ORA-3113 end-of-file on communication Channel
> Probably has to do with SQL-net settings so i checked the only
> SQL-net files i know:
> /etc/listener.ora
> /etc/tnsnames.ora
> These contain the TCP/IP settings for all 3 databases and seem to
> be o.k.
>
> Any suggestions?
>
> Thanks, Bart
>
> additional info:
> #
> # Installation Generated Net8 Configuration
> # Version Date: Oct-27-97
> # Filename: Tnsnames.ora
> #
> extproc_connection_data =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = testdb))
> (CONNECT_DATA = (SID = extproc))
> )
>
> testdb =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= 'changed_name')(Port= 1521))
> (CONNECT_DATA = (SID = testdb))
> )
>
> demodb =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= 'changed_name')(Port= 1521))
> (CONNECT_DATA = (SID = demodb))
> )
>
> proddb =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= 'changed_name')(Port= 1521))
> (CONNECT_DATA = (SID = proddb))
> )
>
> #
> # Installation Generated Net8 Configuration
> # Version Date: Jun-17-97
> # Filename: Listener.ora
> #
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS= (PROTOCOL= IPC)(KEY= testdb))
> (ADDRESS= (PROTOCOL= IPC)(KEY= proddb))
> (ADDRESS= (PROTOCOL= IPC)(KEY= demodb))
> (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
> (ADDRESS= (PROTOCOL= TCP)(Host= 'changed_name')(Port= 1521))
> )
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (ORACLE_HOME= /app00/oracle/product/804test)
> (SID_NAME = testdb)
> )
> (SID_DESC =
> (ORACLE_HOME= /app00/oracle/product/804prod)
> (SID_NAME = proddb)
> )
> (SID_DESC =
> (ORACLE_HOME= /app00/oracle/product/804test)
> (SID_NAME = demodb)
> )
> (SID_DESC =
> (SID_NAME = extproc)
> (ORACLE_HOME = /app00/oracle/product/804test)
> (PROGRAM = extproc)
> )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 0
> TRACE_LEVEL_LISTENER = OFF
>
Received on Fri Nov 12 1999 - 08:25:21 CST