Siebel Analytics Platform Installation and Configuration Guide > Configuring the Siebel Analytics Data Sources >

About Locating the Database Setup Script Under UNIX

Analytics License: All licenses.

Operating System: UNIX only.

Databases: All databases.

This topic is part of the Roadmap for Configuring Siebel Analytics Platform.

You must verify the validity of the database setup script, because it is called from the Siebel Analytics startup script. Edit the file to include the environment settings for the database client of your choice. Put your database-related setup script in one of the following files, as appropriate:

• $INSTALLDIR/setup/user.sh
• $INSTALLDIR/setup/user.csh

  Examples of valid database setup scripts:

  • Excerpts from user.sh

    #For Oracle, Uncomment the following
    # ORACLE Parameters
    #---------------------------

    # ORACLE_HOME=/export/home/siebel/oracle/9.0.1
    # export ORACLE_HOME
    # TNS_ADMIN=$ORACLE_HOME/network/admin
    # export TNS_ADMIN
    # PATH=$ORACLE_HOME/bin:/opt/bin:$PATH
    # export PATH
    # SHLIB_LIBRARY_PATH=$ORACLE_HOME/lib:$SHLIB_PATH:/opt/j2se/jre/lib/hp700

    #---------------------------
    # DB2 Parameters
    #---------------------------

    # The following line sources the db2profile. If your instance name differs
    # from db2inst1, you must modify two locations in the following code examples

        . ~db2inst1/sqllib/db2profile

    # Include lib32 at the beginning of the LIBPATH until such time as Siebel
    # supports the native 64bit DB2 Client

    export LIBPATH=/home/db2inst1/sqllib/lib32:$LIBPATH

  • Excerpts from user.csh

    #For Oracle, Uncomment the following
    # ORACLE Parameters
    #---------------------------
    # setenv ORACLE_HOME /export/home/siebel/oracle/9.0.1
    # setenv TNS_ADMIN ${ORACLE_HOME}/network/admin
    # setenv PATH ${ORACLE_HOME}/bin:/opt/bin:${PATH}
    # setenv SHLIB_PATH ${ORACLE_HOME}/lib:${SHLIB_PATH}:/opt/j2se/jre/lib/hp700

    #---------------------------
    #DB2 Settings
    #---------------------------
    # The following line sources the db2profile. If your instance name differs
    # from db2inst1, you must modify two locations in the following code examples
        . ~db2inst1/sqllib/db2profile

    # Include lib32 at the beginning of the LIBPATH until such time as Siebel
    #  supports the native 64bit DB2 Client
        export LIBPATH=/home/db2inst1/sqllib/lib32:$LIBPATH

    NOTE:  The two shell script excerpts shown in are examples only and are not recommendations for particular software platforms. See Siebel System Requirements and Supported Platforms.