Category Archives: ORA Database Error Messages

ORA-31491: could not add logfile to LogMiner session

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31490: could not attach to LogMiner session

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31488: cannot support change set string in this configuration

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31487: cannot support begin dates or end dates in this configuration

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31486: cannot support column string in this configuration

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31485: invalid database link

oracle

ORA-31485: invalid database link
Cause: The database link used to connect from a staging database to a source database was invalid. The database link may not exist, may not be accessible to the current user, or may have been redefined since the Distributed HotLog change source was originally created
Action: Make sure that there is a database link to the source_database for the Distributed HotLog change source. Make sure this database link is accessible to the current user

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31484: source database version must be at least 9.2.0.6 or greater

oracle

ORA-31484: source database version must be at least 9.2.0.6 or greater
Cause: The source database is not at version 9.2.0.6 or higher
Action: Upgrade the source database to 9.2.0.6 or higher

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31483: cannot have spaces in the parameter string

oracle

ORA-31483: cannot have spaces in the parameter string
Cause: The specifed parameter contained at least 1 space character
Action: Check the value of the specified parameter. Remove the spaces and reissue the CDC API call

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31482: invalid option for non-distributed Hotlog change source

oracle

ORA-31482: invalid option for non-distributed Hotlog change source
Cause: A CDC API call specified enabled_source = 'Y' on a non-Distributed HotLog change source
Action: Specify a Distributed HotLog change source

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31481: change source string is not a HotLog change source

oracle

ORA-31481: change source string is not a HotLog change source
Cause: A change source was specified that was not a HotLog change source, but a HotLog change source was required
Action: Correct the call to supply a HotLog change source

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/