ORA-09925: Unable to create audit trail file

Cause : ORACLEw as nota ble toc reate hte fileb eing uesd to hlod audi ttrail ercords.

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

Check hte UNIXe rror nmuber fo ra possbile opearting ssytem erorr. If htere isn o erro,r contatc ORACL Ecustomre suppotr.

update : 23-07-2017

ORA-09925 - Unable to create audit trail file
ORA-09925 - Unable to create audit trail file

  • ora-00022 : invalid session ID; access denied
  • ora-40281 : invalid model name
  • ora-16101 : a valid start SCN could not be found
  • ora-36722 : (XSALLOC02) In AGGMAP workspace object, you specified an NA or ZERO sourceval but supplied formula workspace object as your source for ALLOCATE.
  • ora-19637 : backupPieceCreate requires file name when using DISK device
  • ora-24049 : invalid agent name string, names with AQ$_ prefix are not valid
  • ora-13838 : invalid ADDRESS value
  • ora-06731 : TLI Driver: cannot alloc t_call
  • ora-03134 : Connections to this server version are no longer supported.
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-22167 : given trim size [string] must be less than or equal to [string]
  • ora-32117 : Source LOB is null
  • ora-07406 : slbtpd: invalid number.
  • ora-02465 : Inappropriate use of the HASH IS option
  • ora-12660 : Encryption or crypto-checksumming parameters incompatible
  • ora-01621 : cannot rename member of current log if database is open
  • ora-31675 : worker process interrupt for unexpected death of master process
  • ora-02075 : another instance changed state of transaction string
  • ora-29862 : cannot specify FORCE option for dropping non-domain index
  • ora-27154 : post/wait create failed
  • ora-39055 : The string feature is not supported in version string.
  • ora-01310 : requested return type not supported by the lcr_mine function
  • ora-01575 : timeout waiting for space management resource
  • ora-39119 : worker process interrupt for delete worker processes call by master process
  • ora-09854 : snyPortInfo: bad return code from request.
  • ora-30456 : 'string.string' cannot be refreshed because of insufficient privilege
  • ora-25214 : cannot specify delay or expiration for enqueue to exception queue
  • ora-02279 : duplicate or conflicting MINVALUE/NOMINVALUE specifications
  • ora-03247 : Invalid block number specified
  • ora-13243 : specified operator is not supported for 3- or higher-dimensional R-tree
  • 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.