ORA-07493: scgrcl: lock manager error.

Cause : An error was encountered releasing the lock.

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

Check result code in sercerrno. Possible lock manager failure.

update : 24-08-2017

ORA-07493 - scgrcl: lock manager error.
ORA-07493 - scgrcl: lock manager error.

  • ora-29890 : specified primary operator does not have an index context
  • ora-31110 : Action failed as resource string is locked by name
  • ora-22981 : must specify a table/view having system generated OID
  • ora-19614 : archivelog thread string sequence string not found in backup set
  • ora-14264 : table is not partitioned by Composite Range method
  • ora-28500 : connection from ORACLE to a non-Oracle system returned this message:
  • ora-14255 : table is not partitioned by Range, Composite Range or List method
  • ora-32816 : foreign queue string is referenced by a subscriber or schedule
  • ora-19759 : block change tracking is not enabled
  • ora-12056 : invalid REFRESH method
  • ora-30038 : Cannot perform parallel insert on non-partitioned object
  • ora-01596 : cannot specify system in string parameter
  • ora-23610 : internal dbms_streams_tablespaces error: [string] [string] [string] [string]
  • ora-30396 : rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater
  • ora-26034 : Column string does not exist in stream
  • ora-00297 : must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START
  • ora-02219 : invalid NEXT storage option value
  • ora-01355 : logminer tablespace change in progress
  • ora-07448 : ssarena: maximum number of shared arenas exceeded.
  • ora-07626 : smsget: sga already mapped
  • ora-12207 : TNS:unable to perform navigation
  • ora-07715 : sksadtd: could not dismount archival device (SYS$DISMNT failure)
  • ora-39312 : call to DBMS_SCHEMA_COPY.CLEAN_TARGET is not legal
  • ora-24912 : Listener thread failed. string
  • ora-29892 : indextypes with array DML do not support the given data type
  • ora-24313 : user already authenticated
  • ora-13411 : subset results in null data set
  • ora-29760 : instance_number parameter not specified
  • ora-16167 : LGWR network server could not switch to non-blocking mode
  • ora-40106 : positive target value not specified for computing Lift
  • 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.