When my Informatica v7.1.3 Repository Service refused to start this morning, I instantly thought of my recent install of Business Objects XI, with it’s myriad of services and required firewall rules. As the Windows Event Viewer revealed, the service had refused to start because of an “(356|1840) Error in opening Server Port [5001] to listen for client connections“.
AVG 7.1 to the rescue — a scan through the firewall log showed:
Date and time: 2006-08-07 11:51:22 Action: Ask Application: D:\Program Files\Business Objects\Tomcat\bin\tomcat5.exe Protocol: TCP Direction: In Local address: localhost:5001 Remote address: 0.0.0.0:0
There we go, Tomcat is using 5001.
Having not the foggiest notion of how to change Tomcat to a different port, nor what else might be required to prevent a meltdown of the entire Business Objects installation, I used the more familiar Informatica Repository Server Setup to change that component to port 5002, and he service then started right up.
Follow that with a reconfiguration of the Informatica Server service to look for the Repository service on the new port, and a similar process for the client tools through the PoweCenter Repository Manager, and I’m up and running again.
And you thought I was just some sort of Oracle geek … sheesh!
The Oracle Sponge 
I was just browsing through oraclesponge and found an entry on informatica. I didn’t know that you use Informatica too. It’s nice to know that some “oracle users”, just like me, whose blog I read on a regular basis, use Informatica just like I do. I frequently answer informatica answers on a yahoo group. To know more, please visit http://tech.groups.yahoo.com/group/informaticadevelopment/
Kirtan Desai
I work with it — I don’t have to like it :D
Well it’s not bad, but it’s not nearly as easy to get performance information out of in the way that Oracle is.
Agreed…I like it as an Extract Load tool. BTW, there are ways to get performance information out of it but as you said if you are used to Oracle performance stats there is nothing like it.
Hello, nice article.
I do daily work with Oracle, and I’m satisfied, but I don’t mean I like it, hehe.
http://www.it-developer.com.ar