RDBPROD: Primary Note for Oracle Rdb Product Family on OpenVMS (Doc ID 1162187.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Details

This Primary Note is intended to provide an index and references to the most frequently used My Oracle Support Notes for the Oracle Rdb Product Family.

My Oracle Support Community

My Oracle Support Community is a multi-channel interactive community for sharing information, posting questions and answers, and providing suggestions about Oracle products, services, and related technologies. This is a great way for customers to interact with each other.

The Community for the Oracle Rdb product set can be found here.

Alerts

2116842.1 RDBPROD: ALERT - Oracle Rdb 7.3.2 – Open VMS 8.4 is now the minimum supported version
1612294.1 RDBPROD: Rdb 7.3.1 RMU/CONVERT/ROLLBACK may corrupt database (fixed in Rdb 7.3.1.1)
1542811.1 RDBPROD: OpenVMS 8.4 on Itanium - MANDATORY patch
                                     Without this patch, wrong results may be returned
1531255.1 RDBPROD: RMU/BACKUP/PARALLEL=(...)/ENCRYPT=(...) cannot be restored (fixed in Rdb 7.2.5.2 update 3)
1450815.1 RDBPROD: RMU/REPAIR/INITIALIZE=TSN resets record lengths in AIP causing slow inserts (fixed in Rdb 7.2.5.2)
1440100.1 RDBPROD: Large TSN issues after Rdb 7.2.5.1 upgrade
1354394.1 RDBPROD: OpenVMS 8.4 patch may be required to address Deadlock detection fault
1298843.1 RDBPROD *** Alert *** Possible Corruption in Restored or Copied Databases (fixed in Rdb 7.2.4.2 update 1)

Current Releases

Oracle Rdb

  Documentation

     RDBPROD: Comprehensive Rdb Versions List
     RDBPROD: Rdb Products Logical Names
     RDBPROD: Frequently Asked AIJ Backup and Recovery Questions
     Oracle Rdb Documentation Index
     Oracle Rdb Release Notes Read Me Index  
     RDBPROD: Oracle Rdb 7.3.1.1 Release Notes for Itanium and Alpha Systems
     RDBPROD: Oracle Rdb 7.2.5.5 Release Notes for Itanium and Alpha Systems
     Oracle Rdb 7.2.5 Release Notes for Itanium and Alpha Systems
     RDBPROD: New Features Rdb 7.2
     RDBPROD: New Features Rdb 7.1
     RDBPROD: Oracle Rdb Technical Notes Index
     RDBPROD: Dynamic SQL Programming Primer
     RDBPROD: Rdb RDO Reference Manual Version 4.0 - Chapter 6
     RDBPROD: RDB Facility Messages
     RDBPROD: Oracle Rdb - SQL Message Documentation
     RDBPROD: COSI Messages (COSI_MSG.DOC) for Oracle Rdb and Oracle CODASYL DBMS
     RDBPROD: Oracle Rdb - RDMS Facility Messages
     RDBPROD: RMU Facility Messages
     RDBPROD: Oracle Rdb - RDO Facility Messages
     Oracle Rdb Server 7.0 Desupport Notice
     Oracle Rdb Server 6.1 Desupport Notice
     Oracle Rdb Server 6.0 Desupport Notice

  Troubleshooting

     Remote Diagnostic Agent (RDA) for the Rdb Product Family on OpenVMS
     RDBPROD: WATCH_QUOTAS.COM to monitor a process' quotas
     RDBPROD: Procedure to summarize a bugcheck dump
     RDBPROD: Diagnosing and Understanding Common Locking Problems
     RDBPROD: Script to run RMU/SHOW STATISTICS permanently to monitor a database
     RDBPROD: Monitor Lock Scripts for Oracle Rdb Databases
     RDBPROD: Getting ILINK-E-INVOVRINI Error on Itanium
     RDBPROD: OpenVMS 8.4 patch may be required to address Deadlock detection fault

  Technical Briefs / Frequently Used Notes

     RDBPROD: How to identify fragmented rows in a table
     RDBPROD: How to Determine if Indexes are Fragmented
     RDBPROD: Oracle Rdb Virtual Memory Options on OpenVMS - Rdb Technical Notes #35
     RDBPROD: Large TSN issues after Rdb 7.2.5.1 upgrade
     RDBPROD: Logging Options for Rdb After Image Journaling (AIJ) Detached Processes
     RDBPROD: How to Determine if Index Nodes are Fragmented
     RDBPROD: How to Encrypt and Decrypt a Database Field in Oracle Rdb
     RDBPROD: AIJ Journaling Switch-Over Recovery & Failure Prevention
     RDBPROD: Frequently Asked AIJ Backup and Recovery Questions
     RDBPROD: Planning for Success: Database Backup & Recovery Strategies
     RDBPROD: RMU/SHOW STATISTIC - Online Analysis Facility Explained
     RDBPROD: How to see who did what inserts/updates/deletes in a Rdb database using Logminer
     RDBPROD: What Is The Best Way To Reorganize A Partitioned Table In Mixed Area To Partitioned Uniform Area
     RDBPROD: Logging Options for Oracle Rdb Server Processes
     RDBPROD: RDB_AIJ_CHECK.COM - Watch Utility for AIJ File Availability
     RDBPROD: Rdb: Poor Insert Performance---Excessive Pages Checked
     RDBPROD: Restoring and Recovering a Corrupted Oracle Rdb Database Page
     RDBPROD: TRUNCATE TABLE or DROP INDEX May Leave Wasted Space
     RDBPROD: Numerous Record Lock Conflicts on Record 2:nnnn:nn
     RDBPROD: Performance Considerations for a bulk load (insert and/or updates)
     RDBPROD: RMU-E-CORRUPTPG, Page x in area x is marked as corrupt
     RDBPROD: Managing Virtual Memory with Rdb
     RDBPROD: How to RESTORE and RECOVER a database
     RDBPROD: Locked Free Space Collection Algorithm for Oracle Rdb 7.x
     RDBPROD: Using SQL To Delete Duplicate Rows In A Table
     RDBPROD: How to do an ONLINE FULL Rdb Database Backup
     RDBPROD: How to Restore a Partial Database
     RDBPROD: Online RMU Set AIP Command
     RDBPROD: How to convert a CHAR column to an UTF8 CHAR column
     RDBPROD: How To Rename Table Column Names
     RDBPROD: FAQ about Date/Time Support In Oracle Rdb
     RDBPROD: Parallel Index Creation for Oracle Rdb
     RDBPROD: Recovery Processes Take A Long Time To Recover
    

Oracle CODASYL DBMS

  Documentation

     RDBPROD: CODASYL DBMS Versions and Compatibility Matrix
     RDBPROD: Rdb Products Logical Names
     Oracle CODASYL DBMS Documentation Index
     Oracle CODASYL DBMS Release Notes & Readme Index
     RDBPROD: COSI Messages (COSI_MSG.DOC) for Oracle Rdb and Oracle CODASYL DBMS
     Oracle CODASYL DBMS 7.0 Desupport Notice
     Oracle CODASYL DBMS 6.1 Desupport Notice
     Oracle CODASYL DBMS 6.0 Desupport Notice

  Troubleshooting

     Remote Diagnostic Agent (RDA) for the Rdb Product Family on OpenVMS
     RDBPROD: WATCH_QUOTAS.COM to monitor a process' quotas
     RDBPROD: Procedure to summarize a bugcheck dump
     RDBPROD: OpenVMS 8.4 patch may be required to address Deadlock detection fault

  Technical Briefs / Frequently Used Notes

     RDBPROD: Overview of Rdb & CODASYL DBMS Database Replication With Hot Standby
     RDBPROD: How Do You Restrict a DBMS Database to Read Only Access?

Oracle SQL/Services and OCI Services for Rdb

  Documentation

     SQL/Services, OCI Services for Rdb (SQLNet), ODBC, and OEM Versions List
     RDBPROD: Oracle SQL/Services - OCI Services for Rdb F.A.Q.  
     SQL/Services, OCI Services for Rdb (SQLNet), ORDT & JDBC for Rdb
        Documentation Index
     OCI Services for Rdb (SQLNet), SQL/Services, ODBC, ORDT, JDBC for Rdb
        Release Notes & Readme Index
     RDBPROD: SQL/Services Messages

  Troubleshooting

     Remote Diagnostic Agent (RDA) for the Rdb Product Family on OpenVMS
     RDBPROD: WATCH_QUOTAS.COM to monitor a process' quotas
     RDBPROD: Procedure to summarize a bugcheck dump
     RDBPROD: Guide to Solving OCI Services Connection Problems
     RDBPROD: Finding Out Why an OCI Services Dispatcher Will Not Start
     RDBPROD: How to Enable Oracle Net Client Tracing to Debug OCI Services Network Issues
     RDBPROD: How to set up a linked server, using SQL Server 2005, to Oracle Rdb
     RDBPROD: How to match and where to find LISTENER.ORA and TNSNAMES.ORA for OCI Services
     RDBPROD: How to Troubleshoot Performance Problems Involving Access to an Rdb Database
                         via a DBLINK

  Technical Briefs / Frequently Used Notes

     RDBPROD: How to Configure OCI Services for Rdb
     RDBPROD: ORA-12504: TNS:listener was not given the SID in CONNECT_DATA
     RDBPROD: ORA-12637 using OCI Services (SQL*Net for Rdb)
     RDBPROD: ORA-01017 on Connection to Rdb via OCI Services
     RDBPROD: ORA-3134: Connections to This Server Version are No Longer Supported When Accessing Rdb
     RDBPROD: ORA-28546 or ORA-28547 encountered if connecting to Rdb
     RDBPROD: ORA-12203: TNS: unable to connect to destination
     RDBPROD: ORA-01010: invalid OCI operation connecting to Rdb from Oracle client
     RDBPROD: 10G Client Gives ORA-12705: Cannot Access NLS Data Files or Invalid Environment Specified
     RDBPROD: Connection to Rdb fails with: Error accessing PRODUCT_USER_PROFILE
     RDBPROD: ORA-02085 using database links with Oracle RDBMS and OCI Services for Rdb
     RDBPROD: ORA-01010:Invalid OCI Operation-Multiple Sessions Not Allowed
     RDBPROD: ORA-03113: End of File on Communication Channel, Attaching to Rdb
     RDBPROD: ORA-02289: sequence does not exist error selecting a Rdb sequence
     RDBPROD: ERROR: ORA-12154 TNS:Could Not Resolve Service Name
     RDBPROD: OCI access fails for some tables in database
     RDBPROD: Creating DBlinks Without Using a Username and Password
     RDBPROD: ORA-00972: Identifier is Too Long-Accessing Table with Column Length 31
     RDBPROD: ORA-00900: invalid SQL statement
     RDBPROD: Insert Over a DBlink To Rdb Fails From 11g
     RDBPROD: Distributed transaction on RDBMS and Rdb databases gives ORA-02047: Cannot join the distributed transaction in progress
     RDBPROD: Transfer of data between Oracle RDBMS and Oracle Rdb databases
     RDBPROD: How to Create an Oracle Database Link to an Rdb Database
     RDBPROD: Calling Stored Procedures With Output Parameter Does Not Work Via OCI Services
     RDBPROD: How to load data into Oracle Rdb from Oracle RDBMS using SQLPLUS
     RDBPROD: SQL*Net Error Code 12545 - Incorrect Node Name

Oracle JDBC for Rdb

  Documentation

     RDBPROD: Oracle Rdb Data Provider for .Net and JDBC for Rdb Compatibility Matrix
     RDBPROD: Oracle JDBC for Rdb F.A.Q.
     SQL/Services, OCI Services for Rdb (SQLNet), ORDT & JDBC for Rdb
        Documentation Index
     OCI Services for Rdb (SQLNet), SQL/Services, ODBC, ORDT, JDBC for Rdb
        Release Notes & Readme Index
     Oracle JDBC for Rdb Driver User's Guide, Release 7.3.0.0

  Troubleshooting

     RDBPROD: How to Enable Connection Tracing with JDBC for Rdb
     RDBPROD: Java.Sql.Sqlexception: System Error : Insufficient Global Memory
     RDBPROD: Error With Date/Time Assignment in Java
     RDBPROD: Unable to Install JDBC for Rdb
     RDBPROD: Error Starting JDBC for Rdb Servers - (permission denied (errno:13))
     RDBPROD: Process Quota Exceeded if Using JDBC for Rdb
     Remote Diagnostic Agent (RDA) for the Rdb Product Family on OpenVMS

  Technical Briefs / Frequently Used Notes

     RDBPROD: SSLHandshakeException: Remote host closed connection during handshake
     RDBPROD: JDBC for Rdb Connection Fails at null java.lang.NullPointerException Using Connection Pooling
     RDBPROD: What do SQLCode S1000 and error code 17001 mean?
     RDBPROD: JDBC for Rdb Thin Controller does not always Connect to the Corect Server
     RDBPROD: Database Data Incorrectly Translated When Using JDBC
     RDBPROD: Intermittent Looping Access Violations With Multithreaded Applications
     RDBPROD: Starting Oracle JDBC for Rdb Thin Server Fails when using Multinet

Oracle ODBC Driver for Rdb

  Documentation

     SQL/Services, OCI Services for Rdb (SQLNet), ODBC, and OEM Versions List
     RDBPROD: Oracle ODBC Driver for Rdb F.A.Q.
     OCI Services for Rdb (SQLNet), SQL/Services, ODBC, ORDT, JDBC for Rdb
        Release Notes & Readme Index
     RDBPROD: ODBC Release Notes V3.3.2.3
     RDBPROD: ODBC ReadMe 3.3.2.0

  Troubleshooting

     RDBPROD: Using the Oracle ODBC Driver for RDB with 64 bit Microsoft Windows x64
     RDBPROD: How to Locate Oracle ODBC Drivers for Rdb to Download  
     RDBPROD: Logging and Tracing Options Available for the Rdb ODBC Driver
     RDBPROD: Oracle ODBC Driver for Rdb "Test Connection" Errors

  Technical Briefs / Frequently Used Notes

     RDBPROD: RDB-E-CONVERT_ERROR retrieving an UTF8 field with ODBC for Rdb
     RDBPROD: Oracle ODBC Driver for Rdb, 64 bit -- SELECT fails to return all rows if .NET Framework 4.5 is installed
     RDBPROD: Problems After Installation of ODBC Driver for Rdb 3.3.x
     RDBPROD: Creating a DSN returns System Error Code 14001
     RDBPROD: Intermittent thread hangs, memory corruption and other symptoms when using
        the Oracle ODBC Driver for RDB and Microsoft IIS on Hyperthreading systems
     RDBPROD: Function Sequence Errors Using the Oracle ODBC Driver for Rdb

Oracle Rdb Developer Tools for Visual Studio (ORDP & DDEX)

  Documentation

     RDBPROD: Oracle Rdb Data Provider for .Net and JDBC for Rdb Compatibility Matrix
     RDBPROD: Announcing the Oracle Rdb Developer Tools for Visual Studio, Release 7.3.3
     RDBPROD: Oracle Rdb Data Provider for .Net F.A.Q.
     RDBPROD: Oracle Rdb Developer Tools for Visual Studio Documentation
     Oracle Rdb Developer Tools for Visual Studio, Development Guide, Release 7.3.2.0
     ORDP for .NET Development Guide, Release 7.3.2.0

  Troubleshooting

     RDBPROD: Running ORDP on a 64 Bit System

  Technical Briefs / Frequently Used Notes

     RDBPROD: Performance Degradation After Upgrading to ORDT 7.3.2.1
     RDBPROD: Using RDB ORDP.NET in Combination with MS Powershell to Retrieve Data
     RDBPROD: Unable To Use The Oracle RDB Data Provider With Visual Studio 2012

Oracle Rdb Extension for SQL Developer

  Documentation

     Oracle Rdb Extension for SQL Developer User's Guide V7.3
     RDBPROD: Oracle Rdb Extension for SQL Developer Release 7.3 Readme File

  Troubleshooting

     RDBPROD: SQL Developer and Oracle Rdb
     RDBPROD: Unable To Run Rdb RMU Reports From SQL Developer

  Technical Briefs / Frequently Used Notes

Oracle CDD/Repository

  Documentation

     RDBPROD: CDD/Repository Versions Matrix
     RDBPROD: Oracle CDD/Repository Documentation Index
     Oracle CDD/Repository Release Notes & Readme Index
     Oracle CDD/Repository version 7.0 Desupport Notice
     Oracle CDD/Repository version 6.1 Desupport Notice

  Troubleshooting

     Remote Diagnostic Agent (RDA) for the Rdb Product Family on OpenVMS

  Technical Briefs / Frequently Used Notes

     RDBPROD: Moving A System Or Personal Repository To New Location

Oracle Trace / Expert for Rdb

  Documentation

     RDBPROD: Replication, Trace & Expert Options for Rdb Version Lists
     Trace & Expert Documentation Index
     Trace & Expert Release Notes & Readme Index
     Oracle Expert for Rdb ALL Versions - Desupport Notice

  Troubleshooting

     RDBPROD: Procedure to summarize a bugcheck dump

  Technical Briefs / Frequently Used Notes

Oracle Rdb Extension for Oracle Enterprise Manager

  Documentation

     SQL/Services, OCI Services for Rdb (SQLNet), ODBC, and OEM Versions List
     Oracle Rdb Extension to Oracle Enterprise Manager 10g User Guide Release 7.2.1.0

  Troubleshooting

  Technical Briefs / Frequently Used Notes

     RDBPROD: Grid Control For Rdb Without Oracle 10g

Replication Option for Rdb

  Documentation

     RDBPROD: Replication, Trace & Expert Options for Rdb Version Lists
     RDBPROD: Replication Option for Rdb Documentation Index
     Replication Option for Rdb Release Notes & Readme Index

  Troubleshooting

     RDBPROD: Replication Option for Rdb Log Files - Definitions and Locations

  Technical Briefs / Frequently Used Notes

     RDBPROD: How to Move RDB$CHANGES Out of the RDB$SYSTEM Storage Area
     RDBPROD: Using TCP/IP with Rdb Replication Option

General Purpose Documents

  Information Center: Oracle Rdb Server on OpenVMS
  RDBPROD: Collaborate With Rdb Product Family MOS Community Members
  RDBPROD: Rdb Product Family Quick Reference - Documentation / Kits
  2013 Oracle Rdb and Oracle Database on OpenVMS Technical Forum Presentations
  RDBPROD: Advice on Converting from Oracle Rdb to Oracle RDBMS
  Oracle 10g Equivalents of Common Oracle Rdb RMU Commands
  RDBPROD: What are the equivalent of Rdb's SHOW commands in SQLPLUS?

Actions

Contacts

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