[Prev] [Top] (3 out of 3)

Environment Variables

In order to start the Gateway, the following environment variables must be set:

SYBASE

The SYBASE and XAPPLRESDIR environment variables must be set by typing:

C Shell
setenv SYBASE sybase_directory
setenv XAPPLRESDIR resource_directory
Bourne/Korn Shell
SYBASE=sybase_directory;export SYBASE
XAPPLRESDIR=resource_directory;export XAPPLRESDIR

ORACLE

The ORACLE_HOME and XAPPLRESDIR environment variable must be set by typing:

C Shell
setenv ORACLE_HOME oracle_directory
setenv XAPPLRESDIR resource_directory
Bourne/Korn Shell
ORACLE_HOME=oracle_directory;export ORACLE_HOME
XAPPLRESDIR=resource_directory;export XAPPLRESDIR
Note: For single database connection, set the ORACLE_SID environment variable to be the connection string for the desired database:
C Shell
setenv ORACLE_SID connection_string
Bourne/Korn Shell
ORACLE_SID=connection_string;export ORACLE_SID
Note: XAPPLRESDIR environment variable only needs to be set if you need the Gateway to find the DbuimxOrb resource file for Seeds, Hostnames or multiple Oracle databases.
For information on connecting with multiple Oracle databases, see the Preface in Getting Started with Sapphire/Web.

INFORMIX

The INFORMIXDIR and XAPPLRESDIR environment variables must be set by typing:

C Shell
setenv INFORMIXDIR informix_directory
setenv XAPPLRESDIR resource_directory
Bourne/Korn Shell
INFORMIXDIR=informix_directory;export INFORMIXDIR
XAPPLRESDIR=resource_directory;export XAPPLRESDIR
Note: For more information on the DbuimxOrb file, see Configuring Gateway and Database Servers later in this chapter.

About the Sapphire/Gateway

The Sapphire/Gateway runs as a daemon (background) process that accepts client requests across the network, and dispatches those requests to the appropriate database server. The Gateway daemon also forwards the database server's reply information back to the client application.

To start the Gateway daemon, type:

sapphire_home/bin/dborbd.sh &
To terminate the Gateway daemon, use the ps command to determine the process ID of dborbd, and use kill -HUP or kill -2 to terminate the process. See your system administrator if you require assistance.

Note: There must be a Gateway daemon executing on the network for Sapphire/Web to communicate with any database.
As provided in the installation media, Sapphire/Web is properly configured to communicate with the Gateway daemon executing on the local machine. The remainder of this section provides an overview of this configuration.

The resource file involved in configuring Gateway communication is:

$XAPPLRESDIR/DbuimxOrb
Note: There can be more than one Gateway daemon running on the network at a given time and a client application, which can specify to which instance it wishes to connect. See Chapter 4, Sapphire/Gateway in the Reference Manual for information on how to set up this configuration.

Configuring Gateway and Database Servers

Sybase
Oracle
Informix

Troubleshooting

If, for some reason, a client application cannot connect to the Gateway, you should ensure that:

If, for some reason, incorrect database server names are displayed in the Sapphire/Gateway's Network Object Browser, you should ensure that:

Sybase

Oracle

Informix


[Prev] [Top] (3 out of 3)