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.