Oracle

The Gateway for Oracle writes selected alert details to Oracle databases.

The gateway writes to three Oracle database tables (status, journal, and details) to record all transactions that occur within alerts selected by an ObjectServer reader.

The Gateway for Oracle has the following features:
  • A permanent data cache that the gateway uses to resynchronize itself with the ObjectServer.
  • Identification of missed inserts, deletes, and updates on restart.
  • Recoverable memory-resident work regions.
  • Optimized Netcool/OMNIbus V3.x Insert, Delete, Update, Control (IDUC) processing system.
  • Statistics gathering and display.
  • Encrypted passwords used throughout.
  • Use of Oracle host (bind) arrays for faster batch data transfer.
  • An interactive gateway command-line tool (GICMD) for issuing data transfer commands.
Note: The Gateway for Oracle is now deprecated. If you are starting a new deployment, you should use instead the Gateway for JBDC.

For details about how to download the most recent version of the gateway, see the following Release Notice on the IBM® Software Support website:

https://www-304.ibm.com/support/docview.wss?uid=swg21613117

The Gateway for Oracle is described in the following sections: