My Oracle Support Banner

ORA-31485 'Invalid database link' Error When Running DBMS_CDC_PUBLISH.CREATE_HOTLOG_CHANGE_SOURCE Using a Valid Database Link Name (Doc ID 563978.1)

Last updated on AUGUST 27, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

When creating a Change Data Capture (CDC) hotlog change source using DBMS_CDC_PUBLISH.CREATE_HOTLOG_CHANGE_SOURCE, the following error is received:

ORA-31485: invalid database link
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_CDC_IPUBLISH", line 599
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 114
ORA-06512: at line 2

However, the database link name, which does not have a domain name appended to it, is valid and works.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.