Oracle® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on UNIX >

Configuring the DAC Server on UNIX


Although you can run the DAC server on a UNIX machine, Oracle does not provide a separate Oracle BI Applications installer for UNIX. Therefore, to install the DAC server in a UNIX environment, you must first install Oracle BI Applications onto a Windows machine, then manually copy over the \OracleBI\DAC\ directory to a UNIX machine, and then follow the steps below (see To configure the DAC server on UNIX).

Shell scripts are provided in the *.sh and *.csh formats. You must use the appropriate scripts in the appropriate shells, because their syntaxes are different. Table 33 lists the available shell scripts and their usage. These files contain comments that provide information about how to configure the scripts.

Table 33. Oracle Business Analytics Warehouse Scripts for Bash and C Shells
Script
Purpose

config.sh

config.csh

Configures the environment variables for DAC_HOME and JAVA_HOME.

dacCmdLine.sh

dacCmdLine.csh

Invokes DAC commands on the DAC server. See the file for usage information.

dac_env.sh

dac_env.csh

Configures environment variables, including Informatica's pmcmd utility, which enables the DAC server to invoke workflows. Other variables included are NLS_LANG and ORA_HOME.

serverSetupPrompt.sh

serverSetupPrompt.csh

Configures DAC metadata repository connection information.

serverinfo.sh

serverinfo.csh

Displays the DAC server version.

startserver.sh

startserver.csh

Starts the DAC server on machines running Solaris and HP.

startserver_aix.sh

startserver_aix.csh

Starts the DAC server on AIX machines.

stopserver.sh

stopserver.csh

Shuts down the DAC server.

NOTE:  All the files listed in Table 33 need to have read, write, and execute permissions. If the files do not have these permissions, modify them using the chmod command.

To configure the DAC server on UNIX

  1. Copy the \OracleBI\DAC\ folder from the Windows machine where you installed Oracle BI Applications to a UNIX machine.

    NOTE:  You can use FTP to copy the shell scripts under DAC using a dos2unix utility in an ascii mode. The other files can be copied in a binary mode.

  2. Using a MS-DOS to UNIX conversion tool, convert the script files in Table 33 above to UNIX format (that is, remove the carriage return and line feed characters).

    There are many MS-DOS to UNIX conversion tools that are freely available for download on the Internet. Alternatively, you can manually remove the carriage return and line feed characters from the script files.

  3. Edit the dac_env.sh or dac_env.csh file to add the path of the directories for the Informatica Server and Informatica Repository Server to the appropriate environment variable:
    • For Solaris: LD_LIBRARY_PATH
    • For AIX: LIBPATH
    • For HP: SHLIB_PATH

      For example:

    setenv LD_LIBRARY_PATH ${LD_LIBRARY_PATH}:/<INFA_HOME>/informatica<version>

  4. If you are using an Oracle database and the OCI driver, configure the following variables and uncomment in the dac_env.sh or dac_env.csh file them by removing the # sign at the beginning of the line:
    • TNS_ADMIN: To set the directory for Oracle to use tnsnames.ora files.
    • LD_LIBRARY_PATH (Solaris), LIBPATH (AIX), or SHLIB_PATH (HP): To set the Oracle library path.

      NOTE:  Informatica does not support 64-bit libraries.

  5. Edit the config.sh or config.csh file to set the JAVA_HOME directory.

    CAUTION:  Do not edit any other parameters in this file.

  6. Copy the database-specific .jar files to the $DAC/lib directory:
    • Oracle. If you are using an Oracle database (other than 8.x), find the directory where Oracle is installed. Copy the file named ojdbc14.jar in the jdbc/lib directory and paste it in the $DAC/lib directory.
      • If you are using Oracle 8.x, copy the file named classes12.zip and paste it in the $DAC/lib directory. Also, edit the ORACLELIB setting in the config.sh or config.csh file as follows:

    setenv ORACLELIB=$DAC_HOME/lib/classes12.zip

    • DB2. If you are using a DB2 database, find the directory where DB2 is installed. In the Java subdirectory copy the file named db2java.zip and paste it in the $DAC/lib directory.

      NOTE:  If your source or target database is DB2-UDB, you also need to create stored procedures to be used during the ETL process. For instructions, see Creating Stored Procedures for DB2-UDB.

    • MSSQL. If you are using an MSSQL database, download the SQL Server JDBC drivers from Microsoft's Web site. Copy the files msbase.jar, mssqlserver.jar, and msutil.jar to the $DAC/lib directory.
  7. Run serverSetupPrompt.sh or serverSetupPrompt.csh to set the repository connection information and the email settings:
    1. At the initial prompt, enter 1 to set the repository connection information.
    2. Enter 3 to test the repository connection.
    3. Enter 4 to save the information you entered.
    4. Enter 2 to set up the administrator email account.

      NOTE:  For the email functionality to work, you must be using an SMTP server in which the SMTP authentication mode LOGIN is enabled. For example, if you are using Microsoft Exchange Server, you must enable the SMTP module and enable authentication in the Basic Mode. The SMTP server outbound email authentication must be turned on for the DAC server to be able to send email notifications.

    5. Enter 5 to exit.
  8. Copy content-specific XML files from the OracleBI\DAC\CustomSQLs folder in the Windows installation to the OracleBI/DAC/CustomSQLs directory in the UNIX installation.
  9. Start the DAC server using the appropriate script (see table above).

    For example, use the startserver.sh script on a Solaris or HP machine.

Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.