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 184.108.40.206 [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.
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 .
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