Trace file interpretation

  • From: Upendra nerilla <nupendra@xxxxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 8 Jul 2015 19:57:30 -0400

Hello Team -
Environment: Oracle 11.2 RAC, OEL 5
I see a trace file containing OA-12704 error.

<snip>
*** MODULE NAME:(Sample Utils) 2015-07-02 xx.xx.xx.xx
*** ACTION NAME:(Saving Data..) 2015-07-02 xx.xx.xx.xx
ORA-12704(1): dty=112 typ=1 flg=00220000 xfl=00040000 bfl=4000 bfc=0 csfm=1
csid=31
ORA-12704(2): dty=112 typ=2 flg=00020000 xfl=00000000 bfl=4000 bfc=0 csfm=2
csid=2000 op=169 opc=5
ORA-12704(2): dty=0 typ=7 flg=00020000 xfl=00000000 bfl=5
ORA-12704(2): dty=2 typ=3 flg=00020081 xfl=00000000 bfl=22 pre=0 sca=0 bpr=0
styp=1
ORA-12704(2): dty=2 typ=3 flg=00020081 xfl=00000000 bfl=22 pre=0 sca=0 bpr=0
styp=1
ORA-12704(2): dty=2 typ=1 flg=00020000 xfl=00000000 bfl=22 pre=0 sca=-127
bpr=0
ORA-12704(2): dty=2 typ=3 flg=00020081 xfl=00000000 bfl=22 pre=0 sca=0 bpr=0
styp=1
<snip>

I got the application module/action info from the above. Any thoughts on how I
would decode the rest of the data?

Thanks a bunch
-Upendra

Other related posts:

  • » Trace file interpretation - Upendra nerilla