We just started into installs for four middleware servers for a customer. These will each run DB, WebLogic, IdM, SOA/BPM, UCM, and WebCenter — all 11g. There’s nothing like getting fresh, fast, functionally-useless hardware and turning it into a powerful piece of problem-solving equipment. – Historic M&S Dogma
Oracle BAM – SQL to List Users and Roles
I don’t really like what Oracle did with BAM user/roles and authentication. I believe they took Microsoft (SQL Server) tables and just slapped them into Oracle (now requiring that we put quotes around tables and columns). I assume this process will change in the upcoming releases, but here is a quick SQL statement you can use to get a look at your users and their roles as BAM understands them: 1 2 3 4 SELECT iu."SysIterName" username, iur."RoleName" userrole FROM orabam."SysIterUser" iu, orabam."SysIterRoleUserMapping" iur WHERE iur."UserID" = iu."SysIterID" ORDER BY iu."SysIterName"SELECT iu."SysIterName" username, iur."RoleName" userrole FROM orabam."SysIterUser" iu, orabam."SysIterRoleUserMapping" iur … Read More
Oracle BAM Sucks, For Now
Our team has been working with BAM since Oracle took it on (we rolled out BAM reports in 2007). The product is certainly “interesting” and has some cool auto-refresh capabilities that make for a nice demo to executives. However, there are a few pieces to the overall reporting puzzle that, well, leave me a little puzzled… No ability to write reports that query an RDBMS or even the BAM data objects — I hope you like simple query logic. No ability to manipulate data in the BAM data objects: I just want to run an update statement people. Filters that … Read More
Oracle BAM and SOA Suite – Potential Conflict On Same Machine
We had an issue where BAM stopped working after installing SOA Suite on a Windows 2003 Server (BAM only runs on Windows at the time of this writing). After trying to uninstall/reinstall many times ourselves, Oracle Support suggested that this was not a compatible configuration. We have done it before (in play environments), but this clearly can cause some issues that are not easy to resolve. So, in this case, we ended up splitting the installation to different machines and have been sleeping much better at night.