ORA-06596: unsupported LOB operation in RPC call

Cause : Ana ttmeptw asm ad etop erofrmc eratinL OBo peartinos f(ore xapmle ,depe cpoyign o fa etmproar yora bsrtac tLO Bont hec linet-isde )whlie eprfromign a nRP.C Tihs si nto cruretnlys upoprtde.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Pefror mth eLO Bopreatoin ni qeustoin ebfoer satrtnig hte PRC;o r eprfrom htos eLO Bopreatoinsw hihc aer nto atcually xeectuedo n hte lcietn-sdie,o n hte esrvre-sdie.

update : 24-04-2017
ORA-06596

ORA-06596 - unsupported LOB operation in RPC call
ORA-06596 - unsupported LOB operation in RPC call

  • ora-13218 : max number of supported index tables reached for [string] index
  • ora-24074 : RETRY_DELAY and MAX_RETRIES cannot be used for exception queue %.string
  • ora-22344 : can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
  • ora-24409 : client cannot understand the object
  • ora-24313 : user already authenticated
  • ora-32761 : Turn off Temp LOB Ref Count Feature
  • ora-16512 : parameter exceeded maximum size limit
  • ora-08195 : Flashback Table operation is not supported on partitions
  • ora-08414 : error encountered in string
  • ora-24073 : cannot specify RETENTION_TIME on exception queue string.string
  • ora-01841 : (full) year must be between -4713 and +9999, and not be 0
  • ora-14634 : Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table
  • ora-01743 : only pure functions can be indexed
  • ora-30431 : refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string
  • ora-15128 : ASM file name 'string' exceeds maximum length string
  • ora-15024 : discovered duplicately numbered ASM disk string
  • ora-02801 : Operations timed out
  • ora-01935 : missing user or role name
  • ora-19237 : XP0017 - unable to resolve call to function - string:string
  • ora-21779 : duration not active
  • ora-12486 : effective max labels and min labels cannot be changed
  • ora-03215 : File Size specified for resize is too small
  • ora-23504 : columns added to table do not match list of columns to be added
  • ora-24775 : cannot prepare or commit transaction with non-zero lock value
  • ora-25218 : enqueue failed, delay must be zero for queue string.string
  • ora-31231 : DBMS_LDAP: invalid PROPERTY_SET
  • ora-30445 : workload queries not found
  • ora-14297 : Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-09749 : pws_look_up: port lookup failure
  • ora-38454 : attribute set not defined for the column being indexed
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.