ORA-21608: duration is invalid for this function

Cause : Attmept ot us ea druatino no tvaldi fo rthi sfuntcion.

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

Usea vaild druatino - apreivousyl craetedu serd uraiton ro OC_IDURTAIONS_TATMEENTo r OIC_DUARTIO_NSESISON.F or acllotu duartio nor xeteranl porcedrue druatino, ues OCEIxtPorcAlolcCallMemroy.

update : 27-06-2017

ORA-21608 - duration is invalid for this function
ORA-21608 - duration is invalid for this function

  • ora-12545 : Connect failed because target host or object does not exist
  • ora-25238 : too many recipients specified for message destination string
  • ora-02055 : distributed update operation failed; rollback required
  • ora-36684 : (XSDPART22) You cannot rename values of DIMENSION workspace object because it is the partition dimension of RANGE PARTITION TEMPLATE workspace object
  • ora-30108 : invalid positional parameter value 'string'
  • ora-25406 : could not generate a connect address
  • ora-24752 : OCI_TRANS_NEW flag must be specified for local transactions
  • ora-01317 : Not attached to a Logminer session
  • ora-19510 : failed to set size of string blocks for file "string" (blocksize=string)
  • ora-16187 : LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes
  • ora-39501 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-15083 : failed to communicate with ASMB background process
  • ora-29327 : unsupported client compatibility mode used when talking to the server
  • ora-36376 : (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.
  • ora-25351 : transaction is currently in use
  • ora-31522 : could not find Streams object string for CDC change set string
  • ora-30049 : Internal event for TA enq tracing
  • ora-13831 : SQL profile name specified is invalid
  • ora-12599 : TNS:cryptographic checksum mismatch
  • ora-29967 : Cannot drop an operator binding with dependent objects
  • ora-40225 : model is currently in use by another process
  • ora-06261 : NETNTT: nrange() failed
  • ora-08314 : sllfcf: Error closing file
  • ora-18000 : invalid outline name
  • ora-30509 : client logoff triggers cannot have AFTER type
  • ora-07631 : smcacx: $EXPREG failure
  • ora-22916 : cannot do an exact FETCH on a query with Nested cursors
  • ora-39110 : error deleting worker processes
  • ora-01159 : file is not from same database as previous files - wrong database id
  • ora-25137 : Data value out of range
  • 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.