CONTENTS Title Page Copyright Page Send Us Your Comments Preface 1 Configuring DEC DB Integrator Gateway for ORACLE 1.1 Components of a Gateway System 1.1.1 User Interface 1.1.2 Rdb/Dispatch Interface 1.1.3 Gateway for ORACLE 1.1.4 SQL * Net or the OpenVMS Mailbox Driver 1.1.5 ORACLE RDBMS 1.2 Possible Configurations for Access to ORACLE Data 1.2.1 Local Access 1.2.2 Network Access 1.2.3 Remote Access 1.2.4 Accessing Multiple ORACLE Instances 1.3 Coordination with the ORACLE System 1.3.1 Gateway Coordinator 1.3.2 ORACLE Database Administrator 1.4 OpenVMS System Setup 2 Preparing for DEC DB Integrator Gateway for ORACLE Installation 2.1 License Registration 2.2 Prerequisite Hardware 2.3 Prerequisite and Optional Software 2.3.1 Common Components Installation Requirement 2.3.1.1 Why You Must Install Common Components 2.3.1.2 Checking for Common Components 2.4 Installation Procedure Requirements 2.4.1 Privileges and Disk Space 2.4.2 System Parameters 2.4.2.1 System Parameters Required 2.4.2.2 Calculating the Values for GBLPAGES and GBLSECTIONS 2.4.2.3 Changing System Parameter Values with AUTOGEN 2.4.3 VMSINSTAL Requirements 2.4.4 System Disk Backup 3 Installing DEC DB Integrator Gateway for ORACLE 3.1 Access to Online Release Notes and Installation Guide 3.2 Location of ORACLE Software Libraries 3.3 Installation Procedure 3.3.1 Invoking VMSINSTAL 3.3.2 Steps of the Installation Procedure 3.4 Error Recovery 4 After Installing DEC DB Integrator Gateway for ORACLE 4.1 Running the Installation Verification Procedure 4.1.1 Invoking the IVP 4.1.2 Sample IVP Log 4.2 Editing the System Startup Files 4.3 Editing the System Shutdown File 4.4 Determining User Account Privileges 4.5 Installing Licenses on All Nodes in a VMScluster 4.6 Setting Up the SQL * Net Connection 4.7 Using the OpenVMS Mailbox Driver 4.8 Linking the Gateway Image 4.8.1 Determining the Cause of a Link Failure 4.8.2 Relinking the Gateway Image 4.8.3 Running the Startup Command File 4.9 Determining and Reporting Problems A Prerequisite Installation of Common Components A.1 Common Components A.1.1 Media Required A.1.2 Version Variants and Existing Databases A.2 Disk Space Required A.3 OpenVMS Privileges Required A.4 Unlocking the Process Account Password A.5 Installing Common Components A.6 Installing Common Components Images as Shared A.6.1 Editing the Startup and Shutdown Procedures for Shared Images A.6.2 Verifying Global Pages and Sections A.6.3 Removing Installed Images A.7 Installing SQL Images for Privileged Applications A.7.1 Editing the Startup and Shutdown Procedures for Privileged Applications A.8 Using Different Versions of the Common Components A.9 Deleting Versions of the Common Components B Sample Installation C Files and Logical Names Installed on Your System C.1 File Names C.2 Logical Name