Friday, May 8, 2009

Informatica Installation

1) Virtual Name for the Unix Machines - Starting Informatica Server

When you start the informatica server the informatica will check the ip address stored in the repository (configured in workflow manager) with the ip address of the server machine.

When we want to use virtual name - the ip address resolved in the client-workflow manager will be different from the actual fiscal ip address of the server.

To Fix : Open the file pmserver.cfg and add "ServerAddress=usp-mmsprod" and then start the server.


2)Configuring the Environment Variable for Installation
---------------------------------------------------------

a)
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:path for repository server:path for informatica/pc:usr/lib:lib

PATH=$PATH: path for repository server:path for informatica/pc:usr/lib:lib


b)
For Oracle, set NLS_LANG environment variable.
If you are unsure what the value is, use the following query:
select PARAMETER, VALUE from nls_database_parameters
where PARAMETER in ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET')

Use the format NLS_LANGUAGE_NLS_TERRITORY.NLS_CHARACTERSET
E.g
NLS_LANGUAGE = AMERICAN
NLS_TERRITORY = AMERICA
NLS_CHARACTERSET = WE8ISO8859P1

NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG

c)
For 32-bit oracle set LD_LIBRARY_PATH to look in ORACLE_HOME/lib32.
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH.
Or
For 64-bit oracle set LD_LIBRARY_PATH to look in ORACLE_HOME/lib32. LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH

No comments:

Post a Comment