ORA-19620: %s is not of string type

Cause : When opening the file to be placed in a copy or backup set, to be inspected, or used as the target for an incremental restore, its header was not recognized as a valid file header for a file of the indicated type (data file, archived log, or control file) belonging to the current database.

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

The indicated file cannot be processed. Ensure that the correct files are being specified for the copy or backup operation.

update : 28-04-2017

ORA-19620 - %s is not of string type
ORA-19620 - %s is not of string type

  • ora-06113 : NETTCP: Too many connections
  • ora-21613 : key does not exist
  • ora-24197 : JAVA stored procedure throws JAVA exceptions
  • ora-09340 : Specified ORACLE_SID is either invalid or too long
  • ora-32612 : invalid use of FOR loop
  • ora-12834 : Instance group name, 'string', too long, must be less than string characters
  • ora-37145 : (XSTTS_PLAT) Cannot transport analytic workspace across platforms.
  • ora-12990 : duplicate option specified
  • ora-01675 : max_commit_propagation_delay inconsistent with other instances
  • ora-07261 : spdde: kill error, unable to send signal to process.
  • ora-39147 : cannot migrate Data Pump queue table ownership to this instance
  • ora-29309 : export dump file was generated by different version of DBMS_PITR package
  • ora-07472 : snclrd: open error when opening sgadef.dbf file.
  • ora-09960 : Unable to establish signal handler for termination signal
  • ora-39099 : cannot create index for "string" on master table string
  • ora-19372 : invalid update condition
  • ora-10646 : Too many recursive extensions during SYSTEM tablespace migration
  • ora-07580 : spstp: $GETJPIW failure
  • ora-25237 : navigation option used out of sequence
  • ora-06908 : CMX: error during transfer of ORACLE_SID
  • ora-01279 : db_files too large
  • ora-28655 : Alter table add overflow syntax error
  • ora-40289 : duplicate attributes provided for data mining function
  • ora-39951 : incomplete values specified for PL/SQL warning settings
  • ora-13036 : Operation [string] not supported for Point Data
  • ora-24312 : illegal parameters specified for allocating user memory
  • ora-01683 : unable to extend index string.string partition string by string in tablespace string
  • ora-38712 : Corrupt flashback log record header: block string, offset string.
  • ora-02368 : file string is not valid for this load operation
  • ora-30689 : improper value for ORA_DEBUG_JDWP
  • 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.