%META:TOPICPARENT{name="MultiTierInstallServerQuickstartUnix"}% ==OpenLink Multi-tier Server Side Components (Unix) 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 *nix style 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 a Unix shell. * You **MUST** be proficient in using a Unix editor such as vi. * You **MUST** have installed, and available to the server components; a full Oracle Client installation or Oracle Instant Client installation. ===Installation=== # Log onto the machine and create a suitable OpenLink installation directory ($OPENLINK_INSTALL).%BR% # Copy all relevant components to $OPENLINK_INSTALL.%BR%%BR% As a bare minimum, these will include; the OpenLink Request Broker, an OpenLink Database Agent for your respective target database and finally an OpenLink license file (oplrqb.lic).%BR% # Install using the "install.sh" shell script -- {{{ #sh install.sh }}} # You should take care to enter correct information when prompted pertaining to ports, passwords, etc and ensure that you note these down for future use.%BR% # The installation should finish without error.%BR% ===Licensing=== OpenLink Multi-tier licensing is handled on the server side so you should place the OpenLink license file (oplrqb.lic) in the $OPENLINK_INSTALL/bin directory. ===Configuration=== Oracle requires a small amount of additional environmental configuration in the OpenLink Request Broker session rule book ($OPENLINK_INSTALL/bin/oplrqb.ini)-- # Edit the file $OPENLINK_INSTALL/bin/oplrqb.ini with a suitable text editor such as vi.%BR%%BR% # 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.%BR%NOTE: You may need to consult with your database administrator to verify these.%BR%%BR%The following example depicts an environment section for Oracle 10-- {{{ [Environment ORACLE100] ORACLE_HOME = /usr/instantclient_10_2 ;ORACLE_SID = ;ORACLE_SERVER = ;TWO_TASK = P: ;ODBC_CATALOGS = Y ; Uncomment after loading odbccat10.sql ;MULTIPLEX_LDA = 5 ; Allow 5 OpenLink clients on a single lda ;OPL_USR_TBLS_FIRST = Y ; Sort SQLTables starting with user tables SHOW_REMARKS = N ; Retrieve SQLColumns REMARKS field CURSOR_SENSITIVITY = LOW ; Set to HIGH after loading odbccat10.sql ;OCI_PREFETCH_ROWS = 100 ; Number of rows to prefetch ;OCI_PREFETCH_MEMORY = 65535 ; Amount of memory to use for prefetching LD_LIBRARY_PATH = /usr/instantclient_10_2 ; Find shared libraries SHLIB_PATH = /usr/instantclient_10_2 ; Find HP/UX shared libraries LIBPATH = /usr/instantclient_10_2 ; Find AIX shared libraries ;NLS_LANG = AMERICAN_AMERICA.UTF8 ; Uncomment for Unicode connections }}} ===Start the OpenLink Request Broker=== # **Starting in foreground debug mode**%BR%It is often best to initially start the Request Broker in (f)oreground (d)ebug in order to diagnose problems-- {{{ #cd $OPENLINK_INSTALL #. ./openlink.sh #oplrqb -fd OpenLink Request Broker Version 2.47 as of Tue Jan 08 2008 (Release 6.2 cvsid 00089). Compiled for Solaris 5.8 (sparc-sun-solaris2.8-32) Copyright (C) OpenLink Software. Registered to OpenLink US Lab - INTERNAL USE ONLY with product serial number OPL-US-INTERNAL This is a 5 concurrent users license restricted to 5 concurrent connections Issued by OpenLink Software This license will expire on Thu May 22 01:52:13 2008 GMT oplrqb: using rulebook $OPENLINK_INSTALL/bin/oplrqb.ini oplrqb: bound TCP protocol to 0.0.0.0.5000 oplrqb: request broker started by openlink oplrqb: spawning $OPENLINK_INSTALL/bin/w3config/www_sv www_sv +debug www_sv: started http://hostname:5000 oplrqb: started persistent www_sv (pid=25896) oplrqb: ZeroConfig thread started oplrqb: ZeroConfig registration Oracle 9.2 (oplussol4) }}} The OpenLink Request Broker will continue to run, taking over the session, until <Ctrl-C> is entered which stops the Broker%BR% # **Starting Normally** {{{ #cd $OPENLINK_INSTALL #. ./openlink.sh #oplrqb }}} ===Testing=== You are now ready to test the connection which now requires that you read the relevant [[MultiTierQuickStart|quick start guide for client component]] on the chosen operating system. ===Additional Information=== # Any changes made to $OPENLINK_INSTALL/bin/oplrqb.ini whilst the Request Broker is running will require the Request Broker to be re-initialised -- {{{ #cd $OPENLINK_INSTALL #. ./openlink.sh #oplshut +reinit }}} # To stop a Request Broker running normally -- {{{ #cd $OPENLINK_INSTALL #. ./openlink.sh #oplshut +force }}}