Category Archives: ORA Database Error Messages

ORA-31448: invalid value for change_source

oracle

ORA-31448: invalid value for change_source
Cause: The specified value was not a valid name for a Change Source
Action: Specify a valid name and retry the command

Back to previous menu

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

ORA-31447: cannot create change tables in the SYS schema

oracle

ORA-31447: cannot create change tables in the SYS schema
Cause: Attempted to create a change table in the SYS schema. This is not allowed
Action: Use a different existing schema and retry the command

Back to previous menu

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

ORA-31446: this session does not own the lock handle for string

oracle

ORA-31446: this session does not own the lock handle for string
Cause: CDC attempted to acquire a lock on the resource, does not own the the lock associated with the lock. This is an internal error
Action: Contact Oracle corporation

Back to previous menu

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

ORA-31445: invalid lock handle while acquiring lock on string

oracle

ORA-31445: invalid lock handle while acquiring lock on string
Cause: CDC attempted to acquire a lock on the resource, but encountered a invalid lock handle, which did not correspond to any existing handle
Action: Contact Oracle corporation

Back to previous menu

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

ORA-31444: parameter error while acquiring lock on string

oracle

ORA-31444: parameter error while acquiring lock on string
Cause: CDC attempted to acquire a lock on the resource, but encountered a problem passing parameters to the lock manager
Action: Contact Oracle corporation

Back to previous menu

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

ORA-31443: deadlock detected while acquiring lock on string

oracle

ORA-31443: deadlock detected while acquiring lock on string
Cause: CDC attempted to acquire a lock on the resource, but encountered a deadlock
Action: Contact Oracle corporation

Back to previous menu

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

ORA-31442: operation timed out while acquiring lock on string

oracle

ORA-31442: operation timed out while acquiring lock on string
Cause: CDC attempted to acquire a lock on the resource, but the operation timed out
Action: Retry the operation later

Back to previous menu

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

ORA-31441: table is not a change table

oracle

ORA-31441: table is not a change table
Cause: User attempted to execute the DROP_CHANGE_TABLE procedure on a table that is not a CHANGE table. This can also occur when a CHANGE table object has been orphaned. CHANGE tables can become orphaned after a CREATE_CHANGE_TABLE failure or an incomplete DROP_CHANGE_TABLE
Action: Check spelling. If error was due to an incorrect name, then retry the procedure using the correct name. To drop a table that is not a CHANGE table, or an orphaned CHANGE table, use the DROP TABLE DDL command instead

Back to previous menu

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

ORA-31440: change set string is empty and cannot be advanced

oracle

ORA-31440: change set string is empty and cannot be advanced
Cause: User attempted to advance a change set which does not contain any change tables. Without change tables, a change set cannot be advanced
Action: Create change tables in the change set, then retry the advance

Back to previous menu

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

ORA-31439: subscription is already active

oracle

ORA-31439: subscription is already active
Cause: The subscription is already active
Action: Check name and retry

Back to previous menu

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