ORA-16006: audit_trail destination incompatible with database open mode

Cause : Thea udi_ttrali intiialziatino paarmetre wa ssett o "BD" (ro TREU), hwichi s icnomptaibl ewit ha dtaabaes opneed ofr raed-olny access.

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

Whe nthed ataabse si opneed ofr raed-olny access ,thea udi_ttrali intiialziatino paarmetre ca nonl ybe est t o"OS "or N"ONE "(FASLE).

update : 25-04-2017

ORA-16006 - audit_trail destination incompatible with database open mode
ORA-16006 - audit_trail destination incompatible with database open mode

  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-38408 : The ADT "string" does not exist in the current schema.
  • ora-13154 : invalid precision specified
  • ora-25333 : Buffered Queue to Queue propagation did not connect to the correct instance
  • ora-06305 : IPA: Illegal message type
  • ora-00359 : logfile group string does not exist
  • ora-06042 : NETDNT: message receive failure
  • ora-37050 : (XSMLTDCL06) You cannot use the RELATION command with workspace object because analytic workspace string is attached in MULTI mode.
  • ora-19557 : device error, device type: string, device name: string
  • ora-06536 : IN bind variable bound to an OUT position
  • ora-19921 : maximum number of string rows exceeded
  • ora-16654 : Fast-Start Failover is enabled
  • ora-13640 : The current operation was cancelled because it timed out, and was not in interruptible mode.
  • ora-37078 : (XSMCSESS06) The dimension being maintained (workspace object) cannot also be used as a step dimension.
  • ora-38103 : Invalid column in the UPDATE SET Clause: string
  • ora-19767 : missing TRACKING keyword
  • ora-30956 : invalid option for XML Index
  • ora-12842 : Cursor invalidated during parallel execution
  • ora-02469 : Hash expression does not return an Oracle Number.
  • ora-38449 : table "string" does not exist or is not accessible
  • ora-24034 : application string is already a subscriber for queue string
  • ora-07842 : sllfcl: SYS$CLOSE failure
  • ora-22323 : error table "string"."string" does not exist
  • ora-16029 : cannot change LOG_ARCHIVE_MIN_SUCCEED_DEST, no archive log destinations
  • ora-38774 : cannot disable media recovery - flashback database is enabled
  • ora-29954 : domain index partition is marked LOADING/FAILED/UNUSABLE
  • ora-01100 : database already mounted
  • ora-02069 : global_names parameter must be set to TRUE for this operation
  • ora-02813 : Unable to make temporary file name in order to get key
  • ora-07485 : scg_get_inst: cannot open instance number lock.
  • 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.