With the release of OBIEE 11g, Oracle has made efforts to mitigate (or at least rule out) the potential risks associated with security configuration in their new weblogic-centric model. This is achieved through a little known helper utility called the 'Oracle BI Security Diagnostics' tool. This tool gives developers the ability to:
- Diagnose security configuration issues within OBIEE
- Test BISystemUser configuration settings
- Test authentication of users
Step 1: Install the Oracle BI Security Diagnostics helper via WLST
In your unix terminal, execute the following command:e.g.
MW_HOME/ORACLE_HOME/common/bin/wlst.sh addDiagnosticsCodeGrant.py t3://<WebLogic_host_name>:<WebLogic_port_number>
mw_home/Oracle_BI1/common/bin/wlst.sh addDiagnosticsCodeGrant.py t3://localhost:7001You're going to be taken through a series of terminal interactions starting with the initalization of WLST:
Followed by log-in credentials to connect to WLST:
Step 2: Deploy bidiagnostics.ear to AdminServer
In Admin Console (default 7001/console), navigate to Deployments -> Control tab and look for a deployment called 'bidiagnostics (11.1.1)' . Check the corresponding box and click 'Install':
The deployment is a straight forward process, and after the installation is complete just make sure you set the bidiagnostic application to 'Active'.
Step 3: Access the BI Diagnostic Helper
Once the installation is complete, you can navigate to the application by accessing the following url:
http://mycomputer:7001/bidiagnostics/security/diagnostics.jspYou'll be taken to a very simple UI that will give you the opportunity to perform basic security diagnostics and (hopefully) resolve any OBIEE 11g security issues you may encounter!
Oracle Business Intelligence solutions help organizations of all sizes thrive by enabling them to discover new ways to strategize, plan, optimize business operations, and capture new market opportunities. As the market leader in Business Analytics software, Oracle delivers the most complete and integrated solution that let customers gain insight into every aspect of their business, plan ahead, and act with confidence-anytime, anywhere, on any device. Evosys, an Oracle Platinum Partner, is currently one of the fastest growing BI service providers in the EMEA.
ReplyDeleteAbout Evosys: Evosys is an Oracle Partner providing consulting services for implementation and maintenance of Oracle Applications. We are a market-focused, process-centric organization that develops and delivers innovative solutions to our customers, consistently outshining other market players.http://evosys.co.in/Business-Intelligence
For any Oracle Service, Business Partnerships, Sales Referrals, Collaborations & Tieups, Please contact business@evosys.co.in & we shall contact you immediately.
Contact Business@evosys.co.in
Dear Askjohn,
ReplyDeleteBeautifully written artickle! Can I request an overview of OBI EE architecture and caching? Please do the needful.
Hardik Srinivasaraghavan Venkataraghavan
wonderful information, I had come to know about your blog from my friend nandu , hyderabad,i have read atleast 7 posts of yours by now, and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a ton once again, Regards,
ReplyDeleteobiee training in hyderebad