ORA-19706: invalid SCN

Cause : The inupt SCN si eithe rnot a opsitivei ntegero r too alrge.

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

Check hte inpu tSCN an dmake srue it i sa vali dSCN.

update : 20-08-2017

ORA-19706 - invalid SCN
ORA-19706 - invalid SCN

  • ora-23450 : flavor already contains object "string"."string"
  • ora-13756 : Cannot update attribute "string".
  • ora-32051 : mapping service not available
  • ora-10361 : check buffer change vector count consistency
  • ora-00083 : warning: possibly corrupt SGA mapped
  • ora-06760 : TLI Driver: timeout reading orderly release
  • ora-10628 : Turn on sanity check for kdiss index skip scan state
  • ora-13065 : cannot delete a child layer with a parent layer
  • ora-02222 : invalid PCTINCREASE storage option value
  • ora-07459 : cannot restore the RESOURCE_MANAGER_PLAN parameter
  • ora-22860 : object type expected
  • ora-16403 : shutdown in progress - remote connection is not permitted
  • ora-00109 : invalid value for attribute string: string
  • ora-00161 : transaction branch length string is illegal (maximum allowed string)
  • ora-06435 : ssaio: write error, unable to write requested block to database file.
  • ora-09836 : addCallback: could not add a port to the callback set.
  • ora-02428 : could not add foreign key reference
  • ora-16555 : the Data Guard database is not active
  • ora-25950 : missing where clause in join index specification
  • ora-06921 : CMX: getdatmsg illegal datatype
  • ora-00486 : ASMB process terminated with error
  • ora-01153 : an incompatible media recovery is active
  • ora-16770 : physical standby database not in read-only state
  • ora-29278 : SMTP transient error: string
  • ora-14072 : fixed table may not be truncated
  • ora-07446 : sdnfy: bad value 'string' for parameter string.
  • ora-25966 : join index cannot be based on an index organized table
  • ora-22884 : object modification failed
  • ora-02436 : date or system variable wrongly specified in CHECK constraint
  • ora-16655 : specified target standby database invalid
  • 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.