Hi Below are my notes taken during informatica 8.1 install on my laptop.
The download that we get from the oracle edelivery site
is a 8.1 and a service pack for 8.5 upgrade so ther
are two different things in that download
1) 1st error got not enough space i have lot of space
Need to run as admin as windows xp mode as cant install on
windows 7. the 8.1 version its not able to recognize space
%USERPROFILE%\AppData\Local\Temp
I tried changing the temp location but that is not the problem
i have lot of space in temp of my c drive
The issue is you need to run 8.1 with compatibility mode for
windows server 2003 .right Click on install.exe go to properties then compatibility tab and select windows 2003 it should do it
then you are asked to create domain .. domain is the primary logical unit for management and administration within powercentre
service manager runs on it . service manager supports domain and application services
in the order of services informatica 8.6.1 service is the first service
you need to create a user in oracle called informatica to store powercentre repository meaning it will save informatica jobs in oracle
database
create user informatica identified by informatica
grant all privileges to informatica
After that informatica is not able to accept these username it gives
oracle jdbc .Error establishing connection to host and port 1521
check if the listen is up
in cmd type lsnrctl then type status
I try to manually start listener from services but its starting then again stopping in 2 seconds
I had changed my pc name got from earlier command
kapil 123 is the password for domain
For informatica services also password is kapil`123
---------------------------------------------------------------------------------------------------------
Use the error below and catalina.out and node.log in the server/tomcat/logs directory on the current machine to get more information.
Select Retry to continue the installation.
STDOUT: Installing the service '"Informatica Services 8.1.1"' on node 'node01_Bhagvant-PC'...
Using CURRENT_DIR: F:\Informatica_install\server\tomcat\bin
Using INFA_HOME: F:\Informatica_install
The service '"Informatica Services 8.1.1"' has been installed.
STDERR: The filename, directory name, or volume label syntax is incorrect.
System error 1069 has occurred.
The service did not start due to a logon failure.
EXITCODE: 2
---------------------------------------------------------------------------------------
May be because my apache service was up it gave this error.so drop the informatica user from oracle as it has some repository tables
and again try the installation after disabling apache
System error 1069 has occurred
Ok finally solved .You dont need to provide any username and password as we are running as admin i dont have any user set up for my
machine
if you have user set up please enter the user or continue
---------------------------- PowerCenter Domain Creation : Success PowerCenter Ping Domain : Failed Repository Service Creation :
Skipped Repository Service Startup : Skipped PowerCenter Repository Creation : Skipped The installation debug log file can be found
at : F:/Informatica_install/Informatica_Installation_Server_Debug.log
-------------------------------------------------------------------------------------------
Now my admin console is not starting .So i deleted informatica manually from the folder as uninstaller was not working.then i removed
from start up by manually deleting.then need to go to window registerty just go to run and then regedit and look for informatica and
delete so that you are good as new
my informatica service was not started go to control panel and services and try to start informatica service if it does not start
check your path variable in environement variables it should have bin folder path where informatica is installed
after doing this my admin console is workeing
to log into admin username is admin and password is what you gave during intall
Try to create repository service from admin console .login to admin console right click on node and create repository service
before that create a licence file by right clicking on node
after you create repository service you need to create integration service
I had chagned my computer name from admin pc but in my tnsnames files it was still showing admin pc that was one issue
after that when trying to set up repository from repository manager getting error.
unable to handle request because repository content do not exists
There are 500 over tables and views present in Informatica 8.5.x Repository. All table name starts with “OPB_” and the view names
start with “REP_”.
so i did not have it in my oracle user informatica which means repository did not get created though i have repository servic
then connect to repository from repository manager by giving your oracle username and password for repository
no table and all
The download that we get from the oracle edelivery site
is a 8.1 and a service pack for 8.5 upgrade so ther
are two different things in that download
1) 1st error got not enough space i have lot of space
Need to run as admin as windows xp mode as cant install on
windows 7. the 8.1 version its not able to recognize space
%USERPROFILE%\AppData\Local\Temp
I tried changing the temp location but that is not the problem
i have lot of space in temp of my c drive
The issue is you need to run 8.1 with compatibility mode for
windows server 2003 .right Click on install.exe go to properties then compatibility tab and select windows 2003 it should do it
then you are asked to create domain .. domain is the primary logical unit for management and administration within powercentre
service manager runs on it . service manager supports domain and application services
in the order of services informatica 8.6.1 service is the first service
you need to create a user in oracle called informatica to store powercentre repository meaning it will save informatica jobs in oracle
database
create user informatica identified by informatica
grant all privileges to informatica
After that informatica is not able to accept these username it gives
oracle jdbc .Error establishing connection to host and port 1521
check if the listen is up
in cmd type lsnrctl then type status
I try to manually start listener from services but its starting then again stopping in 2 seconds
I had changed my pc name got from earlier command
kapil 123 is the password for domain
For informatica services also password is kapil`123
---------------------------------------------------------------------------------------------------------
Use the error below and catalina.out and node.log in the server/tomcat/logs directory on the current machine to get more information.
Select Retry to continue the installation.
STDOUT: Installing the service '"Informatica Services 8.1.1"' on node 'node01_Bhagvant-PC'...
Using CURRENT_DIR: F:\Informatica_install\server\tomcat\bin
Using INFA_HOME: F:\Informatica_install
The service '"Informatica Services 8.1.1"' has been installed.
STDERR: The filename, directory name, or volume label syntax is incorrect.
System error 1069 has occurred.
The service did not start due to a logon failure.
EXITCODE: 2
---------------------------------------------------------------------------------------
May be because my apache service was up it gave this error.so drop the informatica user from oracle as it has some repository tables
and again try the installation after disabling apache
System error 1069 has occurred
Ok finally solved .You dont need to provide any username and password as we are running as admin i dont have any user set up for my
machine
if you have user set up please enter the user or continue
---------------------------- PowerCenter Domain Creation : Success PowerCenter Ping Domain : Failed Repository Service Creation :
Skipped Repository Service Startup : Skipped PowerCenter Repository Creation : Skipped The installation debug log file can be found
at : F:/Informatica_install/Informatica_Installation_Server_Debug.log
-------------------------------------------------------------------------------------------
Now my admin console is not starting .So i deleted informatica manually from the folder as uninstaller was not working.then i removed
from start up by manually deleting.then need to go to window registerty just go to run and then regedit and look for informatica and
delete so that you are good as new
my informatica service was not started go to control panel and services and try to start informatica service if it does not start
check your path variable in environement variables it should have bin folder path where informatica is installed
after doing this my admin console is workeing
to log into admin username is admin and password is what you gave during intall
Try to create repository service from admin console .login to admin console right click on node and create repository service
before that create a licence file by right clicking on node
after you create repository service you need to create integration service
I had chagned my computer name from admin pc but in my tnsnames files it was still showing admin pc that was one issue
after that when trying to set up repository from repository manager getting error.
unable to handle request because repository content do not exists
There are 500 over tables and views present in Informatica 8.5.x Repository. All table name starts with “OPB_” and the view names
start with “REP_”.
so i did not have it in my oracle user informatica which means repository did not get created though i have repository servic
then connect to repository from repository manager by giving your oracle username and password for repository
no table and all
Thanks admin.your blog is really helpful.After visiting your blog I got more information.Keep blogging like this.
ReplyDeleteRegards
Informatica Training center in chennai | Informatica course in chennai
ReplyDeleteNice blog! Thanks for sharing this valuable information
Java Training in Bangalore
Java Classes in Pune
Java Training in Hyderabad
Java Training in Delhi
Java Training in Gurgaon
Fabulous Blog...good informative keep sharing
ReplyDeleteDigital Marketing Course in Chennai
Digital Marketing Training in Chennai
Digital Marketing Institute in Bangalore
Best Digital Marketing Courses in Bangalore
Digital Marketing Training Institute in Bangalore
Really nice blog. thanks for sharing
ReplyDeletebest selenium training in chennai
Best selenium Training Institute in Chennai