由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - oracle的程序,有人遇到过ora-24550错误代码么?
相关主题
newbie's question about oracle有谁知道产生这两个ORA error的原因?
oracle error ORA-12571【已解决】oracle db link
connect to an oracle server on anoter machineA question about Oracle
How to configure Listener in Oracle?ora-12560: TNS: Protocol adaptor error
Oracle-Client connect to Server Database problemHelp!!!!我的tora为什么连不上oracle呀?
question about ORACLE 10g Express on FedoraOracle problems
Oracle database link problemSql developer connection issue
问一下oracle高手Debugging in SQLPLUS, need help
相关话题的讨论汇总
话题: diag话题: enabled话题: 24550
进入Database版参与讨论
1 (共1页)
N**********d
发帖数: 9292
1
网上搜了一下,好些都是说
Refer to
ORA-24550 Signal Received Error From Client Based Application [ID 1284564.1]
BUG 9342118 : OCISTMTRELEASE CRASHES WITH CORE DUMP WHEN CALLED OUTSIDE A
TRANSACTION
但是这些具体内容是什么,好像都看不到啊。
还有人说创建一个文件:
$TNS_ADMIN/sqlnet.ora
里面放三行
DIAG_ADR_ENABLED=OFF
DIAG_DDE_ENABLED=FALSE
DIAG_SIGHANDLER_ENABLED=FALSE
这个也在客户端加了,然后重启程序,但是还是没效果,程序还是照样崩溃。
先谢谢大家了
c*****d
发帖数: 6045
2
如果确认是bug 9342118,看metalink上的文档
PROBLEM:
--------
Calling OCIStmtRelease() outside a transaction terminates program with core
dump.
You can avoid by either using a tag or by calling OCIStmtRelease() inside an
open transaction. I can't repro with 10.2 client but I can repro with 11.1.
0.7 and 11.2.0.1 client whereas the database versions doesn't have any
impact.
WORKAROUND:
-----------
Either using a tag nor calling OCIStmtRelease() inside an open transaction
can be counted a a valid workaround as they can't be implemented and indeed
opening a transaction to call OCIStmntRelease() is helpfull.
Currently the customer is not using statement caching [ make using tags
useless ] and he can't review its complete code to check whether
OCIStmtRelease() is only called inside an open transaction.
N**********d
发帖数: 9292
3
呃,谢谢了,用的occi,没有直接用到OCIStmtRelease

core
an
1.

【在 c*****d 的大作中提到】
: 如果确认是bug 9342118,看metalink上的文档
: PROBLEM:
: --------
: Calling OCIStmtRelease() outside a transaction terminates program with core
: dump.
: You can avoid by either using a tag or by calling OCIStmtRelease() inside an
: open transaction. I can't repro with 10.2 client but I can repro with 11.1.
: 0.7 and 11.2.0.1 client whereas the database versions doesn't have any
: impact.
: WORKAROUND:

1 (共1页)
进入Database版参与讨论
相关主题
Debugging in SQLPLUS, need helpOracle-Client connect to Server Database problem
oracle求助question about ORACLE 10g Express on Fedora
[转载] help database questionOracle database link problem
SORTING 中文 IN ORACLE问一下oracle高手
newbie's question about oracle有谁知道产生这两个ORA error的原因?
oracle error ORA-12571【已解决】oracle db link
connect to an oracle server on anoter machineA question about Oracle
How to configure Listener in Oracle?ora-12560: TNS: Protocol adaptor error
相关话题的讨论汇总
话题: diag话题: enabled话题: 24550