Question How do I configure an Oracle database with Workspace Streaming? What version of the Oracle JDBC driver is required?
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:
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":
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_126.96.36.1997_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:
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