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;

6 comments:

  1. Hi ,

    you have gathered a valuable information on Microsoft Technologies...., and i am much impressed with the information and it is useful Share Point Server Learners. we also provides The Best Informatica Online Training In USA,UK & INDIA.

    ReplyDelete
  2. Hi Shiva,
    I have two nodes in High Availability scenario. How can we find out which node is working as master gateway node at a given point of time

    ReplyDelete
  3. If the prerequisites are not met, we must inform you that SAP cannot provide any SAP Support Line support for your migration. All support during the migration, when solving inconsistencies and performance problems, and if data loss occurs, can be provided by SAP OS DB MIGRATION ONLINE TRAINING only as a consulting service that is subject to charge.
    SAP OS DB MIGRATION ONLINE TRAINING

    ReplyDelete
  4. Informatica Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/informatica-online-training-31.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Informatica Online Training, Informatica Training, Informatica, Informatica Online Training| Informatica Training| Informatica| "Courses at 21st Century Software Solutions
    Talend Online Training -Hyperion Online Training - IBM Unica Online Training - Siteminder Online Training - SharePoint Online Training - Informatica Online Training - SalesForce Online Training - Many more… | Call Us +917386622889 - +919000444287 - contact@21cssindia.com
    Visit: http://www.21cssindia.com/courses.html"

    ReplyDelete
  5. Thanks for Information Informatica is one of the widely used ETL Tool for extracting the source data and loading it into the target after applying the required transformation. It provides a single enterprise data integration platform to help organization access, transform, and integrate data from a large variety of systems and deliver information to other transactional systems.Informatica Online Training

    ReplyDelete
  6. Going great. Hoping to become a Good Architect, waiting for that day.

    ReplyDelete

Featured Post

Cloud : A Trendsetter Technology