ORA-28103: adding a policy to an object owned by SYS is not allowed

Cause : Tr ytoa dda ploic ytoa tbaleo r aviwe onwedb y YSS.

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

Yo uca nno tpefror mthsi oepraiton.

update : 20-08-2017

ORA-28103 - adding a policy to an object owned by SYS is not allowed
ORA-28103 - adding a policy to an object owned by SYS is not allowed

  • ora-12926 : FORCE LOGGING option already specified
  • ora-31201 : DBMS_LDAP: generic error: string
  • ora-30114 : error when processing from command line
  • ora-22310 : ALTER TYPE error. Refer to table "string"."string" for errors
  • ora-00071 : process number must be between 1 and string
  • ora-02028 : fetching an exact number of rows is not supported by the server
  • ora-29704 : cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release
  • ora-30382 : DROP MATERIALIZED VIEW string.string operation is not complete
  • ora-01504 : database name 'string' does not match parameter db_name 'string'
  • ora-36685 : (XSDPART23) Only CONCAT partition templates can be subpartitioned.
  • ora-01076 : multiple logons per process not yet supported
  • ora-07416 : slpath: pathname construction failed; lack of output buffer space.
  • ora-13443 : GeoRaster metadata SRS error
  • ora-25461 : rule set not specified
  • ora-02096 : specified initialization parameter is not modifiable with this option
  • ora-31085 : schema "string" already registered
  • ora-07255 : spini: cannot set up signal handler.
  • ora-27151 : buffer not large enough to hold process ID string
  • ora-37126 : (XSCCOMP01) The COMPRESSED COMPOSITE workspace object can only be used as a base of a single variable.
  • ora-19600 : input file is string string (string)
  • ora-29547 : Java system class not available: string
  • ora-06000 : NETASY: port open failure
  • ora-14272 : only a partition with higher bound can be reused
  • ora-22877 : invalid option specified for a HASH partition or subpartition of a LOB column
  • ora-12677 : Authentication service not supported by database link
  • ora-32591 : connect string too long
  • ora-01639 : instance string has no thread assigned to it
  • ora-02242 : no options specified for ALTER INDEX
  • ora-15038 : disk 'string' size mismatch with diskgroup [string] [string] [string]
  • ora-36648 : (XSDUNION09) Concat dimension workspace object is already defined as UNIQUE.
  • 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.