Go to main content
1/27
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Part I Getting Started with Oracle Database Gateways
1
Getting Started with Oracle Database Gateway
Overview
Oracle Heterogeneous Services
Oracle Database Gateways
Gateway Architecture
Gateway Process Flow
Setup Flow
Part II Installing and Configuring Oracle Database Gateway for VSAM
2
Configuring Access to VSAM Data
Setting Up Access to a Computer Running Oracle Connect for IMS, VSAM, and Adabas Gateways
Setting Up a VSAM Data Source
Defining the VSAM Data Source Connection
Defining the VSAM (CICS) Data Source Connection
Configuring the VSAM or VSAM (CICS) Data Source Properties
VSAM Data Source Parameters
VSAM (CICS) Data Source Parameters
Setting Up the Metadata of the VSAM Data Source
Import the COBOL Copybooks
Apply Filters
Select Tables
Manipulate the Imported Tables
Create VSAM Indexes
Select the Metadata Model
Import the Metadata
Setting Up the Metadata of the VSAM (CICS) Data Source
Import the COBOL Copybooks
Apply Filters
Select Tables
Manipulate the Imported Tables
Assign File Names
Assign Index File Names
Select the Metadata Model
Import the Metadata
3
Installing Oracle Database Gateway for VSAM
Overview of Oracle Database Gateway for VSAM
System Requirements for Oracle Database Gateway for VSAM
Hardware Requirements for Oracle Database Gateway for VSAM
Checking the Hardware Requirements
Software Requirements for Oracle Database Gateway for VSAM
Gateway Installation Configurations
Gateway Installation Methods
Interactive Installation Method
Automated Installation Method Using Response Files
Gateway Installation Considerations
Release Notes
Hardware and Software Certification
Multiple ORACLE_HOME Directories
Installing the Software on a System with an Existing Oracle Installation
Upgrades
Accessing the Installation Software
Downloading Oracle Software from the Oracle Technology Network Web Site
Copying the Gateway Software to a Hard Disk
Running the Oracle Universal Installer
4
Configuring Oracle Database Gateway for VSAM
Configuring the Gateway
Choose a System Identifier for the Gateway
Customize the Initialization Parameter File
Configuring Oracle Net Services Listener for the Gateway
Configure Oracle Net Services Oracle Net Listener for the Gateway
Example of Address to Listen On in listener.ora File
Example of Gateway to Start in listener.ora File
Stop and Start the Oracle Net Listener for the Gateway
Configuring the Oracle Database for Gateway Access
Configuring Oracle Net Services for the Oracle Database
Configuring tnsnames.ora
Creating Database Links
Gateway Password Encryption Tool
Configuring the Gateway for Multiple VSAM Databases
Multiple Databases Example: Configuring the Gateway
Multiple Databases Example: Configuring Oracle Net Services Listener
Multiple Databases Example: Stopping and Starting the Oracle Net Listener
Multiple Databases Example: Configuring the Oracle Database for Gateway Access
Configuring Oracle Net Services on the Oracle Database for Multiple Gateway Instances
Multiple Databases Example: Accessing VSAM Data
Performing Configuration Tasks
Configuring for Global Transactions
Enabling Automatic Recovery
Testing the VSAM Data Source
Sample Log File
Part III Installing and Configuring Oracle Database Gateway for IMS
5
Configuring Access to IMS Data
Setting Up Access to a Computer Running Oracle Connect for IMS, VSAM, and Adabas Gateways
Setting Up an IMS Data Source
Defining the IMS-DLI Data Source
Setting Up the Daemon Workspace
Defining the IMS-DLI Data Source Connection
Configuring the IMS/DB DLI Data Source Properties
Defining the IMS/DB DBCTL Data Source
Define the IMS/DB DBCTL Data Source Connection
Configure the IMS/DB DBCTL Data Source Properties
Accessing IMS/DB Data under CICS
Defining the IMS/DB DBDC Data Source
Define the IMS/DB DBDC Data Source Connection
Configure the IMS/DB DBDC Data Source Properties
Access IMS/DB Data under IMS/TM
Setting Up the IMS/DB Data Source Metadata
Select the Input Files
Apply Filters
Select Tables
Match DBD to COBOL
Manipulate the Imported Records
Select the Metadata Model
Import the Metadata
6
Installing Oracle Database Gateway for IMS
Overview of Oracle Database Gateway for IMS
System Requirements for Oracle Database Gateway for IMS
Hardware Requirements for Oracle Database Gateway for IMS
Checking the Hardware Requirements
Software Requirements for Oracle Database Gateway for IMS
Gateway Installation Configurations
Gateway Installation Methods
Interactive Installation Method
Automated Installation Method Using Response Files
Gateway Installation Considerations
Release Notes
Hardware and Software Certification
Multiple ORACLE_HOME Directories
Installing the Software on a System with an Existing Oracle Installation
Upgrades
Accessing the Installation Software
Downloading Oracle Software from the Oracle Technology Network Web Site
Copying the Gateway Software to a Hard Disk
Running the Oracle Universal Installer
7
Configuring Oracle Database Gateway for IMS
Configuring the Gateway
Choose a System Identifier for the Gateway
Customize the Initialization Parameter File
Configuring Oracle Net Services Listener for the Gateway
Configure Oracle Net Services Oracle Net Listener for the Gateway
Example of Address to Listen On in listener.ora File
Example of Gateway to Start in listener.ora File
Stop and Start the Oracle Net Listener for the Gateway
Configuring the Oracle Database for Gateway Access
Configuring Oracle Net Services for the Oracle Database
Configuring tnsnames.ora
Creating Database Links
Gateway Password Encryption Tool
Configuring the Gateway for Multiple IMS Databases
Multiple Databases Example: Configuring the Gateway
Multiple Databases Example: Configuring Oracle Net Services Listener
Multiple Databases Example: Stopping and Starting the Oracle Net Listener
Multiple Databases Example: Configuring the Oracle Database for Gateway Access
Configuring Oracle Net Services on the Oracle Database for Multiple Gateway Instances
Multiple Databases Example: Accessing IMS Data
Performing Configuration Tasks
Configuring for Global Transactions
Enabling Automatic Recovery
Testing the IMS Data Source
Sample Log File
Part IV Installing and Configuring Oracle Database Gateway for Adabas
8
Configuring Access to Adabas Data
Setting Up Access to a Computer Running Oracle Connect for IMS, VSAM, and Adabas Gateways
Setting Up an Adabas Data Source
Define the Adabas Data Source Connection
Configure the Adabas Data Source Properties
Setting Up Adabas Data Source Metadata
Import Oracle Metadata from DDM Files
Export Predict Metadata into Adabas ADD
9
Installing Oracle Database Gateway for Adabas
Overview of Oracle Database Gateway for Adabas
System Requirements for Oracle Database Gateway for Adabas
Hardware Requirements for Oracle Database Gateway for Adabas
Checking the Hardware Requirements
Software Requirements for Oracle Database Gateway for Adabas
Gateway Installation Configurations
Gateway Installation Methods
Interactive Installation Method
Automated Installation Method Using Response Files
Gateway Installation Considerations
Release Notes
Hardware and Software Certification
Multiple ORACLE_HOME Directories
Installing the Software on a System with an Existing Oracle Installation
Upgrades
Accessing the Installation Software
Downloading Oracle Software from the Oracle Technology Network Web Site
Copying the Gateway Software to a Hard Disk
Running the Oracle Universal Installer
10
Configuring Oracle Database Gateway for Adabas
Configuring the Gateway
Choose a System Identifier for the Gateway
Customize the Initialization Parameter File
Configuring Oracle Net Services Listener for the Gateway
Configure Oracle Net Services Oracle Net Listener for the Gateway
Example of Address to Listen On in listener.ora File
Example of Gateway to Start in listener.ora File
Stop and Start the Oracle Net Listener for the Gateway
Configuring the Oracle Database for Gateway Access
Configuring Oracle Net Services for the Oracle Database
Configuring tnsnames.ora
Creating Database Links
Gateway Password Encryption Tool
Configuring the Gateway for Multiple Adabas Databases
Multiple Databases Example: Configuring the Gateway
Multiple Databases Example: Configuring Oracle Net Services Listener
Multiple Databases Example: Stopping and Starting the Oracle Net Listener
Multiple Databases Example: Configuring the Oracle Database for Gateway Access
Configuring Oracle Net Services on the Oracle Database for Multiple Gateway Instances
Multiple Databases Example: Accessing Adabas Data
Performing Configuration Tasks
Configuring for Global Transactions
Enabling Automatic Recovery
Testing the Adabas Data Source
Part V Installing and Working with Oracle Studio for IMS, VSAM, and Adabas Gateways
11
Installing Oracle Studio for IMS, VSAM, and Adabas Gateways
System Requirements for Oracle Studio for IMS, VSAM, and Adabas Gateways
Hardware Requirements for Oracle Studio for IMS, VSAM, and Adabas Gateways
Software Requirements for Oracle Studio for IMS, VSAM, and Adabas Gateways
Installing Oracle Studio for IMS, VSAM, and Adabas Gateways on Windows
12
Working with the Oracle Studio for IMS, VSAM, and Adabas Gateways Workbench
Using Workbench Parts
Main Screen
Main Menu Bar
Working with Views
Customizing Views
Properties View
Error Log View
Configuration View
Metadata View
Working with Perspectives
Design Perspective
Runtime Perspective
Selecting a Perspective
Setting Oracle Studio for IMS, VSAM, and Adabas Gateways Preferences
Studio
Configuration
Metadata
Runtime Manager
Keys
Default Keyboard Shortcuts
13
Configuring Oracle Connect through Oracle Studio for IMS, VSAM, and Adabas Gateways
Starting and Stopping Daemons
Starting a Daemon
Enabling Automatic Startup
Manually Starting a Daemon on z/OS Platforms
Starting Multiple Daemons
Stopping a Daemon
Shutting Down a Daemon Using Oracle Studio for IMS, VSAM, and Adabas Gateways
Shutting Down a Daemon Using the Command Line
Disabling a Workspace
Checking the Daemon
Managing Daemon Configurations
Daemon Configuration Groups
Adding and Editing Daemon Configurations
Configuring Logging
Adding and Editing Workspaces
Adding a Workspace
Editing a Workspace
WS Info
WS Server
WS Logging
WS Security
WS Governing
Managing Binding Configurations
Server Binding
Client Binding
Binding Syntax
<remoteMachines> Statement
<datasources> Statement
Sample Binding
Environment Properties
Sample Environment Properties
14
Managing Security for Oracle Connect for IMS, VSAM, and Adabas Gateways
Managing Design Time Security
Setting Up the Password Caching Policy in Oracle Studio for IMS, VSAM, and Adabas Gateways
Setting Up Administration Access to a Machine
Assigning Design Roles
Assigning Authorization Rights to a Workspace
Setting Up a Master Password for a User Profile
Managing Runtime Security
Granting Daemon Administration Rights to Users
Granting Workspace Administration Rights to Users
Granting Workspace Access Rights to a User
Accessing a Server through a Firewall
Specifying a Port Range for Workspace Servers
Accessing a Server Using Fixed NAT
Encrypting Network Communications
Transport Encryption
Setting an Encryption Protocol on the Gateway Side
Specifying the Encryption Key on the Server Machine
Setting Up Impersonation
Part VI Appendixes
A
Initialization Parameters
Initialization Parameter File Syntax
HS_DB_DOMAIN
HS_DB_INTERNAL_NAME
HS_DB_NAME
HS_DESCRIBE_CACHE_HWM
HS_LANGUAGE
Character Sets
Language
Territory
HS_LONG_PIECE_TRANSFER_SIZE
HS_OPEN_CURSORS
HS_RPC_FETCH_REBLOCKING
HS_RPC_FETCH_SIZE
HS_TRANSACTION_MODEL
IFILE
HS_FDS_CONNECT_INFO
HS_FDS_PARSER_TOKEN_SIZE
HS_FDS_RECOVERY_ACCOUNT
HS_FDS_RECOVERY_PWD
HS_FDS_TRACE_LEVEL
HS_NLS_NCHAR
HS_NLS_NUMERIC_CHARACTER
HS_FDS_DATASOURCE_NAME
HS_FDS_ACCESS_METHOD
B
Using Response Files for Non-Interactive Installation
Introduction
Using Response Files to Install Oracle Components in Non-Interactive Mode
Customizing a Sample Response File
Creating a New Response File
Running Oracle Universal Installer and Specifying a Response File
C
Oracle Database Gateway Troubleshooting
Verify Requirements
What to do if an Installation Error Occurs
Reviewing the Log of an Installation Session
Fatal Errors
Noninteractive Installation Response for File Error Handling
Cleaning Up after a Failed Installation
Index
Scripting on this page enhances content navigation, but does not change the content in any way.