Archive for October, 2010

Issues with DB Connection when creating the Informatica Power Center Repository

October 22, 2010

“An Exception has occurred. The database connection detail for service INFA_REPO_SVC are invalid. Please check log for details”

Tags: , , , ,
Posted in Informatica PowerCenter, Oracle BI Apps, Oracle Database, Technical | 1 Comment »

Tip: Getting Unix command output and status in your email

October 15, 2010

I have a scheduled script that refreshes some of my materialized views but sometimes these operations could fail if the database backup takes too long or an unexpected condition presents. This led me to think of sending the output of my refresh procedures to my email or my team’s listserv, here are sample versions of my scripts:

Tags: , , , , ,
Posted in Misc, Technical, Tips | No Comments »