[Prev] [Top] [Contents] (6 out of 6)

Using Multiple Databases With Oracle

If there are multiple Oracle databases that need to be accessed by your tool or client, it is necessary to perform the following to configure them:

  1. Copy the following file to a directory you want to store resource files in or else modify the one in the global location:
    cp $SAPPHIRE/newconfig/app-defaults resource_dir
    
  2. Add all of the Oracle databases to this file by following this convention:
    OracleDatabase : sid
    
    OracleDatabase : alias
    
    OracleDatabase : @T:hostname:sid
    
    OracleDatabase : @T:ip_address:sid
    
  3. In addition to the normal Gateway environment for Oracle, add the following:

    Bourne/Korn Shell:
    XAPPLRESDIR=resource_dir
    
    export XAPPLRESDIR
    
    C Shell:
    setenv XAPPLRESDIR resource_dir
    
  4. Start the Gateway in the normal fashion.
    $SAPPHIRE/bin/dborbd.sh&
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    


[Prev] [Top] [Contents] (6 out of 6)