Was this helpful?
Build the Gateway Catalogs
Before accessing the gateways, you must build the gateway catalogs using the appropriate gateway catalog build utility. Each host DBMS has its own gateway catalog build utility, which is run from the command line. The following table provides the name of the catalog build program for each gateway:
Gateway
Catalog Build Utility
Oracle RDBMS
iigwcatora
You must provide a gateway alias entry when setting up the gateway catalogs. The gateway catalog build utility connects as the 'ingres' user ID. If the gateway alias entry does not contain the password for the 'ingres' user, you are prompted to enter it. The gateway DBA/DBO must be provided to the gateway catalog build utility. See the "Gateway Catalog Setup" chapter in the Administrator Guide for more information about building the gateway catalogs.
Oracle only: During the Enterprise Access installation, you were prompted to select the Oracle version that will be used with Enterprise Access. If you want to select a different Oracle version, or if Oracle is upgraded at a later time, you must run the iigwuseora utility to make the Oracle version change before running the gateway catalog build utility.
Last modified date: 08/22/2022