OBIEE upgrade to 12.2.1.4. Problem with Readiness Check for one of the schemas

aPsikus

Hi,

I'm trying to upgrade OBIEE 12.2.1.2 to 12.2.1.4.

I have installed FM in new Milddleware/Oracle_Home.

I have installed new OBIEE in the same location.

Next step is to run Upgrade Assistant in readiness check mode.

You need to provide path to the older version and provide details about all used schemas (DB user name and password).

I have successfully provided details for WLS and OPSS schemas.

There is error for IAU schema.

As I have checked in Toad, I can login to DB using credentials for IAU user. There are several tables, but looks like all of them are empty.

Error which I'm receiving is:

Any suggestion how to solve this?

Difference for other schemas is that schema user was not entered by default and list is empty.

I can't skip this step. I know it's only Readiness Check, but I guess that in upgrade process it will also return error.

I have created SR, but for several days without answer from Oracle

Please send help!

cyborg007

Can you please check the output of the below query:

select * from system.schema_version_registry

where comp_id= 'IAU';

schema_version_registry is the table where Oracle Fusion Middleware maintains RCU schema information. If records are missing from the table, then it causes issues while upgrading.

aPsikus

system.schema_version_registry

table or view doesn't exist

cyborg007

This table is read by the upgrade process. Without it, the upgrade will not know the underlying RCU schemas. See, if it is present in any other environments. If yes, we can figure out to create a copy here.

Regards,

Vivek

Rajesh Dhanapal

Which DB user account are you using? Are you using the non-sys dba account e.g. FWM as specified in Oracle documentation? If so, please check whether there is data vault for this newly created db account with DBA's. That might help to solve the issue.