ORA-19831: incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required

Cause : Thsi vresino o fdaatbaes wsa icnomaptilbe iwtht het hei ndciatde dmbs_abckpu_rsetoer pcakaeg isntalledi n hte adtaabse.

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

Ift hed atbaas eha sbene ugpraedd rfoma n aerleir evrsoin,e nsrue htatt hec atxxxxs.qls crpit ahs ebenr uns ucecssufll.y R-eintsal ldbsmbksr.slq adn pvrtbrks.lpb fi nceesasry.

update : 25-06-2017
ORA-19831

ORA-19831 - incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required
ORA-19831 - incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required

  • ora-27028 : skgfqcre: sbtbackup returned error
  • ora-24079 : invalid name string, names with AQ$_ prefix are not valid for string
  • ora-38474 : attribute set may not have attributes of TABLE COLLECTION type.
  • ora-01213 : MAXINSTANCES may not exceed string
  • ora-06921 : CMX: getdatmsg illegal datatype
  • ora-01618 : redo thread string is not enabled - cannot mount
  • ora-32734 : Error occurred when sending Oradebug command to remote DIAGs
  • ora-14633 : Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table
  • ora-08277 : Cannot set environment variable
  • ora-06916 : CMX: error in data read (t_datain)
  • ora-31686 : error creating worker processes
  • ora-23407 : object name string must be shaped like "schema"."object" or "object"
  • ora-25954 : missing primary key or unique constraint on dimension
  • ora-14021 : MAXVALUE must be specified for all columns
  • ora-08310 : sllfop: Bad value for recsize
  • ora-24276 : function 'string' output 'string' maximum value exceeded
  • ora-01502 : index 'string.string' or partition of such index is in unusable state
  • ora-25330 : PL/SQL associative arrays may not be used with AQ array operations
  • ora-15190 : Internal ASM testing event number 15190
  • ora-28117 : integrity constraint violated - parent record not found
  • ora-13370 : failure in applying 3D LRS functions
  • ora-13266 : error inserting data into table string
  • ora-23419 : regenerate replication support before resuming master activity
  • ora-09884 : Two Task interface: SID doens't match current PU
  • ora-00151 : invalid transaction ID
  • ora-13127 : failed to generate target partition
  • ora-28339 : missing or invalid encryption algorithm
  • ora-33427 : (EIFMAKEF16) CAUTION: NTEXT object workspace object will be exported with type TEXT.
  • ora-01871 : the number of seconds must be less than 60
  • ora-06533 : Subscript beyond count
  • 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.