My Oracle Support Banner

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

Last updated on FEBRUARY 06, 2020

Applies to:

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


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 - Production on Fri Aug 31 08:38:40 2001

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

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

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




To view full details, 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 a vibrant support community of peers and Oracle experts.