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 : 26-04-2017

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

  • ora-13420 : the SRID of the geometry parameter was not null
  • ora-28263 : Insufficient memory in global context pool
  • ora-27089 : unable to release advisory lock
  • ora-19628 : invalid SCN range
  • ora-36863 : (XSTFRC03) The OLAPRC_TABLE function encountered an error while parsing the COLUMNMAP.
  • ora-23404 : refresh group "string"."string" does not exist
  • ora-01081 : cannot start already-running ORACLE - shut it down first
  • ora-13129 : HHCODE column string not found
  • ora-19111 : error during evaluation of the XQuery expression
  • ora-00075 : process "string" not found in this instance
  • ora-04093 : references to columns of type LONG are not allowed in triggers
  • ora-01319 : Invalid Logminer session attribute
  • ora-14626 : values being added already exist in DEFAULT subpartition
  • ora-25129 : cannot modify constraint (string) - no such constraint
  • ora-30027 : Undo quota violation - failed to get string (bytes)
  • ora-16957 : SQL Analyze time limit interrupt
  • ora-06027 : NETASY: channel close failure
  • ora-19620 : %s is not of string type
  • ora-29892 : indextypes with array DML do not support the given data type
  • ora-02835 : Server unable to send signal to client
  • ora-16237 : SGA specified for Logical Standby is too small
  • ora-19110 : unsupported XQuery expression
  • ora-16210 : Logical standby coordinator process terminated with error
  • ora-16784 : the database name in Dependency property is incorrect
  • ora-06112 : NETTCP: invalid buffer size
  • ora-10642 : Found rollback segments in dictionary managed tablespaces
  • ora-24132 : table name string is too long
  • ora-02831 : Segment deallocation failed - empty segment list
  • ora-09932 : Close of ORACLE password file failed.
  • ora-13639 : The current operation was interrupted because it timed out.
  • 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.