Tuesday, 20 August 2013

setting up informatica repository service

setting up informatica repository service

I'm new to informatica. I ran into problems creating repository service (
i searched this forum and the internet, nothing seemed to work)
So here is my whole setup
Vsphere server 1: installed windows server 2008 (64 bit), 11g(64 bit)
Vsphere server 2: installed Windows Server 2003 (32 bit), informatica
server 8.6.0 (32 bit)
My laptop: installed Windows 7 (64 bit),
I created a user in 11g for informatica inno_informatica, grant connect,
dba, resource created another user in 11g for repository inno_repo, grant
connect, dba, resource
After I successfully installed informatica in server 2, I tried to setup
repository service, but I got an error, saying that It cann't connect to
database,
so now, the repository service is there on the left hand panel, but there
is a message in red indicating "The service did not start due to the
following error: unable to connect to the repository inno_repo on database
Orcl.132.1.123. Check the Log for more Information"
When I check the log, two messages got my attention
database driver event.... Error occurred loading library [pmora8.dll].
System error encountered is 126. Error text is The specified module could
not be found..
unable to connect to the repository inno_repo orcle.132.1.123
Also, just want to point out, the database for repository service and
informatica domain is the same one, but with different schemas. And no
informatica client, or oracle client is installed on Server 2
Do I have to install Oracle Client on Server 2?
Are certain environmental variables needed in order to problem this problem?
what about ports? what ports are needed for informatica?
if none of the above could solve the problem, then what should be done?
Can someone please help!!!
Thanks in advance.
Shawn

No comments:

Post a Comment