DB startup: end-of-file on communication Channel

From: Loki-2 <bart.van.hest_at_fair.nl>
Date: Fri, 12 Nov 1999 13:29:23 +0100
Message-ID: <382C0823.8CFCD130@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 - 06:29:23 CST