OBIEE 11g Customization in windows7 64 bit platform

The intention of this post is to perform a few customizations. Version of OBIEE used is 11.1.1.6.0 and the platform it is installed in is Windows7 64 bit.

We will be referring to changing the Oracle logo visible in the login page and concurrent pages, the background image visible when signing in and signing out, and the text next to the oracle logo.

• Initially log into the Enterprise Manager using the link : http://localhost:7001/em
• Select Business Intelligence, then core application
• In the availability tab  select processes sub tab to view all the OBI Service components
• Bring down all the services using the 'Stop All' button.

Currently we have bought down all the services. Now we have to edit a few files.

To change the Oracle_logo in the login page and the concurrent inner pages, navigate to the two paths mentioned below:

C:\OBIEE11gHome\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\sk_blafp\b_mozilla_4
 

C:\OBIEE11gHome\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\sk_blafp\login


Replace the oracle_logo.png file with the corresponding image you want displayed.

This is will lead to the Oracle logo being removed and replaced by your own logo.

To change the background of the login page and the page displayed while logging out, we have to navigate to the below mentioned paths:

C:\OBIEE11gHome\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\sk_blafp\login


C:\OBIEE11gHome\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\.appmergegen_1347382400875\xmlpserver.ear\q37fhu\xdo\images


C:\OBIEE11gHome\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\bipublisher_11.1.1\gyyvtu\war\xdo\images

 Replace the file 'background_blue_whitegradient_.png'


To change the  text displayed next to the oracle logo, we have to navigate to the below mentioned path:

C:\OBIEE11gHome\Oracle_BI1\bifoundation\web\msgdb\l_en\messages

Open the productmessages.xml file. Find the portioned mentioned below:


<WebMessage name="kmsgHeaderBIBrandName"><TEXT>Business Intelligence</TEXT></WebMessage>


Replace the portion 'Business Intelligence' with the text of your liking to change the the header text.


Go to the Enterprise Manager and start the services using the 'Start All' button.

Once this is done, navigate to the OBI login page using : http://localhost:7001/analytics  and enjoy the changes made!

Cheers!

Sqldeveloper not working with Oracle11gR2 database on 64 bit windows 7

When installing Oracle11gr2 database in a 64 bit windows machine, we might encounter an issue  where in the Sql Developer  that comes along with it doesn’t work. 

This is because the sqldeveloper coming along with the 11gR2 version of the Oracle Databse doesn’t support the 64 bit OS.

 

sqldeveloper.exe is a 32-bit exe that is being shipped on Windows 64-bit and it cannot load the jdk dll's.

So how do we solve this?

Simply download the version 2.1 of Oracle SQL Developer Oracle Technology Network

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

The version 2.1 is documented as supporting 64- bit Windows platform.

Once the 64- bit sqldeveloper is doqnloaded and the java path is provided, it works perfectly.

Have a nice day!

-Gautam