805的客戶端連不上9i,報錯ORA-03106

[复制链接]
查看11 | 回复6 | 2005-10-30 17:05:33 | 显示全部楼层 |阅读模式
測試連接時:
ORA-03106: fatal two-task communication protocol error
在客戶端TNSPING80可以ping通﹐但是用SQLPlus, IMP80
都會出錯說地址錯﹐整個畫面關閉掉
我改了客戶端的TNSNAMES.ORA﹐嘗試用SID的SERVICES_NAME
去連﹐都一樣
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
在TNSNAMES.ORA文件中
(SID=ORCL)后加(SERVER=DEDICATED)

防火墻有時會影響!
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
没用,
我在oracle 7.2.3连接oracle 8i 中出现同样的问题,到现在还没有解决。
我找的资料如下说:
ORA-03106
========
Possible reasons for the ORA-03106 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 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 receiving the ORA-03106 error.
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
ORA-03106
========
Possible reasons for the ORA-03106 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 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 receiving the ORA-03106 error.
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
但是我按照上面的说法做了以后我还是没有成功
不知道这里有人没有人能解决
我看这里都是高级会员,但是能彻底解决的问题的真不多。
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
好象不行
沒有防火強
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
it seems like init parameter compatible problem....


回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
So far as I know ,since 8.1.6 or 8.1.7 Oracleno long supportsid = orcl,you have to use service_name= xxx.Ithink youhave to lookmoreon Oraclesupport.. Do not waste time if you can upgrade database.
回复

使用道具 举报

千问 | 2005-10-30 17:05:33 | 显示全部楼层
817支持sid=orcl,可能是客户端的版本低和服务器的版本不兼容。
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行