17,377
社区成员
发帖
与我相关
我的任务
分享有哪位高手能解决ORA-03113 end-of-file on communication channel故障（高分）
前面没有谁说得比较清楚
...全文
请发表友善的回复…
发表回复
sun9989 2002-07-24
- 打赏
- 举报
像这样的问题你应根据实际情况来解决：
以下是为你收集的资料：
1、 zhanghw(zhanghw) 给你贴的一段。
2、我在ORACLE网站上找的：
Doc ID: Note:1003596.6
Subject: ORA-03113 AND ORA-03114 ON DESKTOP PLATFORMS
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 05-APR-1994
Last Revision Date: 07-MAY-2002
Problem Description:
====================
You are using SQL*Net on desktop platforms and getting ORA-03113 and ORA-03114.
Problem Explanation:
====================
ORA-03113, 00000, "end-of-file on communication channel"
ORA-03114, 00000, "not connected to ORACLE"
Search words:
Gupta, SQLWindows
Solution Description:
=====================
ORA-03113 and ORA-03114 on Desktop Platforms
============================================
What does ORA-03113 "end-of-file on communication channel" really mean?
ORA-03113 is the most common catchall error. It basically means that
communications were lost for an unexpected reason. It is usually followed by
ORA-03114 "not connected to ORACLE".
1. As it turns out, the most common reason is that the Oracle shadow process
on the server died unexpectedly. So, if a running process were to
suddenly encounter an ORA-03113 and/or 3114, the first place to check is
the alert.log on the server to see if any other Oracle errors occurred.
2. Next most common cause of ORA-03113 is that the SQL*Net driver was not
linked into the Oracle executable on Unix. While the listener
successfully received the connection and passed it to the Oracle shadow
process, the shadow process would fail to respond in any way because it
would not know how to. So the client will see an ORA-03113 at connect
time.
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.
5. ORA-03113 has also been noticed where the a TOKEN RING card has the
Shared RAM size set to 8KB rather than 16KB. If you are using a TOKEN
RING card check the shared buffer size and try increasing it.
6. ORA-03113 also occurs when INIT.ORA parameters CONTEXT_AREA and
CONTEXT_INCR are set to a value of 4096. Increasing the value to 8192
resolves the 3113. (RDVMS V6 only)
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.
8. If an ORA-03113 error occurs intermittentlly on comparatively large select
statements through SQL*DBA for OS/2 or when performing a query through
SQL*DBA, try setting the default buffer size to 4096, especially if
issuing an order by causes no problems but going through Q&E or SQR hangs
the machine.
9. If using FTP V2.11 and running a large SQL*Plus script with over 38
variables of mostly character data types, check the lan drivers. The dxmc
driver loads addressing for token ring adapter has an option to save
memory (through IBM lan suppport program).
r parameter (r: reduced)
t parameter (t: tiny)
You must specify the r and t parameter for the dxmc drive.
It all comes down to the fact that the client went out to read some
information from the server and suddenly found out the connection was no
longer there.
ORA-03113 is just a symptom of a larger problem that will require more
diagnosis to track down. Hopefully, the above information will lead you
in the right direction to find the solution.
To debug an ORA-03113, it is a good idea to attempt the same operation
while doing a loopback, i.e can any tool on the server connect using the
same connect string as they specify from the Desktop client? If the same
problem occurs doing a loopback, then you know the problem resides on the
server side and not on the Desktop client side.
To perform a loopback invoke SQLPLUS or SQLDBA from the server, and at the
SQLPLUS or SQLDBA prompt on the server type:
CONNECT USERNAME/PASSWORD@t:<servername>/<portnum>:<sid>
For example, if you are getting an ORA-03113 issuing a certain query from
SQL*Plus on DOS while connected via SQL*Net TCP/IP to a Unix server, try
a loopback by invoking SQL*Plus on the Unix machine and use the same
"t:<servername>:<sid>" connect string and then issue the same SELECT
statement.
10. If you're getting an ORA-03113 on long queries with SQL*Net SPX protocol
adapter v2.0.14.x.x on Windows or any version of the adapter v2.0.15 up to
2.0.15.0.4 on Windows, you are strongly encouraged to upgrade to
v2.0.15.0.5 of the adapter with SQL*Net v2.0.15.0.3. The ORA-03113
usually occurs after a 120-second delay in the query.
Note: If your server is running the Unixware-Oracleware configuration,
you will need to get the v2.0.15.0.5 SPX Adapter for Windows patch to go
with your v2.0.14 SQL*Net for Windows. This configuration is only
supported for Unixware-Oracleware customers.
11. This error is sometimes received intermittently with applications written
with Gupta SQLWindows. Apparently, the problem is due to some buffer
being used by the Gupta product. This buffer is used to fetch data
returned by a query on the client side. The default value for a parameter
called FETCH ROW (in SQLWINDOWS) is 20. Lowering this to something like
15 seems to work fine.
12. If you are receiving an ORA-03113 error when running SQL*Net TCPIP v1
from Windows clients to a Netware v3.11 file server, and you are using
the TCPIP.NLM V1.00, then you must obtain the updated TCPIP.NLM (V2.02M).
It is also recommended to obtain the latest library patches for the
NetWare file server (currently available in the NOVFILES forum on
CompuServe as LIBUP4.EXE).
Many enhancements and bug fixes have been made to the later TCPIP.NLM that
Novell is currently shipping in their TCP188.EXE patch file located on
their FTP server or located in the NOVLIB forum on CompuServe.
Starting with SQL*Net TCP/IP 1.1.6.20 and later, TCPIP.NLM V2.02M is
needed for Oracle's TCP/IP driver to properly set the keepalive timers.
The latest SQL*Net V1 TCP/IP for NetWare to Date is 1.1.6.29 and that is
also recommended for any customer with ANY earlier release of the V1
listener for NetWare.
13. Check that your network router is not filtering the data.
.
以下是为你收集的资料：
1、 zhanghw(zhanghw) 给你贴的一段。
2、我在ORACLE网站上找的：
Doc ID: Note:1003596.6
Subject: ORA-03113 AND ORA-03114 ON DESKTOP PLATFORMS
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 05-APR-1994
Last Revision Date: 07-MAY-2002
Problem Description:
====================
You are using SQL*Net on desktop platforms and getting ORA-03113 and ORA-03114.
Problem Explanation:
====================
ORA-03113, 00000, "end-of-file on communication channel"
ORA-03114, 00000, "not connected to ORACLE"
Search words:
Gupta, SQLWindows
Solution Description:
=====================
ORA-03113 and ORA-03114 on Desktop Platforms
============================================
What does ORA-03113 "end-of-file on communication channel" really mean?
ORA-03113 is the most common catchall error. It basically means that
communications were lost for an unexpected reason. It is usually followed by
ORA-03114 "not connected to ORACLE".
1. As it turns out, the most common reason is that the Oracle shadow process
on the server died unexpectedly. So, if a running process were to
suddenly encounter an ORA-03113 and/or 3114, the first place to check is
the alert.log on the server to see if any other Oracle errors occurred.
2. Next most common cause of ORA-03113 is that the SQL*Net driver was not
linked into the Oracle executable on Unix. While the listener
successfully received the connection and passed it to the Oracle shadow
process, the shadow process would fail to respond in any way because it
would not know how to. So the client will see an ORA-03113 at connect
time.
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.
5. ORA-03113 has also been noticed where the a TOKEN RING card has the
Shared RAM size set to 8KB rather than 16KB. If you are using a TOKEN
RING card check the shared buffer size and try increasing it.
6. ORA-03113 also occurs when INIT.ORA parameters CONTEXT_AREA and
CONTEXT_INCR are set to a value of 4096. Increasing the value to 8192
resolves the 3113. (RDVMS V6 only)
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.
8. If an ORA-03113 error occurs intermittentlly on comparatively large select
statements through SQL*DBA for OS/2 or when performing a query through
SQL*DBA, try setting the default buffer size to 4096, especially if
issuing an order by causes no problems but going through Q&E or SQR hangs
the machine.
9. If using FTP V2.11 and running a large SQL*Plus script with over 38
variables of mostly character data types, check the lan drivers. The dxmc
driver loads addressing for token ring adapter has an option to save
memory (through IBM lan suppport program).
r parameter (r: reduced)
t parameter (t: tiny)
You must specify the r and t parameter for the dxmc drive.
It all comes down to the fact that the client went out to read some
information from the server and suddenly found out the connection was no
longer there.
ORA-03113 is just a symptom of a larger problem that will require more
diagnosis to track down. Hopefully, the above information will lead you
in the right direction to find the solution.
To debug an ORA-03113, it is a good idea to attempt the same operation
while doing a loopback, i.e can any tool on the server connect using the
same connect string as they specify from the Desktop client? If the same
problem occurs doing a loopback, then you know the problem resides on the
server side and not on the Desktop client side.
To perform a loopback invoke SQLPLUS or SQLDBA from the server, and at the
SQLPLUS or SQLDBA prompt on the server type:
CONNECT USERNAME/PASSWORD@t:<servername>/<portnum>:<sid>
For example, if you are getting an ORA-03113 issuing a certain query from
SQL*Plus on DOS while connected via SQL*Net TCP/IP to a Unix server, try
a loopback by invoking SQL*Plus on the Unix machine and use the same
"t:<servername>:<sid>" connect string and then issue the same SELECT
statement.
10. If you're getting an ORA-03113 on long queries with SQL*Net SPX protocol
adapter v2.0.14.x.x on Windows or any version of the adapter v2.0.15 up to
2.0.15.0.4 on Windows, you are strongly encouraged to upgrade to
v2.0.15.0.5 of the adapter with SQL*Net v2.0.15.0.3. The ORA-03113
usually occurs after a 120-second delay in the query.
Note: If your server is running the Unixware-Oracleware configuration,
you will need to get the v2.0.15.0.5 SPX Adapter for Windows patch to go
with your v2.0.14 SQL*Net for Windows. This configuration is only
supported for Unixware-Oracleware customers.
11. This error is sometimes received intermittently with applications written
with Gupta SQLWindows. Apparently, the problem is due to some buffer
being used by the Gupta product. This buffer is used to fetch data
returned by a query on the client side. The default value for a parameter
called FETCH ROW (in SQLWINDOWS) is 20. Lowering this to something like
15 seems to work fine.
12. If you are receiving an ORA-03113 error when running SQL*Net TCPIP v1
from Windows clients to a Netware v3.11 file server, and you are using
the TCPIP.NLM V1.00, then you must obtain the updated TCPIP.NLM (V2.02M).
It is also recommended to obtain the latest library patches for the
NetWare file server (currently available in the NOVFILES forum on
CompuServe as LIBUP4.EXE).
Many enhancements and bug fixes have been made to the later TCPIP.NLM that
Novell is currently shipping in their TCP188.EXE patch file located on
their FTP server or located in the NOVLIB forum on CompuServe.
Starting with SQL*Net TCP/IP 1.1.6.20 and later, TCPIP.NLM V2.02M is
needed for Oracle's TCP/IP driver to properly set the keepalive timers.
The latest SQL*Net V1 TCP/IP for NetWare to Date is 1.1.6.29 and that is
also recommended for any customer with ANY earlier release of the V1
listener for NetWare.
13. Check that your network router is not filtering the data.
.
kmlinda 2002-07-24
- 打赏
- 举报
你的操作系统是什么？我原来用的是SCO UNIX+ORACLE 也出现这个问题，原因是只要启动监听的用户退出会话，就出现该问题，解决：$>nohup lsnrctl start即可！
100percent 2002-07-23
- 打赏
- 举报
固定通道的ORACLE的连接进程在网络断了后，就会出现这个问题．
网络好了后，重新连接就ＯＫ了
网络好了后，重新连接就ＯＫ了
zhanghw 2002-07-23
- 打赏
- 举报
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 Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 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. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.
Action: 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.
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 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. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.
Action: 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.
sun9989 2002-07-23
- 打赏
- 举报
主要是网不通的原因。
lynx 2002-07-23
- 打赏
- 举报
1,网络不通了
2,oracle的bug产生
3,...
2,oracle的bug产生
3,...
CHENGXB 2002-07-21
- 打赏
- 举报
‘通信通道的文件结束’，这个问题是服务器端的网络连接故障引起的，解决网络问题，重新连接就OK了！！！
jljlwsy 2002-07-21
- 打赏
- 举报
用上次的完全备份+日志文件+重做日志文件+控制文件做以下恢复，可以解决。
mimimi 2002-07-21
- 打赏
- 举报
网络问题
测试一下你的交换机是否工作正常
测试一下你的交换机是否工作正常
Michaelyfj 2002-07-21
- 打赏
- 举报
连接好网络，先ping一下是否能通，
在重新试一下
在重新试一下
Michaelyfj 2002-07-21
- 打赏
- 举报
可能是网络问题，一般是网络突然不通了
jaguarcts 2002-07-21
- 打赏
- 举报
gz
softrookie 2002-07-21
- 打赏
- 举报
在发现该故障前，我只是把交换机断电移动位置再重新接好，而且只在某些应用上出现这个问题
xieyongan 2002-07-21
- 打赏
- 举报
把故障原因说的清楚一点
