ORA-28139: Maximum allowed Fine Grain Audit Policies Exceeded

Cause : A maximum of 256 policies can be enabled on an object

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

Drop or disable an existing policy before creating more

update : 28-07-2017

ORA-28139 - Maximum allowed Fine Grain Audit Policies Exceeded
ORA-28139 - Maximum allowed Fine Grain Audit Policies Exceeded

  • ora-14631 : the partition bounds do not match the subpartition bounds of the partition
  • ora-09834 : snyGetPortSet: failed to collect info on a port.
  • ora-22891 : cannot have multiple columns in REF constraint
  • ora-02062 : distributed recovery received DBID string, expected string
  • ora-00356 : inconsistent lengths in change description
  • ora-02877 : smpini: Unable to initialize memory protection
  • ora-00377 : Frequent backups of file string causing write operation to stall
  • ora-00165 : migratable distributed autonomous transaction with remote operation is not allowed
  • ora-19640 : datafile checkpoint is SCN string time string
  • ora-16221 : history table synchronization error
  • ora-12424 : length exceeds binary label size
  • ora-31631 : privileges are required
  • ora-00254 : error in archive control string 'string'
  • ora-07203 : sltln: attempt to translate a long environment variable.
  • ora-07637 : smsdbp: buffer protect option not specified when sga created
  • ora-28137 : Invalid FGA audit Handler
  • ora-00477 : SNP* process terminated with error
  • ora-39159 : cannot call this function from a non-Data Pump process
  • ora-32578 : password for SYS already specified
  • ora-19812 : cannot use string without DB_RECOVERY_FILE_DEST
  • ora-29268 : HTTP client error string
  • ora-30073 : invalid adjustment value
  • ora-31060 : Resource at path string could not be deleted
  • ora-13203 : failed to read USER_SDO_GEOM_METADATA view
  • ora-10572 : Test recovery canceled due to errors
  • ora-00221 : error on write to control file
  • ora-00910 : specified length too long for its datatype
  • ora-09262 : spdde: error terminating detached (background) process
  • ora-16208 : Logical standby dictionary build failed to start.
  • ora-39032 : function string is not supported in string jobs
  • 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.