ORA-03106: fatal two-task communication protocol error

最近遇到这个问题,还没解决,先拷贝下来慢慢研究


使用sqlplus可以连接到数据库,但是使用odbc驱动的c程序连接数据库时报出下面的错误。
ORA-03106: fatal two-task communication protocol error

google了一下,发现在 Oracle otn 上搜索这个错误,一堆,但是没有找到具体的解决方案。

另外,还找到了一个链接:http://www.fors.com/velpuri2/ERRORS/TWO-TASK%20COMMON%20ERRORS,大家知道怎么解决吗?谢谢。

PS:只有这点分了,无怪。

ORA-3106
========

Possible reasons for the ORA-3106 errors include:

1. Incompatibilities between the client application and the RDBMS server. For
example, version incompatibilities or a client trying to use a feature not
supported by the database kernel.

2. When using database links or gateways.

3. Network or SQL*Net problems.

4. Corruptions.

5. PL/SQL - language related.


RDBMS - Troubleshooting two-task common errors
==============================================

1. Check for NLS incompatibilities between the client and the server. This is
a very popular cause of the ORA-03106 error.

2. Check the Alert log and RDBMS trace files for any pertinent information /
errors that coincide with getting the ORA-03106.

3. Try to get a testcase and reproduce the problem in-house.

4. If a testcase is not possible, ask for SQL*Net trace files, SQL traces, and
try setting event 3106 to obtain the error stack.

5. In extreme circumstances, this could indicate that a shared memory segment
used by Oracle is corrupted. You will have to shut down the database,
possibly using the abort option. Make sure all semaphores have been
released by using the IPCS command on Unix. Oracle uses semaphores to
control concurrency between all of the background processes (pmon, smon,
drwr, lgwr, and oracle shadow processes). Semaphores are also used to
control Two-Task communication between the user process and the shadow
process.

6. Try and narrow down the code that may be causing it. For example, it might
have started to happen after increasing the number of parameters in a PL/SQL
block or when using certain values for bind variables, etc.

7. If we still do not make headway, file a bug under RDBMS, but we still may
need some or all of the above information as indicated above.
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值