Issues with DB Connection when creating the Informatica Power Center Repository

Share

image

This was one of those errors that are very simple yet take a lot of your time to figure out. When trying to create a Informatica Power Center Repository Service in the web interface for the administration console I ran into a “An Exception has occurred. The database connection detail for service INFA_REPO_SVC are invalid. Please check log for details”, after a long time searching online and looking at different forums I finally came across a post that recommended you use the following  format for your repository database entry on tnsnames.ora:

BIAPPS.world =

(DESCRIPTION =
(ADDRESS =
(COMMUNITY=mycompany.world)(PROTOCOL = TCP)(HOST =myhost)(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID=biapps)
(GLOBAL_NAMES= biapps.world)
(SERVICE_NAME = biapps)
)
)

Once I changed my tnsnames.ora I was able to connect and create my repository. Check this other post for the script I used to create the database account and storage configuration for the repository.

Tags: , , , ,

1 Response to "Issues with DB Connection when creating the Informatica Power Center Repository"

Leave a Comment