Oracle Database Errors or Warnings from Error ORA-31486 to ORA-31494

SQLServerF1

ORA-31486: cannot support column string in this configuration
Cause: The specified column cannot be used in a Distributed HotLog configuration when the source database version is 9.2.0.6 or 10.1.0.0.
Action: Remove the specified column from the CREATE_CHANGE_TABLE or ALTER_CHANGE_TABLE CDC API call.
ORA-31487: cannot support begin dates or end dates in this configuration
Cause: The specified values cannot be used in a Distributed HotLog configuration.
Action: Remove the specified values from the CREATE_CHANGE_SET CDC API call.
ORA-31488: cannot support change set string in this configuration
Cause: Change sources with the hot mine option enabled are limited to 1 change set. The system detected an existing change set so a second one can not be created.
Action: Associate the change set with a different change source.

ORA-31489: invalid DDL_MARKERS value
Cause: A DDL_MARKERS value of ‘y’ was specified for an synchronous change table.
Action: Specify a DDL_MARKERS parameter value of ‘n’ and call the procedure again.
ORA-31490: could not attach to LogMiner session
Cause: Failure during attach to a LogMiner session while advancing an asynchronous change set. This is an internal error.
Action: Contact Oracle Corporation
ORA-31491: could not add logfile to LogMiner session
Cause: Failure during add logfile to a LogMiner session while advancing an asynchronous change set. This is an internal error.
Action: Contact Oracle Corporation

ORA-31492: could not set session parameters for LogMiner session
Cause: Failure during set parameters for a LogMiner session while advancing an asynchronous change set. This is an internal error.
Action: Contact Oracle Corporation
ORA-31493: could not prepare session for LogMiner session
Cause: Failure during prepare session for a LogMiner session while advancing an asynchronous change set. This is an internal error.
Action: Contact Oracle Corporation
ORA-31494: could not activate a LogMiner session
Cause: Failure during activation of a LogMiner session while advancing an asynchronous change set. This is an internal error.
Action: Contact Oracle Corporation

Above are list of Oracle Database Errors or Warnings from Error ORA-31486 to ORA-31494 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *