ORA-19730: can not convert offline plugged-in datafile string

Cause : sAp ra tfom kani g aatlbseapecr ae-drwti,ew eendet oocvnre tadatifel shttaa erp ulggdei nerdao-ln.yT ehf li eumtsb enoilen.

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

nOilent ehd tafali ena derrt yht eporetaoi.n

update : 24-08-2017
ORA-19730

ORA-19730 - can not convert offline plugged-in datafile string
ORA-19730 - can not convert offline plugged-in datafile string

  • ora-29314 : tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY
  • ora-06902 : CMX: cannot attach to cmx subsystem
  • ora-32839 : property string is reserved, names with MGWPROP$_ prefix are not valid
  • ora-13843 : no SQL profile with name like "string" exists for category like "string"
  • ora-37177 : column string does not have any leaf values
  • ora-12658 : ANO service required but TNS version is incompatible
  • ora-16577 : corruption detected in Data Guard configuration file
  • ora-29545 : badly formed class: string
  • ora-07551 : sftcls: $CLOSE failure
  • ora-29395 : cannot set the initial consumer group to string
  • ora-01876 : year must be at least -4713
  • ora-02263 : need to specify the datatype for this column
  • ora-02424 : potential circular view references or unknown referenced tables
  • ora-02826 : Illegal block size
  • ora-14103 : LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE
  • ora-14188 : sub-partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-25312 : Cannot specify nonzero sender protocol
  • ora-01527 : error while reading file
  • ora-02353 : files not from the same unload operation
  • ora-06751 : TLI Driver: bound addresses unequal
  • ora-09311 : slsleep: error temporarily suspending process
  • ora-29860 : cannot truncate a table with domain indexes marked LOADING
  • ora-16804 : one or more configuration properties in metadata have invalid values
  • ora-13351 : two or more rings of a complex polygon overlap
  • ora-24365 : error in character conversion
  • ora-00304 : requested INSTANCE_NUMBER is busy
  • ora-16004 : backup database requires recovery
  • ora-34344 : (MXDSS03) Analytic workspace string is not attached.
  • ora-08278 : Cannot get CPU statistics
  • ora-06610 : LU6.2 Driver: Failed during deallocation
  • 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.