RDBPROD: %SQL-F-RELNOTDEF, Table SQL_CAPABILITY is Not Defined in Database or Schema When Using a DBLink with OCI Services

(Doc ID 459682.1)

Last updated on JULY 03, 2017

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.1 to 7.2 [Release 7.1 to 7.2]
Oracle SQL/Services for Rdb on OpenVMS - Version 7.1.6 to 7.2.0.2 [Release 7.1 to 7.2]
HP OpenVMS Alpha
HP OpenVMS Itanium

Symptoms

When trying to use a newly created DBLink from Oracle RDBMS to Oracle RDB, the following error is displayed:

SQL> select count(*) from degrees@rdb_test_link;
select count(*) from degrees@rdb_test_link
*
ERROR at line 1:
ORA-02071: error initializing capabilities for remote database RDB_TEST_LINK
ORA-00942: table or view does not exist
%SQL-F-RELNOTDEF, Table SQL_CAPABILITY is not defined in database or schema

Another symptom of this problem is, when connecting to an RDB database directly using SQLPlus (ie, no DBLink), the following error is returned in the login banner:

Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM

Connected to:
Oracle Compatible Release 9.2.0.4.0
Oracle Rdb OCI Server Release 7.2.0.1.1 - Production, Level 1.7
Oracle Rdb SQL Release 7.1.5.0.0 - Production

Note, in this case, the connection is successful and appears to work. Also note, using interactive SQL to do a SHOW TABLE SQL_CAPABILITY, the table does exist.

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