My Oracle Support Banner

Effect Of DataWarehouse DB TNS Change On Installed OBAW/Informatica/DAC (Doc ID 1924337.1)

Last updated on AUGUST 19, 2019

Applies to:

Business Intelligence Applications Observer - Version [AN 1900] and later
Information in this document applies to any platform.


I would like to understand if there will be any effect if current data-warehouse database TNS entries are changed (eg: host-name/port number) on OBIEE/Informatica/DAC where its repositories are installed? If there is an impact then how it can be addressed? is there a way to correct the database host-name and port details at the impacted areas/files?

  Need above clarification as we have a proposal to upgrade data-warehouse database from 10g to 11g . In case if the upgrade is not an in-house upgrade then the TNS service name and port will be changed and would like to know how its going to impact and what is the solution.

More Info:

1.What is the DAC version (From DAC Client>Help>About DAC)
-- DAC version :
2.What is the Informatica version and hot fix?
-- Informatica Version: 9.0.1 HotFix2 1111 242(R181 D90)
3. Please clarify which component of OBIEE residing on the concerning database OR you mean OBIA business analytics warehouse schema (OBAW) ?
-- Entire OBIA business analytics warehouse schema, Informatica repository and DAC repository .


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.