ORA-29323: ALTER DATABASE SET COMPATIBILITY command not supported by string

Cause : The ALTER DATABASE SET COMPATIBILITY command failed because one or more instances do not support dynamic compatible setting change.

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

No action required.

update : 26-09-2017
ORA-29323

ORA-29323 - ALTER DATABASE SET COMPATIBILITY command not supported by string
ORA-29323 - ALTER DATABASE SET COMPATIBILITY command not supported by string

  • ora-13431 : GeoRaster metadata rasterType error
  • ora-02283 : cannot alter starting sequence number
  • ora-01539 : tablespace 'string' is not online
  • ora-14700 : Object(s) owned by SYS cannot be locked by non-SYS user
  • ora-29848 : error occurred in the execution of ODCIINDEXMERGEPARTITION routine
  • ora-27141 : invalid process ID
  • ora-32407 : cannot exclude new values when materialized view log includes new values
  • ora-02208 : duplicate MAXTRANS option specification
  • ora-29289 : directory access denied
  • ora-24952 : register, unregister or post has incorrect collection count
  • ora-27153 : wait operation failed
  • ora-00229 : operation disallowed: already hold snapshot control file enqueue
  • ora-19694 : some changed blocks were not found in the change tracking file
  • ora-38621 : Decision Tree maximum depth setting not between [2, 20]
  • ora-29277 : invalid SMTP operation
  • ora-13380 : network not found
  • ora-16006 : audit_trail destination incompatible with database open mode
  • ora-32155 : Anydata not specified
  • ora-06576 : not a valid function or procedure name
  • ora-24018 : STOP_QUEUE on string failed, outstanding transactions found
  • ora-24334 : no descriptor for this position
  • ora-00021 : session attached to some other process; cannot switch session
  • ora-32340 : cannot tune the materialized view definition
  • ora-12233 : TNS:Failure to accept a connection
  • ora-10700 : Alter access violation exception handler
  • ora-06037 : NETDNT: connect failed, node unreachable
  • ora-33006 : (XSAGDNGL02) The relation workspace object is not related to itself.
  • ora-24385 : Application context size or index is not valid
  • ora-13226 : interface not supported without a spatial index
  • ora-00100 : no data found
  • 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.