Informatica Installation Quick Guide
Step 1:
Install or use any existing Oracle database
database name = info/xe
sys/system pwd = info/xe
service name = info/xe
port = 1521
Step 2:
Create the following database user accounts for the following PowerCenter components:
♦Domain configuration
♦Data Profiling warehouse
♦PowerCenter repository
♦Data Analyzer repository
♦Metadata Manager repository
Connect to oracle
Sqlplus “/ as sysdba
CREATE USER Domain_conf identified by Domain_conf;
CREATE USER PCR identified by PCR;
grant connect, resource, create view to Domain_conf, DATA_PROF_WH, PCR , dar , mmr;
Step 3:
Create a windows user with name info and password info with administrative rights.
Windows user (user name = info password = info)
Logon with this user
The user account must be a member of the Administrators group and have the Log on as a service
Grant info to logon as service (Administraive tools -> local security policy)
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Step 4:
Make sure that port 6001 to 6105 are open on server.
To know if port is available or not, run the following command on command prompt
netstat -a | findstr "6001"
Step 5:
Goto Informatica installer
Make the compatibility of the [Link] to windows 2000.
Right click on [Link], goto properties, click on compatibility tab and select compatibility mode as windows 2000.
Step 6:
start installer with [Link] under
I:\Softwares\INFORMATICA\infa_powercenter_windows_x86_32bit_811_disc1\Informatica_8.1.1_PowerCenter_Windows_32Bit\PowerCenter_8.1
.1_SE_for_Windows_32Bit\pc811_windows32
License key = I:\Softwares\INFORMATICA\Informatica PC 8.1.1 Doc\Oracle_All_OS_Prod.key
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
. You have installed
Database URL is hostname:port number of database. Port is generally 1521.
Vishal Verma
Informatica Installation Quick Guide
If you donot know the port, give the following command on database server
Lsnrctl status
This would show you service name and port number.
Ensure that system environmental variable PATH have C:\Informatica\PowerCenter8.1.1\server\bin path included.
Vishal Verma
Informatica Installation Quick Guide
If you get a pinging domain error, Open the informatica service , change the logon username as ./info and password info.
restart service and it should work.
Recall that our repository user in database is PCR Password PCR.
type - oracle
connect string is INFO (local [Link] net service name).
hostname = [Link]
Port = 1522
Make sure that hostname is there in the hosts file for [Link]
CLIENT INSTALLATION
Start Installer and choose client and follow the screenshots as below.
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma
Informatica Installation Quick Guide
Vishal Verma