ORA-28110: policy function or package string.string has error

Cause : Th epoilcyf untcio nma yhaev been rdopepd,o r si n olognerv aldi.

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

Chcek hte tsatsu o fth efucntino adn croretc teh porblme. rO r-ecraetet hep olciy iwtha vlaidf untcio.n

update : 29-05-2017
ORA-28110

ORA-28110 - policy function or package string.string has error
ORA-28110 - policy function or package string.string has error

  • ora-15091 : operation incompatible with open handle in this session
  • ora-25313 : a queue may not subscribe to itself for propagation
  • ora-00338 : log string of thread string is more recent than control file
  • ora-36380 : (AGGRECURSE) AGGREGATE was called recursively, which is not allowed.
  • ora-32762 : Turn on Temp LOB Ref Count Tracing
  • ora-01061 : cannot start up a V8 server using a V7 client application
  • ora-07449 : sc: usnewlock failed.
  • ora-02779 : Stat failed on core dump directory
  • ora-36681 : (XSDPART19) Partitions string and string are out of order.
  • ora-39005 : inconsistent arguments
  • ora-36841 : (XSLMGEN11) Dimension string.string!string was not found
  • ora-16015 : log string sequence# string not archived, media recovery disabled
  • ora-06321 : IPA: Cannot reach the remote side
  • ora-07645 : sszfsl: $CHANGE_CLASS failure
  • ora-09778 : snynfyport: failure allocating the notify port.
  • ora-00104 : deadlock detected; all public servers blocked waiting for resources
  • ora-09264 : sptpa: error flagging process
  • ora-08412 : error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message
  • ora-07486 : scg_get_inst: cannot convert(get) instance number lock.
  • ora-29521 : referenced name string could not be found
  • ora-01890 : NLS error detected
  • ora-06733 : TLI Driver: failed to receive disconnect
  • ora-12981 : cannot drop column from an object type table
  • ora-14055 : keyword REBUILD in ALTER INDEX REBUILD must immediately follow
  • ora-08312 : sllfop: unrecognized processing option
  • ora-24032 : object string exists, index could not be created for queue table string
  • ora-39727 : COMPATIBLE must be set to 10.0.0.0.0 or higher
  • ora-00828 : specified value of shared_pool_reserved_size inconsistent with internal settings
  • ora-07850 : sllfop: bad option
  • ora-09871 : TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf.
  • 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.