Effect Of DataWarehouse DB TNS Change On Installed OBAW/Informatica/DAC

(Doc ID 1924337.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

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

Goal

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 : 10.1.3.4.1.20090415.0146
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 .
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms