Wednesday, July 2, 2014

Informatica 9.0.1 Server Step by Step Installation on Windows 7

Informatica 9 Step By Step Installations on Windows 7

















































Copy your Informatica Key file in C:\ Drive.

Select Path for informatica license key file.



























Before next First we can to Set PATH for informatica Server. Otherwise Domain creation will fail.

Example.  I am installating in C:\Informatica  location

Copy the upto Bin folder.  Goto=>Mycomputer=>Right click=>Properties=>advanced System Settings=>
Environment variables=>System variabled=>Path=>Edit=>Add below in end of line;

C:\Informatica\9.0.1\server\bin;




























CREATE USER repo IDENTIFIED BY repo
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

GRANT CONNECT, resource, CREATE VIEW TO repo;

CREATE USER domain IDENTIFIED BY domain
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

GRANT CONNECT, resource, CREATE VIEW TO domain;

































If Domain Configuration fails.  Please Click on Continue and finish the installations.

Goto=> Informatica installations location

C:\Informatica\9.0.1\isp\bin     Copy this path

Open CMD promt

Change the directory to CD C:\Informatica\9.0.1\isp\bin

Apply Below command for Creating New Domain through Command Prompt.


C:\Informatica\9.0.1\isp\bin>infasetup.bat defineDomain -da localhost:1521 -dt o
racle -du POW_REP -dp POW_REP -ds xe -dn domain_localhost -ad Administrator -pd
admin -ld C:\Informatica\log -nn nodelocalhost -na localhost:6000 -mi 6000  -ma
6001  -rf nodeoptions.xml
Command ran successfully.

C:\Informatica\9.0.1\isp\bin>

Know defineDomain Syntax

 infasetup.bat defineDomain -da <dbHost>:<dbPort> -dt <dbType> -du <dbUser> -dp <dbPwd> -ds <dbServiceName> -dn <domainName> -nn <NodeName> -na <nodeHost>:<NodePort> -mi <minPort> -ma <maxPort> -ld <logDirectory> -rf nodeoptions.xml













No comments:

Post a Comment