ORA-28118: policy group already exists

Cause : try to create a policy group that already exists

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


update : 25-06-2017

ORA-28118 - policy group already exists
ORA-28118 - policy group already exists

  • ora-30446 : valid workload queries not found
  • ora-10997 : another startup/shutdown operation of this instance inprogress
  • ora-25198 : only range, list, and hash partitioning are supported for index-organized table
  • ora-36861 : (XSTFRC01) SQL Cache ID parameter is invalid or missing.
  • ora-13266 : error inserting data into table string
  • ora-24087 : Invalid database user string
  • ora-13407 : invalid storage parameter
  • ora-13135 : failed to alter spatial table
  • ora-12024 : materialized view log on "string"."string" does not have primary key columns
  • ora-00721 : changes by release string cannot be used by release string
  • ora-29317 : datafile string does not exist
  • ora-14136 : ALTER TABLE EXCHANGE restricted by fine-grained security
  • ora-23324 : error string, while creating deferror entry at "string" with error string
  • ora-14631 : the partition bounds do not match the subpartition bounds of the partition
  • ora-01725 : USERENV('COMMITSCN') not allowed here
  • ora-39026 : master table is inconsistent on validation string
  • ora-39727 : COMPATIBLE must be set to or higher
  • ora-24344 : success with compilation error
  • ora-19107 : invalid XQueryX - unsupported construct - string
  • ora-16545 : unable to get response
  • ora-12152 : TNS:unable to send break message
  • ora-12674 : Shared server: proxy context not saved
  • ora-23368 : name string cannot be null or the empty string
  • ora-39098 : Worker process received data objects while loading metadata. Invalid process order range is string..string
  • ora-30467 : internal data for filter number string is inconsistent
  • ora-25146 : EXTENT MANAGEMENT option already specified
  • ora-02160 : index-organized table can not contain columns of type LONG
  • ora-27434 : cannot alter chain step job string.string.string
  • ora-31493 : could not prepare session for LogMiner session
  • ora-32163 : Method called on Invalid Environment type
  • 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.