Informatica .profile file and Environment Variables

# Informatica ENV variables in .profile
#Oracle
ORACLE_BASE=/opt/oracle/product; export ORACLE_BASE
ORACLE_HOME=/opt/oracle/shared/product/1120_sl;export ORACLE_HOME
TNS_ADMIN=/var/opt/oracle;export TNS_ADMIN

#INFA
INFA_HOME=/app/informatica/informat/lds01286/PC95HF4
export INFA_HOME
INFA_DOMAINS_FILE=$INFA_HOME/domains.infa
export INFA_DOMAINS_FILE

#MQ
MQ=/opt/mqm;export MQ

#JAVA settings
JAVA_HOME=$INFA_HOME/java;export JAVA_HOME
JRE_HOME=$JAVA_HOME/jre;export JRE_HOME

#ODBC
ODBCHOME=$INFA_HOME/ODBC6.1;export ODBCHOME
ODBCINI=$ODBCHOME/odbc.ini;export ODBCINI

#PowerExchange Variables#
PWX_HOME=/app/informatica/infapwx/lds01286/v900
export PWX_HOME

#Teradata Parallel Transport
TERADATA_HOME=/opt/teradata/client/13.10;export TERADATA_HOME
TWB_ROOT=$TERADATA_HOME/tbuild;export TWB_ROOT
TD_ICU_DATA=$TERADATA_HOME/tdicu/lib;export TD_ICU_DATA
TERA_HOME=$TERADATA_HOME/odbc_64;export TERA_HOME
TPT_HOME=$TWB_ROOT;export TPT_HOME
NLSPATH=$TPT_HOME/msg/%N:$TERADATA_HOME/odbc_64/msg/%N; export NLSPATH
COPERR=$TERADATA_HOME/lib;export COPERR
COPLIB=$TERADATA_HOME/lib;export COPLIB

#SYBASE
SYBASE=$INFA_HOME/SYBASE
export SYBASE
SYBASE_OCS=$SYBASE/OCS-15_0
export SYBASE_OCS
INCLUDE=$SYBASE_OCS/include:$INCLUDE
export INCLUDE
LIB=$SYBASE_OCS/lib:$LIB
export LIB

#MYSQL
MYSQL_HOME=/opt/shared/db/mysql
export MYSQL_HOME
MYSQL_BIN=$MYSQL_HOME/bin
export MYSQL_BIN
MYSQL_LIB=$MYSQL_HOME/lib
export MYSQL_LIB
MANPATH=$MYSQL_HOME/man:$MANPATH
export MANPATH
MYSQL_TEMPLATES_DIR=$MYSQL_BIN/templates
export MYSQL_TEMPLATES_DIR
DATA_DIR=$MYSQL_HOME/mysql
export DATA_DIR


#PATH
PATH=$ORACLE_HOME/bin:$PATH
PATH=$PATH:/usr/kerberos/bin:/usr/bin:/usr/sbin:/usr/lib:/usr/ccs/bin:/usr/ucb:/home/infaav1/bin:/usr/local/bin:.
PATH=$INFA_HOME/server:$PATH
PATH=$INFA_HOME/server/bin:$PATH
PATH=$ODBCHOME/bin:$PATH
PATH=$JAVA_HOME/bin:$PATH
PATH=$TWB_ROOT/bin:$TERADATA_HOME/client/bin:$TERADATA_HOME/bin:$PATH
PATH=$MYSQL_BIN:$PATH
PATH=$SYBASE_OCS/bin:$PATH
PATH=$PWX_HOME:$PATH
PATH=$MQ/bin:$PATH
export PATH

#LD_LIBRARY
LD_LIBRARY_PATH=/usr/openwin/lib:/usr/dt/lib:/usr/lib/:/usr/lib/sparcv9/:$ORACLE_HOME/lib
LD_LIBRARY_PATH=$ODBCHOME/lib:$LD_LIBRARY_PATH
LD_LIBRARY_PATH=$JAVA_HOME/lib:$LD_LIBRARY_PATH
LD_LIBRARY_PATH=$JRE_HOME/lib:$JRE_HOME/lib/sparcv9/:$JRE_HOME/lib/sparcv9/jli:$LD_LIBRARY_PATH
LD_LIBRARY_PATH=$TPT_HOME/lib:$TERA_HOME/lib:$TERADATA_HOME/lib:$TD_ICU_DATA:$TWB_ROOT/lib64:$LD_LIBRARY_PATH
LD_LIBRARY_PATH=$MYSQL_LIB:$LD_LIBRARY_PATH
LD_LIBRARY_PATH=$SYBASE_OCS/lib:$SYBASE_OCS/lib3p64:$SYBASE/DataAccess64/ODBC/lib:$LD_LIBRARY_PATH
LD_LIBRARY_PATH=$PWX_HOME:$LD_LIBRARY_PATH
LD_LIBRARY_PATH=$MQ/lib64:$MQ/java/lib64:$LD_LIBRARY_PATH
LD_LIBRARY_PATH=$INFA_HOME/server/bin:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

#MQ SERVER
MQSERVER='INFORMAT.SVRCONN/TCP/ldsop001.kcd.com (1334)'; export MQSERVER

#UNIX
PM_USER=Administrator
PM_PASSWD="5eFM0Rhhhhh3heh4hhee=="
PM_PORT=6005
IP_ADDRESS=1.52.230.297
SERVICE_NAME=INF_INT_ASCII
UNICODE_SERVICE_NAME=INF_INT_UNICODE
UTF8_SERVICE_NAME=INF_INT_UTF8
DOMAIN_NAME=INF_DEV_DOM
export PM_USER PM_PASSWD PM_PORT IP_ADDRESS SERVICE_NAME UNICODE_SERVICE_NAME DOMAIN_NAME UTF8_SERVICE_NAME

#ksh
ulimit -c unlimited
ulimit -n 8192

#CODE PAGES
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export NLS_LANG;
LC_ALL="C"
export LC_ALL;
export LC_MONETARY=en_US.ISO8859-1;
export LC_TIME=en_US.ISO8859-1;
export LC_MESSAGES=C;
export LC_CTYPE=en_US.ISO8859-1;
export LC_COLLATE=en_US.ISO8859-1;
export LC_NUMERIC=en_US.ISO8859-1;
export LANG=C;

Popular Posts

Featured Post

Basic unix commands used in Administration

ls –ltr                Shows all the files and sub directories in the  current directory. ls –la                  Shows all the hidden...