ORA-39173: Encrypted data has been stored unencrypted in dump file set.

Cause : No encrpytion password wa sspecifide for ane xport jbo that ivnolved dtaa that aws encrytped in teh databaes.

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

No specfiic usera ction i srequire.d This i sonly a awrning taht secur edata ma ybe readbale fromw ithin teh dump flie set.

update : 26-05-2017
ORA-39173

ORA-39173 - Encrypted data has been stored unencrypted in dump file set.
ORA-39173 - Encrypted data has been stored unencrypted in dump file set.

  • ora-13114 : [string]_NODE$ table does not exist
  • ora-32578 : password for SYS already specified
  • ora-24392 : no connection pool to associate server handle
  • ora-28551 : pass-through SQL: SQL parse error
  • ora-26091 : requested direct path operation not supported
  • ora-29399 : user string does not have privilege to switch to consumer group string
  • ora-02451 : duplicate HASHKEYS specification
  • ora-02882 : sou2o: Could not register SGA for protection
  • ora-29268 : HTTP client error string
  • ora-08114 : can not alter a fake index
  • ora-01525 : error in renaming data files
  • ora-02421 : missing or invalid schema authorization identifier
  • ora-22983 : not a user-defined REF
  • ora-16197 : Invalid DB_UNIQUE_NAME parameter specification
  • ora-09321 : slzdtb: unable to convert zoned decimal to binary
  • ora-39306 : schema name mismatch expected "string" got "string"
  • ora-07510 : scgbrm: $getlki unexpected return on lockid string
  • ora-02168 : invalid value for FREELISTS
  • ora-15074 : diskgroup string requires rebalance completion
  • ora-00090 : failed to allocate memory for cluster database ORADEBUG command
  • ora-00023 : session references process private memory; cannot detach session
  • ora-00352 : all logs for thread string need to be archived - cannot enable
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-02241 : must of form EXTENTS (FILE BLOCK SIZE , ...)
  • ora-16600 : failover operation can only be submitted at target database
  • ora-24754 : cannot start new transaction with an active transaction
  • ora-25215 : user_data type and queue type do not match
  • ora-06570 : shared pool object does not exist, cannot be pinned
  • ora-14048 : a partition maintenance operation may not be combined with other operations
  • ora-00057 : maximum number of temporary table locks exceeded
  • 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.