BI Publisher Module Deploy and Undeploy – OBIEE

Deploying the BI Publisher Module

Below is my OC4J BI Home location . Execute this as per your environment

From command window : cd D:\OracleBI\oc4j_bi\j2ee\home

Copy : ‘Oracle_Business_Intelligence_Publisher’ folder from ‘..\OBI Installer dir\Server_Ancillary’ to D drive.

Execute below :

java -jar admin_client.jar deployer:oc4j:sryndent9g oc4jadmin oc4jadmin -deploy -file D:\Oracle_Business_Intelligence_Publisher\oc4j\xmlpserver.ear -deploymentName xmlpserver -bindAllWebApps

N.B : sryndent9g is hostname and second ‘oc4jadmin’ is my password for oc4jadmin enterprise management console .( http://sryndent9g:9704/em/)

Publisher 1

Undeploy the BI Publisher Module

cd D:\OracleBI\oc4j_bi\j2ee\home

java -jar admin_client.jar deployer:oc4j:sryndent9g oc4jadmin oc4jadmin -undeploy xmlpserver

XMLP Configuration Parameter Changes

Until and unless you change the default installation parameters you are not able to log in to BI Publisher

using below URL :  http://sryndent9g:9704/xmlpserver/

Lets change the required parameters:

1) Edit ‘xmlp-server-config.xml‘ from path D:\OracleBI\oc4j_bi\j2ee\home\applications\xmlpserver\xmlpserver\WEB-INF’ .Change the file path as below :    <file path=”D:\OracleBI\xmlp\XMLP”/>

2) Edit ‘xmlp-server-config.xml ‘ from path ‘D:\OracleBI\xmlp\XMLP\Admin\Configuration’ .Change as <property name=”SECURITY_MODEL” value=”XDO”/> . This would basically change the security model from BI Server security to BI Publisher Security. The security model uses the configuration role mapping defined under file path D:\OracleBI\xmlp\XMLP\Admin\Security\principals.xml. The encrypted password with default installer represents ‘Administrator’ always.

3) Lets restart the OC4J service and using default password for BI Publisher as ‘Administrator’ log into the system .

Publisher 2

And you will get below :

Publisher 3

Okay now BI Publisher setup has been done for Publisher based security. Lets Sign Out .

Now login to BI Presentation services using <host>:9704/analytics/saw.dll? URL and Click on BI Publisher from More products .

This would throw below error :

Oracle BI Publisher Enterprise Reporting Login: Login failed: Please contact administrator for your username/password.Error Details

This is for obvious reason because local BI Publisher authentication is not based on BI Server security mode rather default BI publisher XDO security mode and here Presentation service operates only on BI Server authentication mode. So the compatibility for authentication has been failed .

Lets make some more config changes to make it work in integrated mode followed by my next post .

N.B : OBIEE onwards there is no more hassles about deploying publisher module as full installation take all this configuration under consideration until and unless you remove Publisher module during customized installation.

Although the above material helps to understand how actually the module get installed and pretty handy for your further investigation .

Oracle XE installation in Windows 7

After installation of OBIEE ,if there is no DB it has no meaning to work only with default Oracle provided samplesales.rpd and the backend XML data.Hence tried to run Oracle 10g DB version in Windows 7 running the 10g installer after changing the mode to Windows XP Service pack 2 compatibility. Alas ! tried couple of times but unfortunately not succeeded . Typical reason behind this might be Windows 7 latest security features and there must be some problem happening with my account “Debashis” though it is having full admin rights. The entire installation works except while cloning the DB it suddenly throws exception that “TNS-Can’t connect-Permission Denied” . Looks strange ! Even for me … I can see the TNS created and DB service created in Windows Services but still hopeless . Tried to google somewhere and suggested tweaks not work for me . (I might be doing something wrong … definitely will reinvent and dig to the issue later some time).

Anyway give up hope to install 10g for the time being (maybe try with 11g some time later) and suddenly come out my mind to install the Oracle smaller DB version which is enough and good compatibility with Windows 7 .

Its pretty cool except some of the typical features are missing in this small release of only 157 MB . Table Partitioning is not working in this version . Also iSqlplus , DB Console etc . is missing .Obviously I can’t expect everything in this non-business personal DB version .

So all setup is now in place to work-out with OBIEE with back-end OracleXE database.

However clean out the previous incomplete and erroneous DB installation by running Oracle 10 g De-install wizard and found still some entry in Windows Services and wipe them out straightway from Registry and Windows Environment  variables. This is very handy tweak specially for the service that creating nuisance and clutters your services list . Type Regedit in run window and goto the below path and remove the entry your wish for . (Do it very cautiously after understand the impact ) . Here my concern is ‘Oracle service for 10g’ and I remove that.

Oracle Services in registry

OBIEE installation in Windows 7

Today I tried to install Windows 7 Ultimate on my MAC Air laptop(having bootcamp enabled) specially to see the look and feel and the features available comparing of its earlier counterparts and it seems cool . Its just a polished version of Windows Vista with couple of changes and enhancement made on Taskbar and easy navigation across explorer . In addition it is having cool “Alt+Tab” and “Windows key+Tab”  options to browse through the already open multiple windows . Moreover with my “NVIDIA GeForce 9400M” Display the default Microsoft provided desktop wallpapers looking awesome and perfectly handy with full satisfaction and faith in “Windows 7 Ultimate” .

I just become fan of this with my evaluation copy Bulid 7100 downloaded from one of the famous torrent site . Still just looking for a final and official version of Windows 7 .

Now the bottom-line of the above background is simple .I am now going to install OBIEE v (I don’t have latest patch still)  on my new installed Windows 7 .(Ah ! may I have had the same installer for MAC Leopard OS-X).

Anyway the installation process seems to be simple but it suddently throw the compatibility issue with this version of OS . However done the installation after changing the setup.exe to run in compatibility mode of Windows XP Service Pack 2 .

Voila ! Its done and absolutely cool and working fine with default samplesales.rpd .But one thing I did notice is the Lock icon set against the two BI folder .I have Admin permission and though it is showing like this . Did not bother about investigating these ,specially when all the OBIEE stuffs are working fine,which seems to be new security features of Windows 7 . Will explore it later .

OBI after Installed

Hello world!

Following the traditional approach of programming  it is nice idea to begin with something like ” Hello World ! ”  in BI page specially to show a feel good factor for those who shifted or started their journey through career in Analytics or BI space  . Here you go …..

Hello Word In DashboardHello Word HTML Code