Effect Of DataWarehouse DB TNS Change On Installed OBAW/Informatica/DAC
Last updated on SEPTEMBER 27, 2016
Applies to:Business Intelligence Applications Observer - Version 220.127.116.11 [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 .
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