ttc error oracle,ORA-03137:TTC协议内部错误:[3149][][][][]

alertlog:

Completed checkpoint up to RBA [0x54a8.2.10],

SCN: 10242323114492

Wed Sep 17 09:48:17 2014

Incremental checkpoint up to RBA [0x54a8.a0bdc.0], current log tail

at RBA [0x54a8.b9642.0]

Wed Sep 17 09:51:31 2014

opiodr aborting process unknown ospid (3934) as a result of

ORA-609

Wed Sep 17 09:55:37 2014

opiodr aborting process unknown ospid (4960) as a result of

ORA-609

Wed Sep 17 10:01:19 2014

Errors in file

/u01/prod/db/diag/rdbms/prod/PROD1/trace/PROD1_ora_14923.trc (incident=1682868):

ORA-03137: TTC 协议内部错误: [3149] [] [] [] [] [] []

[]

ORA-03149: Oracle 错误代码无效

Incident details in:

/u01/prod/db/diag/rdbms/prod/PROD1/incident/incdir_1682868/PROD1_ora_14923_i1682868.trc

Wed Sep 17 10:01:23 2014

Dumping diagnostic data in directory=[cdmp_20140917100123],

requested by (instance=1, osid=14923),

summary=[incident=1682868].

Wed Sep 17 10:01:24 2014

Sweep [inc][1682868]: completed

Sweep [inc2][1682868]: completed

Wed Sep 17 10:08:23 2014

Incremental checkpoint up to RBA [0x54a8.fe97e.0], current log tail

at RBA [0x54a8.116fd6.0]

Wed Sep 17 10:21:37 2014

opiodr aborting process unknown ospid (13140) as a result of

ORA-609

Wed Sep 17 10:25:26 2014

Beginning log switch checkpoint up to RBA [0x54a9.2.10], SCN:

10242324450353

参考文档：

ORA-3137 [3149] Regularly Reported on R12 EBS

Database (文档 ID 1670276.1) 转到底部

--------------------------------------------------------------------------------

In this Document

Symptoms

Cause

Solution

References

--------------------------------------------------------------------------------

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and

later

Information in this document applies to any platform.

Symptoms

The following error is reported in the alert.log of the database

for an EBS R12 application.

ORA-03137: TTC protocol internal error : [3149] [] [] [] [] []

[] []

ORA-03149: Invalid Oracle error code

The EBS environment has a 10.1.2 (Forms and Reports) client but

can also have a 10.1.3 client.

Cause

This is due to Bug 14489591: ODP/OCI 12.1: PASSTHROUGH OF NULL

FAILS: ORA-01459: INVALID LENGTH FOR CHAR STR, fixed in 11.2.0.4

and 12.1.0.1 clients

Solution

Bug 14489591 is a client fix, so the fix should be applied to the

client application:

Check if the client is 32 or 64-bit to download the correct

version of the patch

This can be done by executing following commands on the 10.1.2

or 10.1.3 ORACLE_HOME:

ls -l $ORACLE_HOME/lib/libclntsh.so.10.1

file libclntsh.so.10.1

ls -l $ORACLE_HOME/bin/sqlplus?file $ORACLE_HOME/bin/sqlplus

1. Apply patch 14489591 on top of the 10.1.0.5

RDBMS client included in 10.1.2/10.1.3 (Forms and Reports) Oracle

Home

The following step is crucial to get the bug fixed. If frmweb is

not relinked, the ORA-3137 will still be reported although patch

14489591 is applied

2. Relink 'frmweb':

a) Bring down the application services

b) $cd $ORACLE_HOME/forms/lib32

$make -f ins_forms.mk installl

c) Bring up the application services

Remark: Instead of bringing down the

application services, you can also execute "adopmnctl.sh

stopall"