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
|
|
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
- 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.
- 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.
- 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>
- 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:
- Edit the config.sh or config.csh file to set the JAVA_HOME directory.
CAUTION: Do not edit any other parameters in this file.
- 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
- Run serverSetupPrompt.sh or serverSetupPrompt.csh to set the repository connection information and the email settings:
- At the initial prompt, enter 1 to set the repository connection information.
- Enter 3 to test the repository connection.
- Enter 4 to save the information you entered.
- 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.
- Enter 5 to exit.
- 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.
- Start the DAC server using the appropriate script (see table above).
For example, use the startserver.sh script on a Solaris or HP machine.
|