Saturday 17 November 2012

Debug Security Log ON/OFF

Very simple configuration but import if you want to debug the Security which is been playing vital role every where, Please perform the following steps in order to set the debug on/off

1) Log in to WebLogic Server
2) Navigate over left pane and select Environment->Server.
3) Select the desired server from the available servers.
4) Click on Debug tab and expand Weblogic option available in Debug Scopes and Attributes table
5) Expand the security->atn and check DebugSecurityAtn option.
6) Click on Enable/Disable button at top or bottom of the table.

Friday 16 November 2012

Users Authentication using more than one Authentication Provider

Some days backup I was completely stuck on question “How to provide access of Administration tool and presentation to user which are present in default authentication provider and external authentication provider as well”.
After some work around, yes with the help of toolbox forum and by the help of experts I got the solution. So I am just putting the points in sequence here:
1)  Log in to Enterprise Manager ex: http://Machine_Name or IP:port/em
2) Expand Weblogic Domain
3) Right click on bifoundation_doamin and then select security->Security Provider Configuration
4) Select configure button in identity store provider







5)  Click on Add












6)  Add virtual in Property Name and true in value














7)  Restart the whole BI tier


On the successful start of the services you can start login to presentation and admin tool by the user which are available in any authentication provider


Reference:
http://oracle.ittoolbox.com/groups/technical-functional/oracle-bi-l/default-user-login-issue-to-admin-and-catalog-tool-4958810#M4964790
http://docs.oracle.com/cd/E21764_01/core.1111/e10043/idstoreadm.htm

Monday 27 August 2012

How to Deploy the RPD using Shell Script

After couples of busy moths I got time and I decided to add some post in my long time stopped interaction zone. So I am starting this session with the deployment of RPD using Shell Script.

In OBIEE 11g the deployment procedure of RPD is handling by the Enterprise manager, but while doing the deployment of RPD using Enterprise Manager( to see how to deploy RPD using EM click here) I feel it is more time consuming as some time enterprise manager takes time to load the graphics.

To over come from such situation the OBIEE provides WLST(Weblogic Scripting tool), so I thought I can  pulled the hand completed, by launching the WLST and then running the RPD deployment script.then question arises can we call the WLST and the command related to WLST in shell script and I crested the following script

echo "Enter user : "
read user
echo "Enter password : "
read password
echo "Enter host(ex. adminAddress:adminPort) : "
read host
echo "Enter RPD Path and Name (ex. /~/rpd_name.rpd) : "
read rpd_path
echo "Enter RPD Password : "
read rpd_password
/export/home/oracle/
Middlewarehome/OracleBI/wlserver_10.3/common/bin/wlst.sh
connect(user,password,host)
domainCustom()
cd('oracle.biee.admin')
# Lock
print 'Obtaining lock...'
cd('oracle.biee.admin:type=BIDomain,group=Service')
objs = jarray.array([], java.lang.Object)
strs = jarray.array([], java.lang.String)
try:
invoke('lock', objs, strs)
except:
print 'Already locked'
# Lock Complete
cd('..')
# Upload
print 'Uploading repository...'
cd('oracle.biee.admin:type=BIDomain.BIInstance.ServerConfiguration,biInstance=coreapplication,group=Service')
params = jarray.array([rpd_path,rpd_password],java.lang.Object)
sign = jarray.array(['java.lang.String', 'java.lang.String'],java.lang.String)
invoke( 'uploadRepository', params, sign)
# Upload Complete
cd('..')
# Commit
print 'Applying changes...'
cd('oracle.biee.admin:type=BIDomain,group=Service')
objs = jarray.array([], java.lang.Object)
strs = jarray.array([], java.lang.String)
try:
invoke('commit', objs, strs)
except:
print 'Not Locked'
#Commit Complete
exit()

/export/home/oracle/Middlewarehome/OracleBI/instances/instance1/bin/opmnctl stopall

echo OPMNCTL Starting.......

/export/home/oracle/Middlewarehome/OracleBI/instances/instance1/bin/opmnctl startall

/export/home/oracle/Middlewarehome/OracleBI/instances/instance1/bin/opmnctl status
 I ran this script in Unix shell but rather than completing the deployment the control stopped at the "WLST:offline>" it means that user needs to provide the parameter and there is no use of opmnctl command.
 But I want to pull out hands so it is necessary to deploy the RPD and restart the services from shell script only, so I created two file once shell script and another is .PY as WLST accept only the  jython.

Deploy.sh

echo "Enter the path (from current directory) of .py file: "
read pp
[weblogic_Home]/common/bin/wlst.sh $pp
[oracle_Home]/instances/instance1/bin/opmnctl stopall

echo OPMNCTL Starting.......
[Oracle_Home]/instances/instance1/bin/opmnctl startall
[Oracle_Home]/instances/instance1/bin/opmnctl status
RPD_Deployment.py
user = raw_input("Enter user : ")
password = raw_input("Enter password : ")
host = raw_input("Enter host(ex. adminAddress:adminPort) : ")
rpd_path = raw_input("Enter RPD Path and Name (ex. C:/~/rpd_name.rpd) ")
rpd_password = raw_input("Enter RPD Password : ")
connect(user,password,host)
domainCustom()
cd('oracle.biee.admin')
# Lock
print 'Obtaining lock...'
cd('oracle.biee.admin:type=
BIDomain,group=Service')
objs = jarray.array([], java.lang.Object)
strs = jarray.array([], java.lang.String)
try:
invoke('lock', objs, strs)
except:
print 'Already locked'
# Lock Complete
cd('..')
# Upload
print 'Uploading repository...'
cd('oracle.biee.admin:type=BIDomain.BIInstance.ServerConfiguration,biInstance=coreapplication,group=Service')
params = jarray.array([rpd_path,rpd_password],java.lang.Object)
sign = jarray.array(['java.lang.String', 'java.lang.String'],java.lang.String)
invoke( 'uploadRepository', params, sign)
# Upload Complete
cd('..')
# Commit
print 'Applying changes...'
cd('oracle.biee.admin:type=BIDomain,group=Service')
objs = jarray.array([], java.lang.Object)
strs = jarray.array([], java.lang.String)
try:
invoke('commit', objs, strs)
except:
print 'Not Locked'
#Commit Complete
exit()

Now...I call the WLST launch command and all the function required to deploy the RPD through the shell script itself in Deploy.sh and provide the path of RPD_Deployment.py.
Note:To avoid the parameter pass on the shell we can also create parameter and there values in to the separate the script and use the values of them in RPD_Deployment.py



Thursday 26 April 2012

Installing a Single, Scaled-out Oracle Business Intelligence Instance on Multiple Computers OR How to scale out another OBIEE system with existing domain

In the series of OBIEE installation here I am going to discuss the Enterprise Management’s Scale-out option installation procedure.
To perform the scale out oracle business instance on multiple computer perform the following step
1)      Install the Standalone Oracle Business Intelligence Instances on one Computer called it as MASTER BI SERVER to know the procedure check the post "Enterprise Install with NEW BI SYSTEM option"
2)    Install the Enterprise install with scale-out option on another computer or we can say the system where we want to scale out the components of MASTER BI SERVER


To do the scale out on new system, need to run the OBIEE installation with enterprise install option. Before Proceeding to scaling the deployment to other servers, Please follow the following steps:

 1.Create a shared directory for the Repository Publishing Directory. The MASTER BI SERVER must have read and write access to this directory. All other Oracle BI Servers must have read access.
2. Use the Repository tab of the Deployment page in Fusion Middleware Control to designate the shared location for the Oracle BI repository

 
 
 













Sharing the Oracle BI Presentation Catalog
1. Create a network share for the Oracle BI Presentation Catalog on MASTER BI SERVER. All Presentation Services components in the cluster must have read and write access to this share.
2. Place the catalog on the network share.
3. Use the Repository tab of the Deployment page in Fusion Middleware Control to change the location of the Oracle BI Presentation Catalog to the shared location















Setting Up the Global Cache
1. Create a shared directory for the global cache MASTER BI SERVER. All Oracle BI Servers must have read and write access to this directory.
2. Use the Performance tab of the Capacity Management page in Fusion Middleware Control to set the Global cache path and Global cache size options.
















Now Run the OBIEE installer on the second machine/Server


Fill the required fields with the below information
The host name and port number for the Administrator Server domain (Created using the Create New BI System option on Server 1)
The user name and password for logging to the Weblogic Administrator Server






























 



 














just click on next and provide the security detail, once complete the installation follow the following steps:

1) Logged in to http://hostname:7001/em and 
2) Navigate over Business Intelligence->coreapplication->capacity Management->Scalability
Configure primary and secondary instance of the Cluster Control and Oracle BI Scheduler so that the primary and secondary instance of each component type are distributed across two different machines/Servers. Use the Availability tab of the Capacity Management page in Fusion Middleware Control to configure the primary and secondary instance of Cluster controller and BI schedules









Saturday 14 April 2012

Enterprise Install with NEW BI SYSTEM option

Before launch the OBIEE setup check the system specification here, and if you meets the system specification then perform the following steps to install the OBIEE using Enterprise Install-> NEW BI SYSTEM
1)






















Click on NEXT button
2) 





























Provide the Email ID and password if you want to for updates
3)

























Now select the installation type Enterprise Install
4)


























The OBIEE checks the prerequisites
5)

























Now here OBIEE provides two options Create New BI System and Scale Out BI System, select the Create New BI System
6)


























Browse Middleware home directory and select it.
7)


























Now select the component wants to configure
8)



























Provide the database details
9)

Provide the MDS schema details.
10)





























Select the port configuration mode auto or Port using Configuration file.
11)



























Provide the Email Id to specify Security Update.
12)
































On this screen the OBIEE provided the summary of installation.
13)



























Click on Install button and OBIEE will move to the installation.
14)Now just leave everything on OBIEE setup it is automatically install and configure the component you have selected.
If unfortunately installation gets fail at any setup them check first the log file in install log file. The location of log file is available on setup screen.
Some important links of OBIEE with simple install are:
Component
Web link
Presentation
http://machine_name:9704/analytics
Enterprise Manger
http://Machine_name:7001/em
Weblogic(Console)
http://Machine_Name:7001/console

Thanks..