Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

setting TNS_ADMIN parameter in OBIEE 11G

854098Apr 20 2011 — edited May 15 2011

Hi Gurus,

I have done simple install on Linux 64 bit Machine, i need to setup TNSNAMES.ORA file. I have copied my tnsnamesora file to:

1. <MIDDLEWARE_HOME>\Oracle_BI1\network\admin
2. <MIDDLEWARE_HOME>\oracle_common\network\admin

and now in user.sh file taken from <MIDDLEWARE_HOME>\instances\domain2\bifoundation\OracleBIApplication\coreapplication\setup, i need to update the tnsnames.ora path in TNS_ADMIN variable, when i opened the user.sh file, i found all the lines in the file commented, please help me out in which line i need to add the path for TNS_ADMIN.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

#!/bin/sh

###############################################################
# Following are the examples of configuring Oracle and DB2 UDB
# clients on various Unix and Linux Operating Systems.
#
# Please follow the examples, and update this file appropriately
# as per your locations so that Oracle BI Server can locate the
# Database Clients.
#
# Section 1 Contains examples for Oracle BI in 32 bit mode, and
# in order for BI Server 32 Bit to communicate, the DB Client
# should also be 32 bit
#
# Section 2 Contains examples for Oracle BI in 64 bit mode, and
# in order for BI Server 64 Bit to communicate, the DB Client
# should also be 64 bit
#
# IMPORTANT! Do not use the command "set -u" in the script below
# as it prevents the Oracle BI scripts to run properly.
#
###############################################################

# Section 1

###############################################################
# Solaris: Oracle BI 32 bit mode
###############################################################
#set +u

# Oracle Parameters
#---------------------------
#ORACLE_HOME=/export/home/oracle/10g
#export ORACLE_HOME
#TNS_ADMIN=$ORACLE_HOME/network/admin
#export TNS_ADMIN
#PATH=$ORACLE_HOME/bin:/opt/bin:$PATH
#export PATH
#LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH:/opt/j2se/jre/lib/sparc
#export LD_LIBRARY_PATH
#---------------------------

# DB2 Parameters
#---------------------------
# make sure the /DB2ISTANCE/sqllib/lib points to 32 lib file
#. /DB2INSTANCE/sqllib/db2profile
#---------------------------

# Essbase Parameters
#---------------------------
#ARBORPATH=/export/home/Hyperion/AnalyticServicesClient
#export ARBORPATH
#LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ARBORPATH/bin
#export LD_LIBRARY_PATH
#---------------------------

###############################################################
# Linux: Oracle BI 32 bit mode
################################################################
#set +u

# Oracle Parameters
#---------------------------
# Make sure that Oracle DB 32 bit Client is installed
#ORACLE_HOME=/export/home/oracle/10g
#export ORACLE_HOME
#TNS_ADMIN=$ORACLE_HOME/network/admin
#export TNS_ADMIN
#PATH=$ORACLE_HOME/bin:/opt/bin:$PATH
#export PATH
#LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
#export LD_LIBRARY_PATH

# If you have Linux 64 bit Platform, and would like to run Oracle BI 32 bit
# then you must install Oracle DB 64 bit client, and this client comes with
# 32 bit libraries under $ORACLE_HOME/lib32. The LD_LIBRARY_PATH in this case
# shall be like this:
#LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH
#export LD_LIBRARY_PATH

# DB2 Parameters
#---------------------------
#make sure the /DB2ISTANCE/sqllib/lib points to 32 lib file
#. /DB2ISTANCE/sqllib/db2profile
#---------------------------

# Essbase Parameters
#---------------------------
#ARBORPATH=/export/home/Hyperion/AnalyticServicesClient
#export ARBORPATH
#LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ARBORPATH/bin
#export LD_LIBRARY_PATH
#---------------------------

###############################################################
# HPUX PA-RISC: Oracle BI 32 bit mode
###############################################################
#set +u

# Oracle Parameters
#---------------------------
#ORACLE_HOME=/export/home/oracle/10g
#export ORACLE_HOME
#TNS_ADMIN=$ORACLE_HOME/network/admin
#export TNS_ADMIN
#PATH=$ORACLE_HOME/bin:/opt/bin:$PATH
#export PATH
#SHLIB_PATH=$ORACLE_HOME/lib32:$SHLIB_PATH:/opt/j2se/jre/lib/hp700
#export SHLIB_PATH
#---------------------------

# DB2 Parameters
#---------------------------
#make sure the /DB2ISTANCE/sqllib/lib points to 32 lib file
#. /DB2ISTANCE/sqllib/db2profile
#---------------------------

# Essbase Parameters
#---------------------------
#ARBORPATH=/export/home/Hyperion/AnalyticServicesClient
#export ARBORPATH
#SHLIB_PATH=$SHLIB_PATH:$ARBORPATH/bin
#export SHLIB_PATH
#---------------------------

###############################################################
# HPUX Itanium: Oracle BI 32 bit mode
###############################################################
#set +u

# Oracle Parameters
#---------------------------
#ORACLE_HOME=/export/home/oracle/10g
#export ORACLE_HOME
#TNS_ADMIN=$ORACLE_HOME/network/admin
#export TNS_ADMIN
#PATH=$ORACLE_HOME/bin:/opt/bin:$PATH
#export PATH
#SHLIB_PATH=$ORACLE_HOME/lib32:$SHLIB_PATH:/opt/j2se/jre/lib/hp700
#export SHLIB_PATH

# DB2 Parameters
#---------------------------
#make sure the /DB2ISTANCE/sqllib/lib points to 32 lib file
#. /DB2ISTANCE/sqllib/db2profile
#---------------------------

###############################################################
# AIX: Oracle BI 32 bit mode
###############################################################
#set +u

# Oracle Parameters
#---------------------------
#ORACLE_HOME=/export/home/oracle/10g
#export ORACLE_HOME
#TNS_ADMIN=$ORACLE_HOME/network/admin
#export TNS_ADMIN
#PATH=$ORACLE_HOME/bin:/opt/bin:$PATH
#export PATH
#LIBPATH=$ORACLE_HOME/lib32:$LIBPATH:/opt/j2se/jre/lib/sparc
#export LIBPATH
#---------------------------

# DB2 Parameters
#---------------------------
#make sure the /DB2ISTANCE/sqllib/lib points to 32 lib file
#. /DB2ISTANCE/sqllib/db2profile
#---------------------------

# RPAS Parameters
#---------------------------
#OA_ROOT=/export/home/rpas/odbcclient
#export OA_ROOT
#OPENRDA_INI=$OA_ROOT/config/raix/openrda.ini
#export OPENRDA_INI
#---------------------------

# Essbase Parameters
#---------------------------
#ARBORPATH=/export/home/Hyperion/AnalyticServicesClient
#export ARBORPATH
#LIBPATH=$LIBPATH:$ARBORPATH/bin
#export LIBPATH
#---------------------------

###############################################################

# Section 2:

###############################################################
# Solaris: Oracle BI 64 bit mode
###############################################################
#set +u

# Oracle Parameters
#---------------------------
# Make sure to install Oracle DB 64 bit Client
#ORACLE_HOME=/export/home/oracle/10g
#export ORACLE_HOME
#TNS_ADMIN=$ORACLE_HOME/network/admin
#export TNS_ADMIN
#PATH=$ORACLE_HOME/bin:/opt/bin:$PATH
#export PATH
#LD_LIBRARY_PATH_64=$ORACLE_HOME/lib:$LD_LIBRARY_PATH_64:/opt/j2se/jre/lib/sparc
#export LD_LIBRARY_PATH_64
#---------------------------

# DB2 Parameters
#---------------------------
#make sure the /DB2ISTANCE/sqllib/lib points to 64 lib file
#. /DB2ISTANCE/sqllib/db2profile
#LD_LIBRARY_PATH_64=/DB2ISTANCE/sqllib/lib:$LD_LIBRARY_PATH_64
#export LD_LIBRARY_PATH_64
#---------------------------

# Essbase Parameters
#---------------------------
#ARBORPATH=/export/home/Hyperion/AnalyticServicesClient
#export ARBORPATH
#LD_LIBRARY_PATH_64=$LD_LIBRARY_PATH_64:$ARBORPATH/bin
#export LD_LIBRARY_PATH_64
#---------------------------

###############################################################
# HPUX Itanium: Oracle BI 64 bit mode
###############################################################
#set +u

# Oracle Parameters
#---------------------------
#ORACLE_HOME=/export/home/oracle/10g
#export ORACLE_HOME
#TNS_ADMIN=$ORACLE_HOME/network/admin
#export TNS_ADMIN
#PATH=$ORACLE_HOME/bin:/opt/bin:$PATH
#export PATH
#SHLIB_PATH=$ORACLE_HOME/lib:$SHLIB_PATH:/opt/j2se/jre/lib/hp700
#export SHLIB_PATH
#---------------------------

# DB2 Parameters
#---------------------------
#make sure the /DB2ISTANCE/sqllib/lib points to 64 lib file
#. /DB2ISTANCE/sqllib/db2profile
#SHLIB_PATH=/DB2ISTANCE/sqllib/lib:$SHLIB_PATH
#export SHLIB_PATH
#---------------------------

# Essbase Parameters
#---------------------------
#ARBORPATH=/export/home/Hyperion/AnalyticServicesClient
#export ARBORPATH
#SHLIB_PATH=$SHLIB_PATH:$ARBORPATH/bin
#export SHLIB_PATH
#ESSLANG=English_UnitedStates.UTF-8@Binary
#export ESSLANG
#LANG=en_US.utf8
#export LANG
#---------------------------

###############################################################
# AIX: Oracle BI 64 bit mode
###############################################################
#set +u

# Oracle Parameters
#---------------------------
#ORACLE_HOME=/export/home/oracle/10g
#export ORACLE_HOME
#TNS_ADMIN=$ORACLE_HOME/network/admin
#export TNS_ADMIN
#PATH=$ORACLE_HOME/bin:/opt/bin:$PATH
#export PATH
#LIBPATH=$ORACLE_HOME/lib:$LIBPATH:/opt/j2se/jre/lib/sparc
#export LIBPATH
#---------------------------

# DB2 Parameters
#---------------------------
#make sure the /DB2ISTANCE/sqllib/lib points to 64 lib file
#. /DB2ISTANCE/sqllib/db2profile
#---------------------------

# Essbase Parameters
#---------------------------
#ARBORPATH=/export/home/Hyperion/AnalyticServicesClient
#export ARBORPATH
#LIBPATH=$LIBPATH:$ARBORPATH/bin
#export LIBPATH
#---------------------------

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Thanks,
Sree

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 12 2011

Added on Apr 20 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

3 comments

3,418 views