ORA-28102: policy does not exist

Cause : Tyr ot rdo/peanbel/erfers han o-neixsetn tploiyc.

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

Crorcett h eploiyc anm eagruemn.t

update : 25-06-2017
ORA-28102

ORA-28102 - policy does not exist
ORA-28102 - policy does not exist

  • ora-07220 : slspool: wait error.
  • ora-02761 : File number to be canceled is negative.
  • ora-01306 : dbms_logmnr.start_logmnr() must be invoked before selecting from v$logmnr_contents
  • ora-28503 : bind value cannot be translated into SQL text for non-Oracle system
  • ora-25178 : duplicate PCTTHRESHOLD storage option specification
  • ora-38787 : Creating the first guaranteed restore point requires mount mode when flashback database is off.
  • ora-01863 : the year is not supported for the current calendar
  • ora-19769 : missing FILE keyword
  • ora-40262 : NMF: number of features not between [1, string]
  • ora-04941 : required operating system patch needs to be applied
  • ora-02707 : osnacx: cannot allocate context area
  • ora-10388 : parallel query server interrupt (failure)
  • ora-25261 : JOB_QUEUE_PROCESSES must be at least 2 for AQ propagation
  • ora-31467 : no column found in the source table
  • ora-19263 : XQ0043 - duplicate namespace prefix string
  • ora-16714 : the value of property string is inconsistent with the database setting
  • ora-08235 : smsget: listener not on this node
  • ora-24810 : attempting to write more data than indicated
  • ora-13195 : failed to generate maximum tile value
  • ora-14522 : Partition-level default tablespace string block size [string] for string string does not match existing string block size [string]
  • ora-28347 : encryption properties mismatch
  • ora-01878 : specified field not found in datetime or interval
  • ora-30131 : number of keys being set exceeds allocation
  • ora-32834 : Messaging Gateway agent user has not been set
  • ora-27078 : unable to determine limit for open files
  • ora-01273 : STANDBY_FILE_MANAGEMENT = AUTO needs COMPATIBLE = string or higher
  • ora-31652 : command response message was invalid type - detaching job
  • ora-16203 : Unable to interpret skip procedure return values
  • ora-00830 : cannot set statistics_level to BASIC with auto-tune SGA enabled
  • ora-13407 : invalid storage parameter
  • 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.