OBIEE Online Training

Tuesday, March 12, 2013

BI Security Diagnostics Helper to Automatically Identify

Hi,

Obiee11.1.1.6.0 has one good trouble shooting feature " BI Security Diagnostics Helper to Automatically Identify" 

It's mainly used to  identify problems with your Oracle BI system.

You have to run a setup script before you deploy and run the application.

Once deployed you can start diagnosing possible security issues by accessing the Oracle BI Security Diagnostics Helper URL in a Web browser.

Setting Up the Oracle BI Security Diagnostics Helper Using a Script,

You must run a script before using the Oracle BI Security Diagnostics Helper for the first time use to ensure the Oracle BI Security Diagnostics Helper is setup correctly. The script grants the correct permissions to run the diagnostic checks. If you have already run the setup script you do not need to run it again.

You must run the script named addDiagnosticsCodeGrant.py for first time use only, to ensure that the Oracle BI Security Diagnostics Helper is setup correctly.

In Windows, the scripts directory is located in:
MW_HOME\ORACLE_HOME\bifoundation\admin\scripts
wlst.cmd D:\Oracle\Middleware\Oracle_BI1\bifoundation\admin\scripts\addDiagnosticsCodeGrant.py weblogic Admin123 t3://deva:7001
Note: syntax,
mw_home/Oracle_BI1/common/bin/wlst.cmd addDiagnosticsCodeGrant.py t3://<WebLogic_host_name>:<WebLogic_port_number>
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Admin>d:
D:\>cd D:\Oracle\Middleware\Oracle_BI1\common\bin
D:\Oracle\Middleware\Oracle_BI1\common\bin>wlst.cmd D:\Oracle\Middleware\Oracle_
BI1\bifoundation\admin\scripts\addDiagnosticsCodeGrant.py weblogic Admin123 t3:/
/deva:7001
CLASSPATH=D:\Oracle\MIDDLE~1\patch_wls1036\profiles\default\sys_manifest_classpa
th\weblogic_patch.jar;D:\Oracle\MIDDLE~1\patch_ocp371\profiles\default\sys_manif
est_classpath\weblogic_patch.jar;C:\Java\jdk\lib\tools.jar;D:\Oracle\MIDDLE~1\WL
SERV~1.3\server\lib\weblogic_sp.jar;D:\Oracle\MIDDLE~1\WLSERV~1.3\server\lib\web
logic.jar;D:\Oracle\MIDDLE~1\modules\features\weblogic.server.modules_10.3.6.0.j
ar;D:\Oracle\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\Oracle\MIDDLE~1\m
odules\ORGAPA~1.1/lib/ant-all.jar;D:\Oracle\MIDDLE~1\modules\NETSFA~1.0_1/lib/an
t-contrib.jar;;D:\Oracle\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-wlstman
.jar;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\Oracle\MIDDLE~1
\ORACLE~1\common\wlst\lib\ADFSCR~1.JAR;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\l
ib\mdswlst.jar;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\
Oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\IGFWLS~1.JAR;D:\Oracle\MIDDLE~1\OR
ACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst
\RESOUR~1\jrf-wlst.jar;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1
.JAR;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\Oracle\MID
DLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\Oracle\MIDDLE~1\ORACLE~1\comm
on\wlst\RESOUR~1\OSSOIA~1.JAR;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\O
VDWLS~1.JAR;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\Ora
cle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar;D:\Oracle\MIDDLE~1\utils
\config\10.3\config-launch.jar;D:\Oracle\MIDDLE~1\WLSERV~1.3\common\derby\lib\de
rbynet.jar;D:\Oracle\MIDDLE~1\WLSERV~1.3\common\derby\lib\derbyclient.jar;D:\Ora
cle\MIDDLE~1\WLSERV~1.3\common\derby\lib\derbytools.jar;;
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
Connecting to t3://deva:7001 with userid weblogic ...
Successfully connected to Admin Server 'AdminServer' that belongs to domain 'bif
oundation_domain'.
Warning: An insecure protocol was used to connect to the
server. To ensure on-the-wire security, the SSL port or
Admin port should be used instead.
Location changed to domainRuntime tree. This is a read-only tree with DomainMBea
n as the root.
For more help, use help(domainRuntime)
Already in Domain Runtime Tree
Already in Domain Runtime Tree
Already in Domain Runtime Tree
once added successfully then restart weblogic services. after that
Deploying the Oracle BI Security Diagnostics Helper
You must deploy the Oracle BI Security Diagnostics Helper as it is not automatically deployed into the WebLogic Server during installTo deploy the Oracle BI Security Diagnostics Helper:Log in to Oracle WebLogic Server Administration Console, and click Lock & Edit in the Change Center.Click Deployments.Click Install.Select the bidiagnostics.ear fileIn Windows, the bidiagnostics.ear file is located in:MW_HOME/ORACLE_HOME/bifoundation/jeeFor example:D:\Oracle\Middleware\Oracle_BI1\bifoundation\jee\bidiagnostics.earClick Next to display the Install Application Assistant page.Select Install this deployment as an application (already selected)Click Next to display the Select deployment targets page.In the Servers area select AdminServer.Click Next, then FinishClick, Activate Changes.The Oracle BI Diagnostic Helper changes into a 'prepared' State, and can be started.The following message should appear: "All changes have been activated. No restarts are necessary".


once deployment completed then try to start services 

 Running the Oracle BI Security Diagnostics Helper

After deploying the Oracle BI Diagnostics Helper it does not automatically start, you have to run it.

To run the Oracle BI Security diagnostics helper:

Log in to Oracle WebLogic Server Administration Console, and click Lock & Edit in the Change Center.

Click Deployments.

Select the bidiagnostics checkbox.

Click Start and choose one of the following options:

- Servicing all requests.

- Servicing only administration requests.

The Oracle BI Security Diagnostics Helper is now setup and running.

When started - bidiagnostics State is set to 'Active'

then u can launch http://deva:7001/bidiagnostics/security/diagnostics.jsp
and then its automatically trouble shoot Automatically and update status on below screen ..its very easy method identify bi system diagnostics.

  1. Tests for OWSM
  2. Tests for BI System User
  3. Tests authentication of user-supplied credentials





Reference:



Thanks
Deva


Monday, March 11, 2013

Obiee 11.1.1.6.9 patchset Released


Section 1: About The Oracle Business Intelligence 11.1.1.6.9 Patchset

The Oracle Business Intelligence 11.1.1.6.9 patchset comprises a number of patches:
PatchAbstract
16287811
Patch 11.1.1.6.9 (1 of 7) Oracle Business Intelligence Installer
16287778
Patch 11.1.1.6.9 (2 of 7) Oracle Real Time Decisions
16237960
Patch 11.1.1.6.9 (3 of 7) Oracle Business Intelligence Publisher
16287840
Patch 11.1.1.6.9 (4 of 7) Oracle Business Intelligence ADF Components
16287854
Patch 11.1.1.6.9 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
16227549
Patch 11.1.1.6.9 (6 of 7) Oracle Business Intelligence
16287884
Patch 11.1.1.6.9 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer


download link:
https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=11rnbpvbb5_381&_afrLoop=206791185040684

Thanks
Deva