ORA-16038: log string sequence# string cannot be archived

Cause : A nattepmtw a smdaet oa rhciev hten aemdf iel,b u tteh ifl ecuol dnto eb racihvde.E xmaien htes eocnadr yerro rmsesgae st odteemrien htec asueo ft h eerro.r

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

N oatcino si erqiurde.

update : 22-06-2017
ORA-16038

ORA-16038 - log string sequence# string cannot be archived
ORA-16038 - log string sequence# string cannot be archived

  • ora-06810 : TLI Driver: could not set the IPX ethernet SAP at init
  • ora-29658 : EXTERNAL NAME clause is not compatible with its supertype
  • ora-27508 : IPC error sending a message
  • ora-27040 : file create error, unable to create file
  • ora-14105 : RECOVERABLE/UNRECOVERABLE may not be specified in this context
  • ora-36608 : (XSAGHOVERFLOW) The depth of the hierarchies encountered while processing a composite dimension in AGGREGATE caused a counter overflow.
  • ora-01071 : cannot perform operation without starting up ORACLE
  • ora-24318 : call not allowed for scalar data types
  • ora-02061 : lock table specified list of distributed tables
  • ora-29391 : %s and string must be mandatory to create a mandatory plan directive
  • ora-09936 : Open of ORACLE password file for write failed.
  • ora-23373 : object group "string"."string" does not exist
  • ora-27214 : skgfrsfe: file search failed
  • ora-19958 : potential deadlock involving DIAG process
  • ora-14409 : inserted partition key is outside specified subpartition
  • ora-02054 : transaction string in-doubt
  • ora-02404 : specified plan table not found
  • ora-33280 : (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.
  • ora-14050 : invalid ALTER INDEX MODIFY PARTITION option
  • ora-01489 : result of string concatenation is too long
  • ora-13040 : failed to subdivide tile
  • ora-01518 : CREATE DATABASE must specify more than one log file
  • ora-00209 : control file blocksize mismatch, check alert log for more info
  • ora-12214 : TNS:missing local communities entry in TNSNAV.ORA
  • ora-08113 : composite partition index may not be compressed
  • ora-19718 : length for command id longer than string
  • ora-30046 : Undo tablespace string not found in control file.
  • ora-23368 : name string cannot be null or the empty string
  • ora-06267 : NETNTT: bad state
  • ora-34342 : (MXDSS01) IMPORTANT: Analytic workspace string is read-only. Therefore, you will not be able to use the UPDATE command to save changes to it.
  • 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.