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

I've good a similar message by starting one Oracle-DB on our HP-UX-Server....
Later I found out that there was not enough memory for the database. I choosed the minimized Parameter of the sampel-init.ora but our Server only have had 256 MB RAM and there was also 1 ADABAS-DB's, 1 Informix-DB and 5 Progress-DB running. Now I have a second server only for Oracle, all is fine....

Greetings
Guido Kutasi

Loki-2 <bart.van.hest_at_fair.nl> schrieb in im Newsbeitrag: 382C0823.8CFCD130_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 - 16:11:36 CST