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"