OpenLink Multi-tier Server Side Components (Windows) for Oracle

Aims and Intentions

This guide is intended to enable competent system administrators to install and configure OpenLink Multi-tier client side components on Windows operating systems in a few steps as possible.

This guide does not explain any of the non-pertinent features encountered along the way. Such explanations may be found in the full documentation.

Prerequisites

You MUST be proficient in using Command Prompt window (for preferred testing purposes).
There MUST be an installation of either Oracle (full), Oracle Client or Oracle Instant Client present on the machine and you will MUST know where this installation resides.

Installation

Copy all relevant installation components to a suitable starting directory such as your Desktop.

As a bare minimum, these will include; the OpenLink Request Broker, an OpenLink Database Agent for Oracle and finally an OpenLink license file (oplrqb.lic).
Install the OpenLink Request Broker which will prompt for the license file
Install the OpenLink Database Agent for Oracle
All installers should finish without error.

Licensing

OpenLink Multi-tier licensing is handled on the server side so you should have provided the location of the license file (oplrqb.lic) during the installation of the Request Broker component.

If you chose to skip that part then you should now copy the license file to c:\Program Files\OpenLinkSoftware\UDA\bin

Configuration

Oracle requires a small amount of additional environmental configuration in the OpenLink Request Broker session rule book (c:\Program Files\OpenLink Software\UDA\bin\oplrqb.ini)--

Edit the file c:\Program Files\OpenLink Software\UDA\bin\oplrqb.ini with a suitable text editor such as Wordpad.

Locate and edit the [Environment xxxxx] section where xxxxx matches your target database so as to ensure that any relevant environment variables pertaining you your system and target database are correct.
NOTE: You may need to consult with your database administrator to verify these.

The following examples depict environment section for Oracle --

Oracle 9 (Full Client)


 [Environment ORACLE9]
 ORACLE_HOME	= D:\oracle\product\9.2.1\Db_1
 ;ORACLE_SID	= ORCL
 ;ORACLE_SERVER	= T
 ;TWO_TASK	= P:
 ;ODBC_CATALOGS	= Y		; Uncomment after loading odbccat9.sql
 ;MULTIPLEX_LDA	= 5		; Allow 5 OpenLink clients on a single lda
 ;OPL_USR_TBLS_FIRST=Y		; Sort SQLTables starting with user tables

Oracle 10 (Full Client)


 [Environment ORACLE10]
 ORACLE_HOME	= D:\oracle\product\10.1.0\Db_1
 ;ORACLE_SID	= ORCL
 ;ORACLE_SERVER	= T
 ;TWO_TASK	= P:
 ;ODBC_CATALOGS	= Y		; Uncomment after loading odbccat9.sql
 ;MULTIPLEX_LDA	= 5		; Allow 5 OpenLink clients on a single lda
 ;OPL_USR_TBLS_FIRST=Y		; Sort SQLTables starting with user tables
 ;OCI_CONNPOOL_MIN = 0 		; if not set defaults to 0 
 ;OCI_CONNPOOL_MAX = 0		; if not set defaults to OCI_CONNPOOL_MIN 
 ;OCI_CONNPOOL_INCR = 1 		; if not set defaults to 1 
 ;OCI_CONNPOOL_WAIT = TRUE	; if not set defaults to TRUE

Oracle 10 (Instant Client)


[Environment ORACLE10]
 ORACLE_HOME	= C:\Instant_client_10_2
 ;ORACLE_SID	= ORCL
 ;ORACLE_SERVER	= T
 ;TWO_TASK	= P:
 ;ODBC_CATALOGS	= Y		; Uncomment after loading odbccat9.sql
 ;MULTIPLEX_LDA	= 5		; Allow 5 OpenLink clients on a single lda
 ;OPL_USR_TBLS_FIRST=Y		; Sort SQLTables starting with user tables
 ;OCI_CONNPOOL_MIN = 0 		; if not set defaults to 0 
 ;OCI_CONNPOOL_MAX = 0		; if not set defaults to OCI_CONNPOOL_MIN 
 ;OCI_CONNPOOL_INCR = 1 		; if not set defaults to 1 
 ;OCI_CONNPOOL_WAIT = TRUE	; if not set defaults to TRUE

Start the OpenLink Request Broker

Starting in foreground debug mode

It is often best to initially start the Request Broker in (f)oreground (d)ebug in order to diagnose problems--

In order to do this you must stop the "OpenLink Request Broker" service.

Now, open a "Command Prompt" window and --


 #cd c:\Program Files\OpenLink Software\UDA\bin
 #oplrqb -fd
 OpenLink Request Broker
 Version 2.47 as of Wed Mar 05 2008 (Release 6.2 cvsid 00089)
 Compiled for Win32 (x86)
 Copyright (C) OpenLink Software  

 Registered to OpenLink US Lab - INTERNAL USE ONLY
 with product serial number OPL-US-INTERNAL
 This is a 500 concurrent users license
 restricted to 500 concurrent connections
 Issued by OpenLink Software
 This license will expire on Thu May 22 01:52:13 2008 GMT

 using rulebook c:\Program Files\OpenLink Software\UDA\bin\oplrqb.ini
 bound TCP protocol to 0.0.0.0.5000
 created job for controlling agents
 request broker started by garry
 spawning "C:\Program Files\OpenLink Software\UDA\bin\www_sv.exe" +debug +internal 2472
 started persistent www_sv (pid=3356)

The OpenLink Request Broker will continue to run, taking over the session, until <Ctrl-C> is entered which stops the Broker

Starting Normally

To start the OpenLink Request Broker normally, simply restart the "OpenLink Request Broker" service.

Testing

You are now ready to test the connection which now requires that you read the relevant quick start guide for client component on the chosen operating system and have the OpenLink Request Broker running in (f)oreground (d)ebug mode as detailed above.

Additional Information

Any changes made to c:\Program Files\OpenLink Software\UDA\bin\oplrqb.ini whilst the Request Broker is running will require the Request Broker to be re-initialised --

Open a "Command Prompt" window and -
```
 #cd c:\Program Files\OpenLink Software\UDA\bin
 #oplshut +reinit
```