My Oracle Support Banner

RDBPROD: Oracle SQL/Services - OCI Services for Rdb F.A.Q. (Doc ID 577437.1)

Last updated on FEBRUARY 06, 2020

Applies to:

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



Purpose

This FAQ will answer questions that may come up when using the Oracle® SQL/Services - OCI Services for Rdb.  It is assumed that the reader is familiar with Oracle Rdb.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

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


In this Document
Purpose
Questions and Answers
 Managing Configuration Files
 
How do you create a new configuration file?
 
How do you convert a configuration file from a standard installation of SQL/Services, to multiversion?
 
How do you share the same configuration file in a cluster?
 
How do you extract service definitions from the configuration file before 7.1.5.6?
 How do you extract service definitions from the configuration file starting with 7.1.5.6?
 
Troubleshooting/Logging
 If there is a problem with a connection, where do you start looking?
  
After installing multiversion SQL/Services, connections from clients no longer work. Why?
 
Can you move log files off of the system disk?
 
Can you disable logging in SQL/Services?
 
How do you enable full logging?
  
How do you use the debug flags?
  
Dispatchers
 
What is each of the dispatchers for?
  
Can you do load balancing with more than one dispatcher?
 Managing/Configuring OCI Services (SQLnet) for Rdb
 What are the implications of using SQL EXPORT/IMPORT for SQLnet tables?
 
How do you configure OCI Services (SQLnet) for Rdb?
  
How do you add users to the USER$ table?
 
How can you change the password for an existing entry in the USER$ table?
 
 Security
 
What are some of the security implications when using OCI Services for Rdb?
 Upgrades
 When do you use the RDB_NATCONN_UPGRADExx.SQL scripts?
 
How do you convert a configuration file from a standard installation of SQL/Services, to multiversion?
 Miscellaneous
 What is the default Rdb transaction mode when coming in through SQL/Services?
  
How are empty strings handled through SQL/Services?
  
Do all actions have to be triggered from the Oracle side when using OCI Services for Rdb?
References

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