Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MDS Schema verfication

949295Jul 16 2012 — edited Jul 17 2012
Hi,

I am installing IAM 11.1.1.5 and OIF 11.1.1.6 on a 64 bit windows m/c.

For IAM 11.1.1.5 schema creation, i used the 11.1.1.5 RCU.
For OIF 11.1.1.6 schema creation, i used the 11.1.1.6 RCU.

While creating the weblogic domain, the schema check for OWSM MDS schema failed. On inspecting the query, i found that it was executing the query on MDS with the version 11.1.1.6. (i.e, SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='MDS' and version='11.1.1.6.0')

However for SOA MDS schema it was executing the query on MDS with version 11.1.1.5 (i.e, SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='MDS' and version='11.1.1.5.0')

In order to fix this issue, on another instance of db, i ran the 11.1.1.6 RCU and created an MDS(11.1.1.6 MDS) schema(in other words i have created 2 MDS schemas - 11.1.1.5 MDS schema and 11.1.1.6 MDS Schema). While performing the schema test during weblogic domain creation, i provided the 11.1.1.6 MDS schema connection params for OWSM MDS schema test and 11.1.1.5 MDS schema connection details for SOA MDS schema test.

All the tests now pass.

However i am not sure if having two different MDS schemas with different versions will cause any problems. I am not sure how the system would behave.
Kindly let me know if the above approach works or is there any other solution.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2012
Added on Jul 16 2012
1 comment
328 views