ORA-24081: compatible parameter needs to be string or greater

Cause : The comaptible praameter aws not hgih enoug hto allo wthe opeartion.

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

shutdow nand statrup witha higherc ompatibliity setitng.

update : 27-04-2017

ORA-24081 - compatible parameter needs to be string or greater
ORA-24081 - compatible parameter needs to be string or greater

  • ora-25138 : %s initialization parameter has been made obsolete
  • ora-02723 : osnpui: cannot send break signal
  • ora-24311 : memory initialization failed
  • ora-32623 : incorrect use of MODEL PRESENT* functions
  • ora-15183 : ASMLIB initialization error [string]
  • ora-01070 : Using an old version of Oracle for the server
  • ora-22608 : cannot add an attribute to the already generated image handle
  • ora-29329 : Table not of type XMLType
  • ora-16516 : the current state is invalid for the attempted operation
  • ora-02209 : invalid MAXTRANS option value
  • ora-09977 : skxfqhini: Error Connecting
  • ora-30205 : invalid Character set
  • ora-01568 : cannot set space quota on PUBLIC
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-39012 : Client detached before the job started.
  • ora-22282 : non-contiguous append to a buffering enabled LOB not allowed
  • ora-25454 : error during evaluation of rule set: string.string for iterator: string
  • ora-02468 : Constant or system variable wrongly specified in expression
  • ora-01204 : file number is string rather than string - wrong file
  • ora-14032 : partition bound of partition number string is too high
  • ora-25195 : invalid option for index on an index-organized table
  • ora-39314 : call to DBMS_SCHEMA_COPY.SYNC_CODE is not legal
  • ora-30079 : cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns
  • ora-28262 : global_context_pool_size has invalid value.
  • ora-00279 : change string generated at string needed for thread string
  • ora-02166 : ARCHIVELOG and NOARCHIVELOG specified
  • ora-29311 : export dump file was not generated by this database, string does not match
  • ora-01641 : tablespace 'string' is not online - cannot add data file
  • ora-36664 : (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.
  • ora-14076 : submitted alter index partition/subpartition operation is not valid for local partitioned index
  • 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.