If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support
Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Mon Apr 14 07:26:22 2003 SMON: enabling tx recovery Mon Apr 14 07:26:22 2003 Database Characterset is JA16SJIS replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN Mon Apr 14 15:04:35 2003 Thread 1 advanced to log sequence 93 Mon Apr 14 15:04:35 2003 Current log# 2 seq# 93 mem# 0: X:\ORACLE\ORADATA\YKDB\REDO02.LOG Current log# 2 seq# 93 mem# 1: X:\ORACLE\ORADATA\YKDB\REDO12.LOG Mon Apr 14 15:04:36 2003 ARC0: Evaluating archive log 1 thread 1 sequence 92 Mon Apr 14 15:04:36 2003 ARC0: Beginning to archive log 1 thread 1 sequence 92 Creating archive destination LOG_ARCHIVE_DEST_1: 'X:\ORACLE\ORADATA\YKDB\ARCHIVE\ARC00092.001' ARC0: Completed archiving log 1 thread 1 sequence 92这是我从alert.log中取出来的。从客户端的程序的log看,一台错误从2003/04/14 14:38:02开始发生错误,一台2003/04/14 11:19:13开始发生错误。可能是网络冲突吗?以下的原因可能吗?怎么查才好? 3. Third most common cause is a machine crash or network failure at the server side. 4. One less common cause has been observed is when there are two servers with the same node names on the same network. 7. ORA-03113 also occurs when there are duplicate IP addresses on the network. To find the duplicate addresses turn off the unit that is getting the 03113 and ping its IP address. If the ping responds then you have to find the offending unit. (这种方法试过了,还有其他方法发现 duplicate IP吗?)
ORA-03113 end-of-file on communication channel Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the SQL*Net, two task, software. This message could occur if the shadow two-task process associated with a SQL*Net connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down. Action: If this message occurs during a connection attempt, check the setup files for the appropriate SQL*Net driver and confirm SQL*Net software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.
依你的情况看,应该不是经常出现。
Successfully onlined Undo Tablespace 1.
Mon Apr 14 07:26:22 2003
SMON: enabling tx recovery
Mon Apr 14 07:26:22 2003
Database Characterset is JA16SJIS
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Mon Apr 14 15:04:35 2003
Thread 1 advanced to log sequence 93
Mon Apr 14 15:04:35 2003
Current log# 2 seq# 93 mem# 0: X:\ORACLE\ORADATA\YKDB\REDO02.LOG
Current log# 2 seq# 93 mem# 1: X:\ORACLE\ORADATA\YKDB\REDO12.LOG
Mon Apr 14 15:04:36 2003
ARC0: Evaluating archive log 1 thread 1 sequence 92
Mon Apr 14 15:04:36 2003
ARC0: Beginning to archive log 1 thread 1 sequence 92
Creating archive destination LOG_ARCHIVE_DEST_1: 'X:\ORACLE\ORADATA\YKDB\ARCHIVE\ARC00092.001'
ARC0: Completed archiving log 1 thread 1 sequence 92这是我从alert.log中取出来的。从客户端的程序的log看,一台错误从2003/04/14 14:38:02开始发生错误,一台2003/04/14 11:19:13开始发生错误。可能是网络冲突吗?以下的原因可能吗?怎么查才好?
3. Third most common cause is a machine crash or network failure at the
server side.
4. One less common cause has been observed is when there are two servers with
the same node names on the same network.
7. ORA-03113 also occurs when there are duplicate IP addresses on the
network. To find the duplicate addresses turn off the unit that is getting
the 03113 and ping its IP address. If the ping responds then you have to
find the offending unit. (这种方法试过了,还有其他方法发现 duplicate IP吗?)
Action: If this message occurs during a connection attempt, check the setup files for the appropriate SQL*Net driver and confirm SQL*Net software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.