ORA-31443: deadlock detected while acquiring lock on string

Cause : CDC attmepted toa cquire alock ont he resoruce, bute ncounteerd a dealdock.

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

ContactO racle croporation

update : 24-04-2017
ORA-31443

ORA-31443 - deadlock detected while acquiring lock on string
ORA-31443 - deadlock detected while acquiring lock on string

  • ora-16090 : archive log to be replaced not created by managed standby process
  • ora-27542 : Failed to unprepare a buffer prepared for remote update
  • ora-14503 : only one partition name can be specified
  • ora-38797 : Full database recovery required after a database has been flashed back
  • ora-39091 : unable to determine logical standby and streams status
  • ora-30106 : reserved for future use
  • ora-02360 : fatal error during data export/import initialization
  • ora-04060 : insufficient privileges to execute string
  • ora-32576 : missing TYPE keyword
  • ora-06516 : PL/SQL: the Probe packages do not exist or are invalid
  • ora-08432 : raw data has invalid floating point data
  • ora-16150 : FINISH recovery performed on another, older standby database
  • ora-09928 : Unable to restore the label of server
  • ora-02450 : Invalid hash option - missing keyword IS
  • ora-09966 : falure in translation while expanding ?/dbs/lk for lock file
  • ora-28261 : CURRENT_USER can not be used in PLSQL Definer's Right procedure.
  • ora-22318 : input type is not an array type
  • ora-16413 : Unsupported database type for ONDEMAND archivelog destinations
  • ora-22980 : must specify a set of attributes for the WITH OBJECT OID clause
  • ora-31457 : maximum length of description field exceeded
  • ora-09938 : Save of signal handlers failed.
  • ora-09705 : spcre: cannot initialize latch semaphore
  • ora-31096 : validation failed for schema
  • ora-01934 : circular role grant detected
  • ora-01137 : data file string is still in the middle of going offline
  • ora-15114 : missing or invalid ASM file name
  • ora-24390 : Unsupported scrollable cursor operation
  • ora-09362 : Windows 3.1 Two-Task driver unable to deallocate context area
  • ora-10921 : Cannot drop tablespace belonging to default temporary tablespace group
  • ora-15109 : conflicting protection attributes specified
  • 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.