MDS Schema verfication
949295Jul 16 2012 — edited Jul 17 2012Hi,
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