- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 67 Insurance
- 536.8K On-Premises Infrastructure
- 138.5K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
OBIEE 12c: DB Repository migration from 11g to 12c
fist of all I want to state my versions I am using for the upcoming scenario / question:
OBIEE: Version 18.104.22.168.0
Oracle Essbase: Version 22.214.171.124.008.28
In the next two months our Oracle database administrator is on planning to migrate all our Oracle databases (EE) from version 11g to 12c (on a new server) and this task will also affect all repository tables for above mentioned tools which have been created during the process of installation in the past.
For migration our DBA would simply take a snapshot / dump of the productive 11g environment schemas and he would load it into the 12c environment on the new server.
User names and passwords will stay the same as on the 11g environment so I would only need to point our OBIEE and Essbase application to the new server IP address.
We have already done this kind of migration of a Hyperion Interactive Reporting environment in the past by using a config-tool which was located on the application server.
My question is at which points (maybe Enterprise Manager 12c) I would need to make an adjustment to the setup which points to the database repository?
Best regards and thanks in advance