DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, October 5, 2017

ORA-03137: TTC protocol internal error : [3149] [] [] [] [] [] [] [] ORA-03149: Invalid Oracle error code

ERROR:

ORA-03137: TTC protocol internal error : [3149] [] [] [] [] [] [] []
ORA-03149: Invalid Oracle error code


SOLUTION:


The fix for unpublished Bug 14489591 is a client fix, so the fix should be applied to the client as used by the 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. For the client as used by EBS, 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

 
2. Relink 'frmweb':
  a) Bring down the application services (or) We can also execute adopmnctl.sh stopall

  b) $cd $ORACLE_HOME/forms/lib32
      $make -f ins_forms.mk installl

      If the location is not found(-bash: cd: /oracle/PROD/apps/tech_st/10.1.3/forms/lib32: No such file or directory), then try to use below instead or contact the Forms Support team:
       $source $INST_TOP/ora/10.1.3/SID_hostname.env
       $cd $ORACLE_HOME/forms/lib
       $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"
 

No comments: