Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DB startup: end-of-file on communication Channel
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 #
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 #
(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)))
(ORACLE_HOME= /app00/oracle/product/804test) (SID_NAME = testdb)
(ORACLE_HOME= /app00/oracle/product/804prod) (SID_NAME = proddb)
(ORACLE_HOME= /app00/oracle/product/804test) (SID_NAME = demodb)
(SID_NAME = extproc) (ORACLE_HOME = /app00/oracle/product/804test) (PROGRAM = extproc)