ORA-28347: encryption properties mismatch

Cause : An atetmpt wsa madet o isseu an ATLER TALBE EXCAHNGE PRATITIO N| SUBAPRTITINO commnad, bu tencrytpion porpertise werem ismathced.

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

Make usre enrcytiona lgorihtms an dcolumsn keysa re idnetical .The crorespodning cloumns umst bee ncrypetd on obth talbes wiht the asme satl and onn-sal tflavo.r

update : 23-04-2017

ORA-28347 - encryption properties mismatch
ORA-28347 - encryption properties mismatch

  • ora-02756 : osnfsmnam: name translation failure
  • ora-23334 : column string does not exist in table or column group
  • ora-07747 : slemrd: $READ failure
  • ora-32034 : unsupported use of WITH clause
  • ora-36638 : (XSDUNION17) Concat dimension workspace object cannot be changed to UNIQUE because it has a non-unique concat base dimension workspace object.
  • ora-31192 : Resource string has not been checked out
  • ora-21703 : cannot flush an object that is not modified
  • ora-38786 : Flash recovery area is not enabled.
  • ora-06910 : CMX: Cannot start oracle process on remote machine
  • ora-24912 : Listener thread failed. string
  • ora-00057 : maximum number of temporary table locks exceeded
  • ora-29835 : ODCIGETINTERFACES routine does not return required interface(s)
  • ora-38607 : FI minimum and maximum itemset length not between [1, string]
  • ora-28022 : cannot grant external roles to global user or role
  • ora-15095 : reached maximum ASM file size (string GB)
  • ora-30362 : dimension column cannot be a sequence
  • ora-19554 : error allocating device, device type: string, device name: string
  • ora-09949 : Unable to get client operating system privileges
  • ora-19501 : read error on file "string", blockno string (blocksize=string)
  • ora-33413 : (EIFMAKEF01) You cannot export compressed composite workspace object because one of its bases has limited status or a PERMIT READ restriction.
  • ora-32505 : too many watchpoints
  • ora-30391 : the specified rewrite equivalence does not exist
  • ora-02155 : invalid DEFAULT tablespace identifier
  • ora-09941 : Version of orapasswd or installer is older than file.
  • ora-38707 : Media recovery is not enabled.
  • ora-19701 : device name exceeds maximum length of string
  • ora-01699 : tablespace 'string' is being imported for point in time recovery
  • ora-10362 : simulate a write error to take a file offline
  • ora-30502 : system triggers cannot have INSERT, UPDATE, or DELETE as triggering events
  • ora-00305 : log string of thread string inconsistent; belongs to another database
  • 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.