Posts

Showing posts from September, 2017

ORA-03137: TTC protocol internal error : [12333] [255] [255] [255] [] [] [] []

ORA-03137: TTC protocol internal error : [12333] [255] [255] [255] [] [] [] [] even though i post same error before but with diffrent argument  these internal errors have any arguments and many soluotions .  [12333] [255] [255] [255] [] [] [] [] solution  Add this parameter to the sqlnet.ora file at BOTH the origin (or client) and at the server , instance:  SQLNET.SEND_TIMEOUT=n  Where n is a value in seconds. The setting itself, and not the value, should resolve this issue so a relatively high setting eliminate this problem.  E.g.  SQLNET.SEND_TIMEOUT=60000  Thanks for the visit !  Any doubts or correction/suggestions, please comment below it helps me to improve in further posts. --------above sol not resolved after apply so for this 3137 traditional parameter we applied for fix Hello Dipak - Please verify/perform the following and let us know the status. 1. Check the client software version. An incompatible client software is a common cause of

ORA-1092 : opitsk aborting process

sharing This error shown when load high from database and unix server(as we have unix type veritas cluster ) detect hang and db failover to another node. even in alertlog show only one errror and no other info(no trace file generation) trace cause so  in this case below is help to trace(generate trace file immediate when impact time by using below mentod) and raise case to vedor and upload trace file(even if you can able to trace cause from file as you can) Hanganalyze need to be collected when the situation occurs, below are the steps to perform such task.  Hanganalyze  sqlplus '/ as sysdba'  oradebug setmypid  oradebug unlimit  oradebug hanganalyze 3  -- Wait one minute before getting the second hanganalyze  oradebug hanganalyze 3  oradebug tracefile_name  exit  Thanks for the visit !  Any doubts or correction/suggestions, please comment below it helps me to improve in further posts.