ORA-16130: supplemental log information is missing from log stream

Cause : Supplemental logging is not enabled at the primary database.

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

Issue the following command to enable supplemental logging. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS;

update : 25-04-2017

ORA-16130 - supplemental log information is missing from log stream
ORA-16130 - supplemental log information is missing from log stream

  • ora-31613 : Master process string failed during startup.
  • ora-26705 : cannot downgrade capture process after Streams data dictionary has been upgraded
  • ora-16016 : archived log for thread string sequence# string unavailable
  • ora-31413 : change set string is currently being advanced
  • ora-02483 : Syntax error in process specification (string)
  • ora-02301 : maximum number of OIDGENERATORS is 255
  • ora-00166 : remote/local nesting level is too deep
  • ora-22911 : duplicate storage specification for the nested table item
  • ora-14610 : Lob attributes not specified for lob column string for subpartition string
  • ora-28301 : Domain Policy hasn't been registered for SSL authentication.
  • ora-15008 : cannot drop system template
  • ora-31495 : error in synchronous change table on "string"."string"
  • ora-32576 : missing TYPE keyword
  • ora-28010 : cannot expire external or global accounts
  • ora-02463 : Duplicate HASH IS option specified
  • ora-01704 : string literal too long
  • ora-09936 : Open of ORACLE password file for write failed.
  • ora-10628 : Turn on sanity check for kdiss index skip scan state
  • ora-07492 : scgrcl: cannot close lock.
  • ora-37156 : (string)
  • ora-22627 : tc [string] must be that of object/varray/nested table
  • ora-22625 : OCIAnyData is not well-formed
  • ora-06730 : TLI Driver: unable to open clone device
  • ora-16636 : Fast-Start Failover target standby in error state, cannot stop observer
  • ora-32019 : The parameter SPFILE cannot be updated in the server parameter file.
  • ora-22164 : delete element operation is not allowed for variable-length array
  • ora-02849 : Read failed because of an error
  • ora-29292 : file rename operation failed
  • ora-38608 : FI itemset minimum-length(string) should not be greater than maximum length(string)
  • ora-19509 : failed to delete sequential file, handle="string", parms="string"
  • 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.