ORA-07502: scgcmn: $enq unexpected return

Cause : VMS system service $ENQ returned an unexpected value

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

Check for system error message and refer to VMS documentation

update : 19-08-2017
ORA-07502

ORA-07502 - scgcmn: $enq unexpected return
ORA-07502 - scgcmn: $enq unexpected return

  • ora-30383 : specified dimension level does not exist in the attribute
  • ora-00329 : archived log begins at change string, need change string
  • ora-14521 : Default tablespace string block size [string] for string string does not match existing string block size [string]
  • ora-27143 : OS system call failure
  • ora-16525 : the Data Guard broker is not yet available
  • ora-07753 : slemcf: fseek before write failure
  • ora-36978 : (XSRELGID01) workspace object must be a self-relation.
  • ora-19559 : error sending device command: string
  • ora-10616 : Operation not allowed on this tablespace
  • ora-27211 : Failed to load Media Management Library
  • ora-30435 : job_queue_processes must be non-zero in order to refresh summaries
  • ora-25246 : listen failed, the address string is an 8.0 style exception queue
  • ora-31102 : Already locked in exclusive mode. Cannot add lock.
  • ora-07412 : sfaslv: Error getting entry in asynchronous write array.
  • ora-12315 : database link type is invalid for the ALTER DATABASE statement
  • ora-02004 : security violation
  • ora-33086 : (XSAGINIT01) AGGMAP workspace object cannot be dimensioned by a conjoint dimension.
  • ora-02791 : Unable to open file for use with asynchronous I/O
  • ora-30159 : OCIFileOpen: Cannot create the file or cannot open in the requested mode
  • ora-02074 : cannot string in a distributed transaction
  • ora-28534 : Heterogeneous Services preprocessing error
  • ora-13432 : GeoRaster metadata blankCellValue error
  • ora-16187 : LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes
  • ora-16640 : CRS warns that multiple instances may still be running
  • ora-16732 : error executing dbms_logstdby.skip procedure
  • ora-38733 : Physical size string less than needed string.
  • ora-36991 : (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.
  • ora-19260 : XQ0040 - invalid namespace node in element constructor
  • ora-14326 : Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause
  • ora-07595 : sppid: $GETJPIW failure
  • 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.