ORA-07629: smpall: $EXPREG failure

Cause : While extending the program global area (PGA), VMS system service $EXPREG failed. This often happens when the virtual memory page count quota is exceeded.

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

Examine the system error message and refer to VMS documentation.

update : 28-05-2017
ORA-07629

ORA-07629 - smpall: $EXPREG failure
ORA-07629 - smpall: $EXPREG failure

  • ora-14054 : invalid ALTER TABLE TRUNCATE PARTITION option
  • ora-01213 : MAXINSTANCES may not exceed string
  • ora-14311 : Expecting VALUES LESS THAN or AT clause
  • ora-12541 : TNS:no listener
  • ora-27196 : skgfpbk: sbtpcbackup returned error
  • ora-16539 : task element not found
  • ora-12712 : new character set must be a superset of old character set
  • ora-26049 : Unscoped REF column has non-existent table name.
  • ora-08414 : error encountered in string
  • ora-31412 : change set string is disabled and cannot be advanced
  • ora-13037 : SRIDs do not match for the two geometries
  • ora-24093 : AQ agent string not granted privileges of database user string
  • ora-04940 : unsupported optimization of Oracle binary, check alert log for more info
  • ora-09933 : Deletion of old password file failed.
  • ora-24904 : invalid callback attribute passed into OCI call
  • ora-13332 : invalid LRS point
  • ora-14296 : Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-19017 : Attributes can only be simple scalars
  • ora-09265 : spwat: error temporarily suspending process
  • ora-07393 : unable to delete text file
  • ora-09330 : Session terminated internally by Oracle or by an Oracle DBA
  • ora-12830 : Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE
  • ora-01693 : max # extents (string) reached in lob segment string.string
  • ora-01605 : missing numbers in clause "string" of string
  • ora-02162 : invalid value for MAXDATAFILES
  • ora-26000 : partition load specified but table string is not partitioned
  • ora-07592 : sspgprv: Error obtaining required privileges
  • ora-28271 : No permission to read user entry in LDAP directory service.
  • ora-08191 : Flashback Table operation is not supported on remote tables
  • ora-09982 : skxfqddrg: Error Removing a page from the SDI buffer pool
  • 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.