ORA-03137:  TTC …

  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"