Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Migrating from BIP 12c to OAP 7.0

Closed
11
Views
1
Comments
User_IHX67
User_IHX67 Rank 1 - Community Starter
edited Sep 24, 2024 1:46PM in Oracle Analytics Publisher

Hi there,

I'm reaching out to the community to see if anyone has encountered this scenario and to learn the best way to handle it. Your suggestions are greatly appreciated.

Currently we are using BIP 12c which is integrated with Siebel for Reporting.

We are migrating from one OS to another (from Windows Server 2016 to Windows Server 2022) for both the database and the application. Simultaneously, we are upgrading from BIP 12c to OAP 7.0. How can we accomplish this? Clearly, I need to install OAP on the new host when migrating the platform.

For the Database (MS SQL Server), we are using a cloned database that already contains the BIP 12.2.1.2.0 schema, which means the database host name is different, and this needs to be updated in COMPONENT_SCHEMA_INFO. (SQL: SELECT DB_HOSTNAME, DB_SERVICE, DB_PORTNUMBER FROM VEC_STB.COMPONENT_SCHEMA_INFO;) How do we do that?

I installed WebLogic 12.2.1.4.0/OAS 7.0 on the new host and tried running RCU with the existing database schema prefix, but it failed with the following errors:

Error: "RCU-6015: Component validation failed. Cause: RCU-6015: No component was selected or specified. Action: RCU-6015: Select or specify at least one component."

Consequently, I considered using the upgrade assistant to upgrade the database schema, but for that, I need the domain created beforehand.

When I tried to create the domain using the existing schema and OAP as a standalone product, it resulted in the following error:

Error: "Schemas for RCU prefix 'VEC_STB' have already been used. Re-run RCU to create clean schemas."

Without these steps, I am unable to upgrade the existing 12c schema to OAS/OAP 7.0. I'm eager to understand how we can complete this migration while retaining the existing schema in the database and upgrading it to OAP 7.0.

Thanks, AJ

Answers

This discussion has been closed.