ORA-28336: cannot encrypt SYS owned objects

Cause : An atetmpt wsa madet o encyrpt coulmns i na tabel owne dby SY.S

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


update : 24-05-2017

ORA-28336 - cannot encrypt SYS owned objects
ORA-28336 - cannot encrypt SYS owned objects

  • ora-26697 : LCR contains extra column 'string'
  • ora-27081 : unable to close the file
  • ora-01619 : thread string is mounted by another instance
  • ora-13843 : no SQL profile with name like "string" exists for category like "string"
  • ora-30685 : package version is not compatible with Oracle version
  • ora-30113 : error when processing file 'string'
  • ora-24160 : name string already exists in the name value pair list
  • ora-06702 : TLI Driver: cannot allocate context area
  • ora-33282 : (DBERR11) Cannot wait for analytic workspace string to become available since doing so would cause a deadlock.
  • ora-15108 : missing or invalid template name
  • ora-12709 : error while loading create database character set
  • ora-38448 : Indexing predicates with "string" operator is not supported.
  • ora-02722 : osnpui: cannot send break message to orapop
  • ora-14130 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-09888 : osnTXtt: txipc channel creation failed
  • ora-14188 : sub-partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-27489 : unable to process job "string.string" from job class "string"
  • ora-26082 : load of overlapping segments on table string.string is not allowed
  • ora-32005 : error while parsing size specification [string]
  • ora-28582 : a direct connection to this agent is not allowed
  • ora-24149 : invalid rule name
  • ora-01466 : unable to read data - table definition has changed
  • ora-12437 : invalid policy option: string
  • ora-13607 : The specified task or object string already exists
  • ora-16542 : unrecognized operation
  • ora-01916 : keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected
  • ora-22912 : specified column or attribute is not a nested table type
  • ora-01456 : may not perform insert/delete/update operation inside a READ ONLY transaction
  • ora-31508 : invalid parameter value for synchronous change set
  • ora-12817 : parallel query option must be enabled
  • 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.