ORA-00065: initialization of FIXED_DATE failed

Cause : TheF IXE_DDAT Estrnig wsa no tin adte ofrma tyyy-ymm-dd:hh42:mis:s.

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

Mak esur ethei nitailiztaionp araemteri s i nthec orrcet dtae fromat.

update : 21-09-2017

ORA-00065 - initialization of FIXED_DATE failed
ORA-00065 - initialization of FIXED_DATE failed

  • ora-00344 : unable to re-create online log 'string'
  • ora-22305 : attribute/method/parameter "string" not found
  • ora-02796 : Done request is not in correct state
  • ora-33002 : (XSAGDNGL00) In AGGMAP workspace object, the FLOOR argument of number must be less than the CEILING argument of number.
  • ora-27504 : IPC error creating OSD context
  • ora-22611 : TDS version is not recognized
  • ora-28236 : invalid Triple DES mode
  • ora-13198 : Spatial error: string
  • ora-22885 : cannot get REF to a non-persistent object
  • ora-32808 : message system link string does not exist
  • ora-29260 : network error: string
  • ora-36820 : (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.
  • ora-38797 : Full database recovery required after a database has been flashed back
  • ora-01520 : number of data files to add (string) exceeds limit of string
  • ora-16503 : site ID allocation failure
  • ora-38854 : cannot mark instance string (redo thread string) as disabled
  • ora-19006 : XMLType TYPE storage option not appropriate for storage type
  • ora-01323 : Invalid state
  • ora-19116 : too many xmlspace declarations
  • ora-30932 : Reference node 'string' not contained in specified parent node 'string'
  • ora-32408 : materialized view log on "string"."string" already has new values
  • ora-01667 : cannot add any more tablespaces: limit of string exceeded
  • ora-10585 : Test recovery can not apply redo that may modify control file
  • ora-40287 : invalid data for model - cosine distance out of bounds
  • ora-09916 : Required password was not specified.
  • ora-01919 : role 'string' does not exist
  • ora-32620 : illegal subquery within MODEL rules
  • ora-24436 : Invalid statement Handle.
  • ora-28116 : insufficient privileges to do direct path access
  • ora-12566 : TNS:protocol error
  • 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.