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-05-2017

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

  • ora-16816 : incorrect database role
  • ora-28267 : Invalid NameSpace Value
  • ora-01657 : invalid SHRINK option value
  • ora-03298 : cannot shrink datafile - file string is under hot backup
  • ora-30361 : unrecognized string type
  • ora-16099 : internal error ORA-00600 occurred at standby database
  • ora-08004 : sequence string.NEXTVAL string stringVALUE and cannot be instantiated
  • ora-01873 : the leading precision of the interval is too small
  • ora-31480 : staging database and source database cannot be the same
  • ora-02753 : osnfsmmap: cannot close shared memory file
  • ora-08007 : Further changes to this block by this transaction not allowed
  • ora-19619 : cannot call restoreValidate after files have been named
  • ora-38779 : cannot create restore point - too many restore points.
  • ora-28030 : Server encountered problems accessing LDAP directory service
  • ora-40209 : setting % is invalid for % function
  • ora-12900 : must specify a default temporary tablespace for a locally managed database
  • ora-28116 : insufficient privileges to do direct path access
  • ora-30458 : 'string.string' cannot be refreshed because the refresh mask is string
  • ora-09883 : Two Task interface: oratab file does not exist
  • ora-22871 : ALTER TYPE with REPLACE is not allowed for pure incomplete types
  • ora-06138 : NETTCP: error during connection handshake
  • ora-01513 : invalid current time returned by operating system
  • ora-10700 : Alter access violation exception handler
  • ora-37038 : (XSMLTDCL04) You cannot change definitions of objects in analytic workspace string because it is attached in MULTI mode.
  • ora-12494 : cannot insert or delete a level, category, or release category
  • ora-24332 : invalid object type
  • ora-24364 : internal error while padding blanks
  • ora-25181 : missing ON keyword for NESTED INDEX
  • ora-19567 : cannot shrink file string because it is being backed up or copied
  • ora-23434 : master site string not known for object group
  • 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.