Showing posts with label Repository. Show all posts
Showing posts with label Repository. Show all posts

Thursday, August 20, 2015

VERTICAL CLUSTERING IN OBIEE

Vertical scaling in OBIEE means adding more Business Intelligence Components to the same computer to make use of the hardware resources. There are cases when the middleware hardware is sized with many CPUs and more Memory, so in order to make use of them then we have to do vertical scaling.
Where Vertical Clustering is to do more with one BI components in one server, horizontal clustering deals more with configuring multiple instances of BI server in different boxes. This is useful not only for load sharing, but also at times when one server is down. There are more to the world of Horizontal Clustering. But I will cover this in my later post.
Coming back to Vertical Clustering…
Though there were some workaround available in 10g, Vertical Clustering has been introduced in 11g.
Unlike Horizontal, this does not provide high availability when the server itself goes down. In this type of clustering generally 3 components are clustered

  1. BI Server
  2. BI Presentation Services
  3. Java Host

That is, all the components that can act in active-active configuration can be clustered in Vertical Clustering. Other components like Scheduler, Cluster Controller which work in active-passive fashion are generally not clustered vertically.

* Log Into EM
* Navigate to the deployment section. (Since we are doing vertical clustering, we do not need to have a shared drive for the repository & the web catalogs. But again its better to identify a drive that can potentially be shared in the future with other machines as Vertical Clustering does not provide high availability (for future migration to horizontal clustering)).
* Once the drive is identified (one for RPD and the other for Web Catalog), copy the web catalog to the shared drive. In the deployment section of the Enterprise Manager, enter the shared directory details of both the RPD and the Web Catalog.
* Upload the repository (RPD) into the shared drive using the enterprise manager.

VC1

* Access the Fusion Middleware Control 11g.
* Select core application under Business Intelligence
* Select Capacity Management.
* Go to Scalability tab and click Lock and Edit Configuration. Now the Enterprise Manager will allow editing the values.

VC2

This will automatically create new instances(within the main instance) in BI EE for both the BI Server and Presentation Server(after Activating the changes). We can validate this by looking at the number of directories under
{ORACLEINSTANCE}/bifoundation/OracleBIServerComponent and
{ORACLEINSTANCE}/bifoundation/OracleBIPresentationServerComponent

VC3

Since we selected two, 2 new directories will be created for the new BI Server and Presentation Server that we added through the EM. Lets now start these new components through the capacity management interface

VC4

Once the scaling out is completed, opmn will be aware of the newly created components.
Till Next Time!

RPD NOT OPENING IN ONLINE MODE

Opening RPD in online mode is the fastest way to make incremental changes in the already running OBIEE server. Though Oracle always recommend to deploy the RPD from EM, whenever there are large changes in the RPD, users can always resort to make online changes should the scope of change is less.
RPDNot1
However, it should be noted that making change online affects performance intermittently.
In this post, I will explain to troubleshoot scenarios when RPD is not opening in online mode. The error message says Repository can only be opened as Read-Only
RPDNot2
To resolve this:
RPDNot3
Open EM
  • Go to Capacity Management
  • Select the Performance Tab
  • Uncheck the “Disallow RPD Updates” checkbox
  • Apply the change and Restart the server
You are ready to make changes again in RPD in online mode

OPEN RPD IN ONLINE MODE FOR LINUX HOSTED OBIEE

Running RPD in online mode is the best recommended approach for incremental developments. Though this is easy for Local OBIEE instances or for OBIEE instances which are hosted in Windows Environment, things are little different when your OBIEE is hosted on Linux Server.
To achieve this, we will have to create a System DSN first.
1. Open ODBC Data Sources from Administrator Tools or Type odbcad32 in Run Prompt
2. Select System DSN and click Add.
 DSN Creation
3.  Select Oracle BI Server in Create New DataSource
4. Enter the Name of ODBC connection. It is recommended to name DSN without Spaces or Special Characters
5. In the Oracle BI Server DSN Configuration step, mention Name and Server Details
MentionServerName
6. Confirm the Login ID and Password in next step
7. Check the option “Connect to Oracle BI Server to obtain default settings…” 
8. Click Finish
You are ready now to play with your RPD in Online Mode.
Happy Learning