Skip to Content

Changing CMS and Audit Repository database from Oracle 11g to 12c

Oct 27, 2017 at 05:51 PM


avatar image

Hi Experts,

We currently migrated the CMS and Audit database from Oracle 11g to 12c. The change went well in respect to configuration but we are facing the problem for Authentication. We have AD authentincation through LDAP pluggin. We are currently on SAP BO 4.1 SP 5 version.

There are 4 AD groups and when we try to get the list of users from the group, the environment gets unresponsive the list comes as blank. We deleted the group and tried adding it back and update the authentication but no luck.

Could you please tell me what we are missing here after the change? what other configuration do we have to perform either on the Authentication side or the DB side after the migration. Any help would be much appreciated.

Thank you,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Tim Ziemba
Oct 30, 2017 at 08:44 PM

Just to verify if you access other LDAP groups they work fine?

Are the problematic groups under the same DN or located somewhere else in the directory (i.e. same DN is cn=group1,dc=dom, dc=com cn=group2,dc=dom,dc=com). If they are different are any of the differences dc= or just ou=?

When you removed the groups did you have any error upon adding them back in, or just the freezing when attempting to view the members?

Are these groups mapped into any other servers and working properly?


10 |10000 characters needed characters left characters exceeded
Manikandan Elumalai Oct 27, 2017 at 08:08 PM

- Is this happening to only to those 4 AD groups only? Is it working for other groups.

- How about your Authentication & Authorization? Is it driven through AD groups?

- Brief about how you migrated the CMS & Audit database from 11G to 12C.



10 |10000 characters needed characters left characters exceeded
Denis Konovalov
Oct 30, 2017 at 03:17 PM

How does authentication issue with 4 AD groups relates to your CMS DB oracle version change ?

10 |10000 characters needed characters left characters exceeded