ORA-07622: smscre: $CREATE failure

Cause : While creating the system global area (SGA) backing file, VMS system service $CREATE failed.

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

Examine the system error message and refer to VMS documentation.

update : 22-09-2017
ORA-07622

ORA-07622 - smscre: $CREATE failure
ORA-07622 - smscre: $CREATE failure

  • ora-06741 : TLI Driver: unable to open protocol device
  • ora-25961 : join index prevents dml cascade constraint operation
  • ora-22924 : snapshot too old
  • ora-38442 : The ADT "string" is not in a valid state.
  • ora-00477 : SNP* process terminated with error
  • ora-10946 : trace name context forever
  • ora-00489 : ARB* process terminated with error
  • ora-12648 : Encryption or data integrity algorithm list empty
  • ora-12651 : Encryption or data integrity algorithm unacceptable
  • ora-32589 : unable to drop minimal supplemental logging
  • ora-12450 : LOB datatype disabled in LBAC initialization file
  • ora-25129 : cannot modify constraint (string) - no such constraint
  • ora-16201 : Skip procedure requested to apply statement
  • ora-30386 : invalid SQL statement for DECLARE_REWRITE_EQUIVALENCE
  • ora-25275 : Test support for buffered queues
  • ora-12600 : TNS: string open failed
  • ora-36389 : (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.
  • ora-31451 : invalid value string for capture_values, expecting: OLD, NEW, or BOTH
  • ora-24165 : invalid rule engine object privilege: string
  • ora-33270 : (DBERR05) Analytic workspace string already exists.
  • ora-07233 : slemcw: invalid file handle, seals do not match.
  • ora-29252 : collection does not contain elements at index locations in call to dbms_sql.bind_array
  • ora-16781 : the status of redo transport service for a database is unknown
  • ora-24321 : inconsistent parameters passed
  • ora-07256 : sptrap: cannot set up signal handler to catch exceptions.
  • ora-09790 : sllfcf: unable to close file.
  • ora-12543 : TNS:destination host unreachable
  • ora-16258 : marking index unusable due to a constraint violation
  • ora-07231 : slemcc: invalid file handle, seals do not match.
  • ora-13138 : could not determine name of object string
  • 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.