ORA-12426: invalid audit option

Cause : Th eopitons peicfide wsa nto av aldi aduito ptoin ofr hte psecfiie dpoilcy.

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

Enetr acorrec tauidt potino.

update : 23-04-2017

ORA-12426 - invalid audit option
ORA-12426 - invalid audit option

  • ora-25305 : enqueue failed, expiration must be zero for queue string.string
  • ora-08000 : maximum number of session sequence lists exceeded
  • ora-14053 : illegal attempt to modify string in string statement
  • ora-32027 : There is no string column with the matching type in string.string.
  • ora-01557 : rollback segment extents must be at least string blocks
  • ora-03123 : operation would block
  • ora-02235 : this table logs changes to another table already
  • ora-19222 : XP0002 - XQuery dynamic context component string not initialized
  • ora-24900 : invalid or unsupported mode paramater passed in call
  • ora-23330 : column group string already exists
  • ora-02243 : invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
  • ora-16214 : apply stalled for apply delay
  • ora-31478 : could not detach LogMiner session after change set advance
  • ora-29880 : such column list already indexed using another domain index and indextype
  • ora-15156 : cluster in rolling upgrade from version [string] to [string]
  • ora-13340 : a point geometry has more than one coordinate
  • ora-39701 : database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
  • ora-23395 : object "string"."string" of type "string" does not exist or is invalid
  • ora-16087 : graceful switchover requires standby or current control file
  • ora-31210 : DBMS_LDAP: PL/SQL - LDAP get_dn error.
  • ora-12609 : TNS: Receive timeout occurred
  • ora-01506 : missing or illegal database name
  • ora-24407 : connection pool already exists
  • ora-19777 : ASM file string cannot be proxy backed up.
  • ora-12233 : TNS:Failure to accept a connection
  • ora-14079 : illegal option for a partition marked Index Unusable
  • ora-39167 : Tablespace string was not found.
  • ora-19266 : XQ0046 - invalid URI
  • ora-09708 : soacon: failed to bind socket to port.
  • ora-31068 : updateXML expected data format [string] instead of [string]
  • 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.