RDBPROD: Failed to attach to remote database: SQL-F-ERRATTDEC, Error attaching to database {db} (Doc ID 1604146.1)

Last updated on AUGUST 09, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0 to 7.2.4 [Release 7.0 to 7.2]
HP OpenVMS Alpha
HP OpenVMS Itanium

Symptoms

When trying to attach to a remote database, the following error may occur:

Further analysis will indicate that the file RDBSERVERnn.EXE in SYS$SYSTEM has been overwritten with a log file RDBSERVER.LOG from the remote connection.

Changes

There are three prerequisits to run into this error:

  1. Remote access must use TCPIP instead of DECNET.
  2. A system logical RDBSERVER must be defined that points to SYS$SYSTEM:RDBSERVERnn.EXE.
  3. The user defined in the TCPIP service RDBSERVER (likely RDB$REMOTEnn) must have enough privileges to create a file SYS$COMMON:[SYSEXE]RDBSERVERnn.EXE

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