RDBPROD: ORA-02085 using database links with Oracle RDBMS and OCI Services for Rdb (Doc ID 174516.1)

Last updated on JULY 05, 2017

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.1.4 and later
HP OpenVMS VAX
HP OpenVMS Itanium
HP OpenVMS Alpha


Symptoms

ORA-02085 errors occur when accessing Oracle Rdb through a database link:

SVRMGR> create public database link OCI_715
              2> connect to sqluser71 identified by my_secret
              3> using 'OCI_715';
Statement processed.
SVRMGR> exit
$ sqlplus sqluser71/my_secret

SQL*Plus: Release 8.1.6.0.0 - Production on Fri Aug 31 08:38:40 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SQL> select * from dual@OCI_715;
select * from dual@OCI_715
*
ERROR at line 1:
ORA-02085: database link OCI_715.US.ORACLE.COM connects to .WORLD

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms