How do I configure an Oracle database with Workspace Streaming?

Products

• Workspace Streaming (formerly AppStream)

Issue/Introduction

 

Resolution

Question
How do I configure an Oracle database with Workspace Streaming? What version of the Oracle JDBC driver is required?

Answer

Conventions:
   APPSTREAM_HOME - environment variable specifying the root location of
                    Altiris services.
                    Default: "C:\Program Files\AppStream\awe"
   ORACLE_HOME    - environment variable specifying the root location of
                    Oracle client or server.
                    Default: C:\oracle\ora92

Note : In case Oracle database server is installed in the remote machine, Please ensure Oracle Client tool (sqlplus.exe) is installed and configured

1. Create oracle database using, for example, 'Oracle Database
   Configuration Assistant'. You may already have an Oracle database
   created during the Oracle server installation or by other means.
   (If using 'Oracle Database Configuration Assistant' to create the database
     - Choose 'General Purpose' option
     - Use "appstrm" for Global Database Name, "appstream" for SID
     - Choose 'Shared Server Mode' option).
  
   Prerequisites for this installation procedure:
     a) This script is executed on Oracle server or on a computer with
        Oracle client installed.
     b) Oracle database already exists and has a properly configured
        entry in TNSNAMES.ORA, for example:
  
        APPSTRM =
          (DESCRIPTION =
            (ADDRESS_LIST =
              (ADDRESS = (PROTOCOL = TCP)(HOST = oracle_hostname)(PORT = 1521)) )
            (CONNECT_DATA =
              (SERVICE_NAME = appstrm)
            )
          )
         
  
  
   Note : Above mentioned step has to be done by DBA prior to configure Oracle for
   Altiris server installation. In case any doubt, Please
   refer to your Oracle documentation on how to install and
          configure Oracle server and/or client. Altiris configuration starts from step 2.

   Hereafter the database instance will be referred to as 'appstrm'.

2. Here is a sequence of commands to be executed in Windows shell
   assuming Altiris server is installed in
   "c:\Program Files\altiris\StreamingServer":

   >c:
   >cd "c:\Program Files\altiris\StreamingServer\streamletEngine\db\scripts\oracle"
   >set ORACLE_HOME=C:\oracle\ora92
   >init.bat system/manager appstrm c:\Altiris.log

   Please refer to out.txt if an error occurred.
   If successful AppStream database is created and initialized.
  
3. Delete %APPSTREAM_HOME%\streamletEngine\da\conf\da.conf and Copy <source>\program files\altiris\StreamingServer\streamletengine\da\conf\oracle\da.conf to %APPSTREAM_HOME%\streamletEngine\da\conf.
   Note: <source> is refering to setup.exe folder from where you installed the server.  (Ex. for <source> c:\awe_6.1.0.477_3647\Server)

   Configure %APPSTREAM_HOME%\streamletEngine\da\conf\da.conf:
   Find and uncomment configuration properties in the "Oracle
   Configuration" section. Here is full set of oracle configuration
   parameters:
  
    appstream.database.name=appstream
    torque.database.appstream.adapter=oracle
    appstream.database.host=<oracle server hostname or IP address>
    appstream.database.port=<oracle instance port>
    torque.dsfactory.appstream.connection.driver = oracle.jdbc.driver.OracleDriver
    torque.dsfactory.appstream.connection.url=jdbc:oracle:thin:@${appstream.database.host}:${appstream.database.port}:${appstream.database.name}
    torque.dsfactory.appstream.connection.user = asuser
    torque.dsfactory.appstream.connection.password = WLVu3W2K7YUnRswjUH/EdttexD7CiDk7
    torque.dsfactory.appstream.pool.maxActive=200
    torque.dsfactory.appstream.pool.maxIdle=0
    torque.dsfactory.appstream.pool.testOnBorrow=false
    torque.dsfactory.appstream.pool.testOnReturn=false
    torque.dsfactory.appstream.pool.testWhileIdle=true
    torque.dsfactory.appstream.pool.validationQuery=SELECT 1 FROM DUAL
    torque.dsfactory.appstream.pool.maxWait = 1000
    torque.dsfactory.appstream.pool.minEvictableIdleTimeMillis = 120000
    torque.dsfactory.appstream.pool.timeBetweenEvictionRunsMillis = 20000
    torque.dsfactory.appstream.pool.numTestsPerEvictionRun = -5

4. Install Oracle JDBC drivers.
   Copy ojdbc14.jar for Oracle 9i and 10g or copy ojdbc6.jar for Oracle 11g from %ORACLE_HOME%\jdbc\lib\  
   to
      %APPSTREAM_HOME%\agent\lib,
      %APPSTREAM_HOME%\common\apache-tomcat-6.0.14\shared\lib,
      %APPSTREAM_HOME%\common\jboss-4.2.2\server\appstream\deploy\ste\ste.jar

5. Restart AWE Console, AWE Streamlet Engine and AWE Agent services. Add components.