ORA-12447: policy role already exists for policy string

Cause : Teh orl enmae dDAB laraed yeixsst.

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

Crorcett h eploiyc anm eo rdleeet htee xsitnigp oilc.y

update : 26-04-2017

ORA-12447 - policy role already exists for policy string
ORA-12447 - policy role already exists for policy string

  • ora-14039 : partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-31215 : DBMS_LDAP: PL/SQL - Invalid LDAP mod value.
  • ora-07479 : scgcmn: cannot open or convert lock.
  • ora-36986 : (XSRELGID05) Relation workspace object must be dimensioned by workspace object.
  • ora-12445 : cannot change HIDDEN property of column
  • ora-32602 : FREEPOOLS and FREELIST GROUPS cannot be used together
  • ora-19906 : recovery target incarnation changed during recovery
  • ora-06601 : LU6.2 Driver: Invalid database ID string
  • ora-19026 : EXTRACTVALUE can only retrieve value of leaf node
  • ora-29972 : user does not have privilege to change/ create registration
  • ora-26079 : file "string" is not part of table string.string
  • ora-01535 : rollback segment 'string' already exists
  • ora-36652 : (XSDUNION11) workspace object is not a string type dimension.
  • ora-01271 : Unable to create new file name for file string
  • ora-06035 : NETDNT: connect failed, insufficient resources
  • ora-09837 : addCallback: could not add allocate a callback link.
  • ora-08343 : srclose: failed to close a redo server connection
  • ora-10636 : ROW MOVEMENT is not enabled
  • ora-27471 : window "string.string" is already closed
  • ora-37176 : argument string is not valid for the sparsity advisor
  • ora-31015 : Attempted to insert entry without name
  • ora-02333 : cannot create constraints on attributes of this column
  • ora-31448 : invalid value for change_source
  • ora-25449 : invalid variable name: string
  • ora-30573 : AUTO segment space management not valid for this type of tablespace
  • ora-23445 : missing template site
  • ora-22324 : altered type has compilation errors
  • ora-31616 : unable to write to dump file "string"
  • ora-01158 : database string already mounted
  • ora-03291 : Invalid truncate option - missing STORAGE keyword
  • 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.